private void btnDeptArchived_Click(object sender, EventArgs e)
{
string table = "tbl_payroll_department";
string idvalue = payroll_department_id.Text;
string primarykey = "payroll_department_id";
string[] columnandvalues = { "payroll_department_archived='1'" };
dbcon.Update(table, columnandvalues, idvalue, primarykey, "", null);
this.LoadActiveCompany();
this.LoadArchiveCompany();
btnDeptArchived.Enabled = false;
btnDeptSave.Enabled = true;
btnDeptEdit.Enabled = false;
// insert audit logs
string table2 = "tbl_payroll_audit_logs";
string[] column_name2 = { "payroll_audit_logs_user",
"payroll_audit_logs_changes",
"payroll_audit_logs_datetime" };
string[] column_value2 = { "nethken", "Archived Department named " + payroll_department_name.Text + "",
DateTime.Now.ToString("yyyyMMddHHmmss").ToString() };
dbcon.Insert(table2, column_name2, column_value2, "", null, false);
payroll_department_name.Text = "";
}
private void btnJobEdit_Click(object sender, EventArgs e)
{
string table = "tbl_payroll_jobtitle";
string idvalue = payroll_jobtitle_id.Text;
string primarykey = "payroll_jobtitle_id";
string[] columnandvalues = { "payroll_jobtitle_department_id='" + payroll_jobtitle_department_id.SelectedValue.ToString() + "'", "payroll_jobtitle_name='" + payroll_jobtitle_name.Text + "'" };
dbcon.Update(table, columnandvalues, idvalue, primarykey, "", null);
this.LoadActiveJob();
this.LoadArchiveJob();
btnJobArchived.Enabled = false;
btnJobEdit.Enabled = false;
btnJobSave.Enabled = true;
// insert audit logs
string table2 = "tbl_payroll_audit_logs";
string[] column_name2 = { "payroll_audit_logs_user",
"payroll_audit_logs_changes",
"payroll_audit_logs_datetime" };
string[] column_value2 = { "nethken", "Edited Job Title named " + payroll_jobtitle_name.Text + "",
DateTime.Now.ToString("yyyyMMddHHmmss").ToString() };
dbcon.Insert(table2, column_name2, column_value2, "", null, false);
payroll_jobtitle_name.Text = "";
}
private void btnCompanyEdit_Click(object sender, EventArgs e)
{
if (dbcon.OpenCon() == true)
{
MemoryStream stream = new MemoryStream();
if (payroll_company_logo.Image != null)
{
payroll_company_logo.Image.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
}
byte[] picturevalue = stream.ToArray();
string picturecolumn = "payroll_company_logo";
string table = "tbl_payroll_company";
string idvalue = payroll_company_id.Text;
string primarykey = "payroll_company_id";
string[] columnandvalues = { "payroll_company_name='" + payroll_company_name.Text + "'", "payroll_company_code='" + payroll_company_code.Text + "'",
"payroll_company_address='" + payroll_company_address.Text + "'", "payroll_company_contact='" + payroll_company_contact.Text + "'",
"payroll_company_email='" + payroll_company_email.Text + "'", "payroll_company_nature_of_business='" + payroll_company_nature_of_business.Text + "'",
"payroll_company_account_no='" + payroll_company_account_no.Text + "'", "payroll_company_tin='" + payroll_company_tin.Text + "'",
"payroll_company_sss='" + payroll_company_sss.Text + "'", "payroll_company_philhealth='" + payroll_company_philhealth.Text + "'",
"payroll_company_pagibig='" + payroll_company_pagibig.Text + "'", "payroll_company_archived='0'", "payroll_company_rdo='" + payroll_company_rdo.SelectedValue.ToString() + "'",
"payroll_company_bank='" + payroll_company_bank.SelectedValue.ToString() + "'", "payroll_company_date_started='" + payroll_company_date_started.Value.ToString("yyyy-MM-dd") + "'" };
dbcon.Update(table, columnandvalues, idvalue, primarykey, picturecolumn, picturevalue);
// insert audit logs
string table2 = "tbl_payroll_audit_logs";
string[] column_name2 = { "payroll_audit_logs_user",
"payroll_audit_logs_changes",
"payroll_audit_logs_datetime" };
string[] column_value2 = { "nethken", "Edited Company named " + payroll_company_name.Text + "",
DateTime.Now.ToString("yyyyMMddHHmmss").ToString() };
dbcon.Insert(table2, column_name2, column_value2, "", null, false);
companycontroller.LoadCompany(payroll_company_datagrid);
//clear textboxes and picture
CompanyPanel.Controls.OfType <TextBox>().ToList().ForEach(textBox => textBox.Clear());
payroll_company_logo.Image = null;
btnCompanyEdit.Enabled = false;
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (dbcon.OpenCon() == true)
{
//update holiday
string table = "tbl_payroll_holiday";
string idvalue = payroll_holiday_id.Text;
string primarykey = "payroll_holiday_id";
string[] columnandvalues = { "payroll_holiday_name='" + payroll_holiday_name.Text + "'",
"payroll_holiday_date='" + payroll_holiday_date.Value.ToString("yyyy-MM-dd") + "'",
"payroll_holiday_category='" + payroll_holiday_category.SelectedItem.ToString() + "'" };
dbcon.Update(table, columnandvalues, idvalue, primarykey, "", null);
//delete the tagged employees in the database
string where1 = "payroll_holiday_id=" + payroll_holiday_id.Text + "";
string where2 = "holiday_company_id=" + payroll_holiday_id.Text + "";
dbcon.Delete("tbl_payroll_holiday_company", where1);
dbcon.Delete("tbl_payroll_holiday_employee", where2);
//insert employees
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(),
payroll_holiday_id.Text };
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(),
payroll_holiday_id.Text };
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",
"Edit 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());
}
dbcon.CloseCon();
btnSave.Enabled = true;
btnEdit.Enabled = false;
btnArchived.Enabled = false;
this.LoadActiveHoliday();
this.LoadArchiveHoliday();
TagEmployee.empid.Clear();
}