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