public void deleteemployee() { EmployeeClass ds = new EmployeeClass(); ds.DeleteDetails(search.Text); }
private void button5_Click(object sender, EventArgs e) { EmployeeClass db = new EmployeeClass(); /* Database db = new Database(); * DataSet ds = db.dbse("SELECT comming_time,leave_time FROM attendance WHERE empid ='" + empid.Text + "'"); * DataSet ds1 = db.dbse("SELECT rate_per_hour,rate_per_ot_hour,basic_salary FROM attendance WHERE empid ='" + empid.Text + "'"); * DataSet ds2 = db.dbse("SELECT amount FROM loan WHERE empid ='" + empid.Text + "'"); * if ()*/ try { //string a = "1111"; String qur1 = "SELECT basic_salary FROM emp_reg WHERE empid =" + txtempid.Text + " "; // string qur1 = "SELECT * FROM emp_reg"; // +empid.Text + String qur2 = ("SELECT rate_per_hour FROM emp_reg WHERE empid ='" + txtempid.Text + "' "); String b = db.dbgett(qur1); //string b = "12"; String b1 = db.dbgett(qur2); // int rate_per_hour = Convert.ToInt32(b1); //int basic_salary = Convert.ToInt32(b); var rate_per_hour = Int32.Parse(b1); var basic_salary = Int32.Parse(b); String qur3 = ("SELECT rate_per_ot_hour FROM emp_reg WHERE empid ='" + txtempid.Text + "' "); String b2 = db.dbgett(qur3); String qur4 = ("SELECT amount FROM loan WHERE empid ='" + txtempid.Text + "' "); String b3 = db.dbgett(qur4); // int rate_per_ot_hour = Convert.ToInt32(b2); // int amount = Convert.ToInt32(b3); var rate_per_ot_hour = Int32.Parse(b2); var amount = Int32.Parse(b3); date = bunifuDatepicker1.Value.Date.ToString("yyyy-MM-dd"); DateTime date1 = Convert.ToDateTime(date); date2 = bunifuDatepicker2.Value.Date.ToString("yyyy-MM-dd"); DateTime date3 = Convert.ToDateTime(date2); // date = dateTimePicker1.Value.Date.ToString("YYYY-MM-DD"); // date2 = dateTimePicker2.Value.Date.ToString("YYYY-MM-DD"); String QU = (" SELECT SUM(work_time) FROM sal_work_hour WHERE date BETWEEN '" + date + "' AND '" + date2 + "' AND empid = '" + txtempid.Text + "' "); // MessageBox.Show(QU); String b4 = db.dbgett(QU); String QU1 = (" SELECT SUM(ot_time) FROM sal_work_hour WHERE date BETWEEN '" + date + "' AND '" + date2 + "' AND empid = '" + txtempid.Text + "' "); String b5 = db.dbgett(QU1); // MessageBox.Show(b4); // MessageBox.Show(b5); int total_work_time = Convert.ToInt32(b4); int total_ot_time = Convert.ToInt32(b5); // var total_work_time = Int32.Parse(b2); //var total_ot_time = Int32.Parse(b2); int allowences = Convert.ToInt32(allownces.Text); //if (total_work_time != 0) //{ if (allowences >= 0) { var total_salary = (total_work_time * rate_per_hour) + (total_ot_time * rate_per_ot_hour) + basic_salary - amount + allowences; label4.Text = "Total Salary is " + Convert.ToString(total_salary); addsalaryDetails(); Tsalary = Convert.ToDouble(total_salary.ToString()); } else { MessageBox.Show("invalid allownces"); } //} } catch (Exception ee) { MessageBox.Show("error" + ee); } }
public void updateemployee() { EmployeeClass ds = new EmployeeClass(); ds.UpdateDetails(fname.Text, cardid.Text, lname.Text, address1.Text, Telephone.Text, position.Text, dob.Text, gender.Text, search.Text); }