private void btnSave_Click(object sender, EventArgs e) { if (dbcon.OpenCon() == true) { if (CheckIfLeavenameExist(payroll_leave_temp_name.SelectedItem.ToString())) { MessageBox.Show("Leave already exist!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { //insert leave temp string table = "tbl_payroll_leave_temp"; string[] column_name = { "payroll_leave_temp_is_cummulative", "payroll_leave_temp_name" }; string[] column_value = { rdnYes.Checked == true ? "1" : "0", payroll_leave_temp_name.SelectedItem.ToString() }; dbcon.Insert(table, column_name, column_value, "", null, true); //get leave temp id int leave_temp_id = dbcon.GetLastID(table, "payroll_leave_temp_id"); for (int i = 0; i < dgvTaggedEmployee.Rows.Count; i++) { Double leave_hours = Convert.ToDouble(dgvTaggedEmployee.Rows[i].Cells["leaveHours"].Value); string table2 = "tbl_payroll_leave_employee"; string[] column_name2 = { "payroll_leave_temp_id", "payroll_employee_id", "payroll_leave_temp_hours" }; string[] column_value2 = { leave_temp_id.ToString(), dgvTaggedEmployee.Rows[i].Cells["empID"].Value.ToString(), leave_hours.ToString() }; dbcon.Insert(table2, column_name2, column_value2, "", null, false); dgvTaggedEmployee.Rows.Clear(); } } } }
private void btnSave_Click(object sender, EventArgs e) { if (payroll_holiday_name.Text != "") { if (dbcon.OpenCon() == true) { //insert holiday string table = "tbl_payroll_holiday"; string[] column_name = { "payroll_holiday_name", "payroll_holiday_date", "payroll_holiday_category" }; string[] column_value = { payroll_holiday_name.Text, payroll_holiday_date.Value.ToString("yyyy-MM-dd"), payroll_holiday_category.SelectedItem.ToString() }; dbcon.Insert(table, column_name, column_value, "", null, true); int holiday_id = dbcon.GetLastID(table, "payroll_holiday_id"); foreach (KeyValuePair <int, List <int> > item in employee_id) { foreach (int value in item.Value) { //insert employee string table2 = "tbl_payroll_holiday_employee"; string[] column_name2 = { "payroll_company_id", "payroll_employee_id", "holiday_company_id" }; string[] column_value2 = { item.Key.ToString(), value.ToString(), holiday_id.ToString() }; dbcon.Insert(table2, column_name2, column_value2, "", null, false); } //insert company string table3 = "tbl_payroll_holiday_company"; string[] column_name3 = { "payroll_company_id", "payroll_holiday_id" }; string[] column_value3 = { item.Key.ToString(), holiday_id.ToString() }; dbcon.Insert(table3, column_name3, column_value3, "", null, false); } // insert audit logs string table4 = "tbl_payroll_audit_logs"; string[] column_name4 = { "payroll_audit_logs_user", "payroll_audit_logs_changes", "payroll_audit_logs_datetime" }; string[] column_value4 = { "nethken", "Add new Holiday named " + payroll_holiday_name.Text + "", DateTime.Now.ToString("yyyyMMddHHmmss").ToString() }; dbcon.Insert(table4, column_name4, column_value4, "", null, false); //clear textbox this.Controls.OfType <TextBox>().ToList().ForEach(textBox => textBox.Clear()); } } this.LoadActiveHoliday(); this.LoadArchiveHoliday(); TagEmployee.empid.Clear(); }