Cases of type string in C#?

onmyway365 .

Hi all,

I am trying to create a data validation rule where the values are of the type string, and if the values do not match the given option, it updates the database field with the appropriate message:

Any suggestions on what I have below (or perhaps something else)?

public static void Validate()

{

using (var stageContext = new StagingTableDataContext())

{

var data = stageContext.ProjectMasters;

foreach (var sourceDataEntry in data)

if (sourceDataEntry.Finance_Project_Region != "Gauteng") ||

(sourceDataEntry.Finance_Project_Region != "Free State") ||
(sourceDataEntry.Finance_Project_Region != "Limpopo") ||
(sourceDataEntry.Finance_Project_Region != "Kwazulu Natal") ||
(sourceDataEntry.Finance_Project_Region != "Western Cape");

{

sourceDataEntry.Processing_Result = 2;
sourceDataEntry.Processing_Result_Text = "Incorrect Province";
sourceDataEntry.Processed_Datetime = DateTime.Now;

}

stageContext.SubmitChanges();

}

Thank you in advance!

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra10y ago
Accepted answer
Try with below code:

public static void Validate()
{
using (var stageContext = new StagingTableDataContext())
{
var data = stageContext.ProjectMasters.Where(u => u.Processing_Result == 0);

foreach (var sourceDataEntry in data)
{

//Project Number
if (sourceDataEntry.Finance_Project_Number == null)
{
sourceDataEntry.Processing_Result = 2;
sourceDataEntry.Processing_Result_Text = "No Project Number";
sourceDataEntry.Processed_Datetime = DateTime.Now;
}
else if (sourceDataEntry.Finance_Project_Number == "")
{
sourceDataEntry.Processing_Result = 2;
sourceDataEntry.Processing_Result_Text = "No Project Number";
sourceDataEntry.Processed_Datetime = DateTime.Now;
}
//Project Type
if (sourceDataEntry.Finance_Project_Type == null)
{
sourceDataEntry.Processing_Result = 2;
sourceDataEntry.Processing_Result_Text = "No Project Type";
sourceDataEntry.Processed_Datetime = DateTime.Now;
}
else if (sourceDataEntry.Finance_Project_Type == "")
{
sourceDataEntry.Processing_Result = 2;
sourceDataEntry.Processing_Result_Text = "No Project Type";
sourceDataEntry.Processed_Datetime = DateTime.Now;
}
//Project Region
if (sourceDataEntry.Finance_Project_Region == null)
{
sourceDataEntry.Processing_Result = 2;
sourceDataEntry.Processing_Result_Text = "No Project Type";
sourceDataEntry.Processed_Datetime = DateTime.Now;
}
else if (sourceDataEntry.Finance_Project_Region == "")
{
sourceDataEntry.Processing_Result = 2;
sourceDataEntry.Processing_Result_Text = "No Project Region";
sourceDataEntry.Processed_Datetime = DateTime.Now;
}

if ((sourceDataEntry.Finance_Project_Region != "Gauteng") ||
(sourceDataEntry.Finance_Project_Region != "Free State") &&
(sourceDataEntry.Finance_Project_Region != "Limpopo") ||
(sourceDataEntry.Finance_Project_Region != "Kwazulu Natal") ||
(sourceDataEntry.Finance_Project_Region != "Western Cape"))
{
stageContext.SubmitChanges();
}

}
}

}
+2
onmyway365 .10y ago
Apologies - I did accept the answer, but it seems there is some Google+ issues with the site.
0
Manas Mohapatra10y ago
If it helps you please accept the answer.
0
onmyway365 .10y ago
Ahhh! Great, thank you! So it was just the missing double (())?
0
onmyway365 .10y ago
On this line: if (sourceDataEntry.Finance_Project_Region != "Gauteng") || But only on the ||
0
Manas Mohapatra10y ago
At which line it is showing compilation error.
0
onmyway365 .10y ago
My mistake; when writing the question i did not add the {. The actual code is part of the code below (still get the same error - "invalid expression term"):

public static void Validate()
{
using (var stageContext = new StagingTableDataContext())
{
var data = stageContext.ProjectMasters.Where(u => u.Processing_Result == 0);
foreach (var sourceDataEntry in data)
{
//Project Number
if (sourceDataEntry.Finance_Project_Number == null)
{
sourceDataEntry.Processing_Result = 2;
sourceDataEntry.Processing_Result_Text = "No Project Number";
sourceDataEntry.Processed_Datetime = DateTime.Now;
}
else if (sourceDataEntry.Finance_Project_Number == "")
{
sourceDataEntry.Processing_Result = 2;
sourceDataEntry.Processing_Result_Text = "No Project Number";
sourceDataEntry.Processed_Datetime = DateTime.Now;
}
//Project Type
if (sourceDataEntry.Finance_Project_Type == null)
{
sourceDataEntry.Processing_Result = 2;
sourceDataEntry.Processing_Result_Text = "No Project Type";
sourceDataEntry.Processed_Datetime = DateTime.Now;
}
else if (sourceDataEntry.Finance_Project_Type == "")
{
sourceDataEntry.Processing_Result = 2;
sourceDataEntry.Processing_Result_Text = "No Project Type";
sourceDataEntry.Processed_Datetime = DateTime.Now;
}
//Project Region
if (sourceDataEntry.Finance_Project_Region == null)
{
sourceDataEntry.Processing_Result = 2;
sourceDataEntry.Processing_Result_Text = "No Project Type";
sourceDataEntry.Processed_Datetime = DateTime.Now;
}
else if (sourceDataEntry.Finance_Project_Region == "")
{
sourceDataEntry.Processing_Result = 2;
sourceDataEntry.Processing_Result_Text = "No Project Region";
sourceDataEntry.Processed_Datetime = DateTime.Now;
}
if (sourceDataEntry.Finance_Project_Region != "Gauteng") ||
(sourceDataEntry.Finance_Project_Region != "Free State") &&
(sourceDataEntry.Finance_Project_Region != "Limpopo") ||
(sourceDataEntry.Finance_Project_Region != "Kwazulu Natal") ||
(sourceDataEntry.Finance_Project_Region != "Western Cape");
{

stageContext.SubmitChanges();
}
}
}
+1
Manas Mohapatra10y ago
A curly braces "{" is missing near by to for loop. Try with below code:

public static void Validate()
{
   using (var stageContext = new StagingTableDataContext())
   {
      var data = stageContext.ProjectMasters;

      foreach (var sourceDataEntry in data)
      {
         if (sourceDataEntry.Finance_Project_Region != "Gauteng") ||
            (sourceDataEntry.Finance_Project_Region != "Free State") ||
            (sourceDataEntry.Finance_Project_Region != "Limpopo") ||
            (sourceDataEntry.Finance_Project_Region != "Kwazulu Natal") ||
            (sourceDataEntry.Finance_Project_Region != "Western Cape");
         {
            sourceDataEntry.Processing_Result = 2;
             sourceDataEntry.Processing_Result_Text = "Incorrect Province";
            sourceDataEntry.Processed_Datetime = DateTime.Now;
         }
      }

      stageContext.SubmitChanges();
   }
}
+1
onmyway365 .10y ago
I have tried both "||" & "&&" but get a message "invalid expression term"
0
Manas Mohapatra10y ago
Are you getting any error/exception using your code. Your code looks OK.
0