private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { textBox1.Text = DateTime.Now.ToString("dd/MM/yyyy"); string status="", salary=""; string joinD = ""; double curPayment =0.00; string q1 ="select empName,salary,status,joinDate from employeeInfo where empID='"+comboBox1.Text+"'"; string q2 = "select sum(currentPayment) from empPayment where empID='" + comboBox1.Text + "'"; SqlCommand cmd = new SqlCommand(q1, aa); try { aa.Open(); SqlDataReader dr = cmd.ExecuteReader(); while(dr.Read()) { textBox6.Text = dr.GetValue(0).ToString(); salary = dr.GetValue(1).ToString(); textBox7.Text = dr.GetValue(1).ToString(); status = dr.GetValue(2).ToString(); joinD = dr.GetValue(3).ToString(); } dr.Close(); SqlCommand cmd2 = new SqlCommand(q2, aa); SqlDataReader dr2 = cmd2.ExecuteReader(); string curPtemp = ""; while (dr2.Read()) { curPtemp = dr2.GetValue(0).ToString(); } if (curPtemp != "") { curPayment = Convert.ToDouble(curPtemp); } else { curPayment = 0.00; } dr2.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "errror!", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { aa.Close(); } //salary calculation string[] s = status.Split(' '); // MessageBox.Show(s[0] + "\t" + s[1]); if (s[0] == "Inactive") { label12.Text = "Inactive"; string activeDate = joinD; DateTime jdate = Convert.ToDateTime(activeDate); DateTime currentdate = Convert.ToDateTime(s[1].ToString()); DateDifference dateDifference = new DateDifference(jdate, currentdate); string DiffDate = dateDifference.ToString(); // MessageBox.Show(DiffDate); string[] sDD = DiffDate.Split('/'); int yy = Convert.ToInt32(sDD[0]); int mm = Convert.ToInt32(sDD[1]); int dd = Convert.ToInt32(sDD[2]); //if (dd != 0) //{ // mm += 1; //} int totalMonth = (yy * 12) + mm; textBox8.Text = totalMonth.ToString(); double totalSal = totalMonth * Convert.ToDouble(salary); double dueSal = totalSal - curPayment; textBox2.Text = dueSal.ToString(); } else if (s[0] == "Active") { label12.Text = "Active"; string activeDate = s[1].ToString(); DateTime jdate = Convert.ToDateTime(activeDate); DateTime currentdate = DateTime.Now; DateDifference dateDifference = new DateDifference(jdate,currentdate); string DiffDate = dateDifference.ToString(); string[] sDD = DiffDate.Split('/'); int yy = Convert.ToInt32(sDD[0]); int mm = Convert.ToInt32(sDD[1]); int dd = Convert.ToInt32(sDD[2]); //if (dd != 0) //{ // mm += 1; //} int totalMonth = (yy * 12) + mm; textBox8.Text = totalMonth.ToString(); double totalSal = totalMonth * Convert.ToDouble(salary); double dueSal = totalSal - curPayment; textBox2.Text = dueSal.ToString(); } else { MessageBox.Show("Error to receive data.try again..........", "warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void button3_Click(object sender, EventArgs e) { string date = "11/01/1991"; DateTime dt = Convert.ToDateTime(date); DateTime dt2 = Convert.ToDateTime("07/03/2013"); DateDifference dateDifference = new DateDifference(dt, dt2); MessageBox.Show(dateDifference.ToString()); }