how do change Emp category base on date

Question

i have a table in sql like following structure

Id   Emp_Id       Category_Id
1     sss             A 
2     CCC             A
3     VVV             B
4     BBB             B

I am using following code to get day from the given date

Hide Copy Code

   Int16 day = Convert.ToInt16(SafeConvert.ToDateTime(txtDate.Text).Day);

i want that if day is even then change employee with category 'A' Change to category 'B' and Employee with category B CHANGE TO 'A',IF day is odd then opposite happen without changing the original table value that is store in table by user.

Sajid Hussain · Answer

i have checked your solution that is good,but i want to change Employee category A TO B,AND B to A base on day date

Gowtham Rajamanickam · Answer

good

Syed Shanu · Answer

Did you check my sample program.is that what you are looking for?

Sajid Hussain · Answer

i am using following code ,problem is that data is not updated in respective column of the table DateTime date = SafeConvert.ToDateTime(txtDate.Text); Int16 day = Convert.ToInt16(SafeConvert.ToDateTime(txtDate.Text).Day); if (day % 2 == 0) { var empcatone = (from ec in entities.EmployeeCategories where ec.Category_Id == 1 select ec).ToList(); foreach (var Empcatone in empcatone) { Empcatone.Category_Id = 2; } var empcattwo = _service.GetAllEmployeeCategory().Where(x => x.Category_Id == 2).ToList(); foreach (var Empcattwo in empcattwo) { Empcattwo.Category_Id = 1; } } else if (day % 2 != 0) { var empcatone = _service.GetAllEmployeeCategory().Where(x => x.Category_Id == 2).ToList(); foreach (var Empcatone in empcatone) { Empcatone.Category_Id = 1; } var empcattwo = _service.GetAllEmployeeCategory().Where(x => x.Category_Id == 1).ToList(); foreach (var Empcattwo in empcattwo) { Empcattwo.Category_Id = 2; } } how can update that column

Syed Shanu · Answer

Hi, kiinly check the attached sample Source Program.In the Attached file Check for the Form2.Your solution is placed in Form2. here is my code looks like.I have created using Winform.This can be used in both Win and Web form Step 1) Add Datetime Picker,Button and datagridview Control to your form . IN Form Load event. DataTable DTable = new DataTable(); private void Form2_Load(object sender, EventArgs e) { //ServersTable - DataGridView DTable.Columns.Add(new DataColumn("ID")); DTable.Columns.Add(new DataColumn("Emp_Id")); DTable.Columns.Add(new DataColumn("Category_Id")); DataRow r = DTable.NewRow(); r.BeginEdit(); r["ID"] = "1";//writing values r["Emp_Id"] = "SS";//writing values r["Category_Id"] = "AA";//writing values r.EndEdit(); DTable.Rows.Add(r); r = DTable.NewRow(); r.BeginEdit(); r["ID"] = "2";//writing values r["Emp_Id"] = "VV";//writing values r["Category_Id"] = "AA";//writing values r.EndEdit(); DTable.Rows.Add(r); r = DTable.NewRow(); r.BeginEdit(); r["ID"] = "3";//writing values r["Emp_Id"] = "KK";//writing values r["Category_Id"] = "BB";//writing values r.EndEdit(); DTable.Rows.Add(r); r = DTable.NewRow(); r.BeginEdit(); r["ID"] = "4";//writing values r["Emp_Id"] = "ZZ";//writing values r["Category_Id"] = "BB";//writing values r.EndEdit(); DTable.Rows.Add(r); } In Button Click private void button1_Click(object sender, EventArgs e) { int value = Convert.ToInt32(dateTimePicker1.Value.Date.ToString("dd")); string expression = "Category_Id = 'AA'"; if (value % 2 != 0) { expression = "Category_Id = 'AA'"; } else { expression = "Category_Id = 'BB'"; } DataView dv = new DataView(DTable); dv.RowFilter = expression; // query example = "id = 10" dataGridView1.DataSource = dv; }