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();
}