how do change Emp category base on date

Sajid Hussain

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.

5 Replies

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

Sajid Hussain11y ago
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 Rajamanickam11y ago
good
Syed Shanu11y ago
Did you check my sample program.is that what you are looking for?
Sajid Hussain11y ago
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 Shanu11y ago
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;
        }