private void btnDeptSave_Click(object sender, EventArgs e) { if (payroll_department_name.Text != "") { string table = "tbl_payroll_department"; string[] column_name = { "payroll_department_name" }; string[] column_value = { payroll_department_name.Text }; dbcon.Insert(table, column_name, column_value, "", null, true); this.LoadActiveCompany(); this.LoadArchiveCompany(); // 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", "Add new Department named " + payroll_department_name.Text + "", DateTime.Now.ToString("yyyyMMddHHmmss").ToString() }; dbcon.Insert(table2, column_name2, column_value2, "", null, false); payroll_department_name.Text = ""; btnDeptArchived.Enabled = false; btnDeptEdit.Enabled = false; } else { MessageBox.Show("Please input a Department Name", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnJobSave_Click(object sender, EventArgs e) { if (payroll_jobtitle_department_id.SelectedItem != null) { string table = "tbl_payroll_jobtitle"; string[] column_name = { "payroll_jobtitle_department_id", "payroll_jobtitle_name" }; string[] column_value = { payroll_jobtitle_department_id.SelectedValue.ToString(), payroll_jobtitle_name.Text }; dbcon.Insert(table, column_name, column_value, "", null, true); this.LoadActiveJob(); this.LoadArchiveJob(); // 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", "Add new 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 = ""; btnJobArchived.Enabled = false; btnJobEdit.Enabled = false; } else { MessageBox.Show("Please select a Department", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
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 btnCompanySave_Click(object sender, EventArgs e) { bool complete = true; foreach (Control c in CompanyPanel.Controls) { if (c is TextBox) { if (c.Text == "" && c.Name != "payroll_company_id") { MessageBox.Show(c.Tag.ToString() + " is Required", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); complete = false; c.Focus(); break; } } } if (complete == true) { 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[] column_name = { "payroll_company_name", "payroll_company_code", "payroll_company_address", "payroll_company_contact", "payroll_company_email", "payroll_company_nature_of_business", "payroll_company_account_no", "payroll_company_tin", "payroll_company_sss", "payroll_company_philhealth", "payroll_company_pagibig", "payroll_company_archived", "payroll_company_rdo", "payroll_company_bank", "payroll_company_date_started" }; string table = "tbl_payroll_company"; string[] column_value = { payroll_company_name.Text, payroll_company_code.Text, payroll_company_address.Text, payroll_company_code.Text, payroll_company_email.Text, payroll_company_nature_of_business.Text, payroll_company_account_no.Text, payroll_company_tin.Text, payroll_company_sss.Text, payroll_company_philhealth.Text, payroll_company_pagibig.Text, "0", payroll_company_rdo.SelectedValue.ToString(), payroll_company_bank.SelectedValue.ToString(), payroll_company_date_started.Value.ToString("yyyy-MM-dd") }; string picturecolumn = "payroll_company_logo"; if (dbcon.CheckRecord(table) != "Exist") { //insert company dbcon.Insert(table, column_name, column_value, picturecolumn, picturevalue, 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", "Add new Company named " + payroll_company_name.Text + "", DateTime.Now.ToString("yyyyMMddHHmmss").ToString() }; dbcon.Insert(table2, column_name2, column_value2, "", null, false); //load company to datagrid companycontroller.LoadCompany(payroll_company_datagrid); //clear textboxes and picture CompanyPanel.Controls.OfType <TextBox>().ToList().ForEach(textBox => textBox.Clear()); payroll_company_logo.Image = null; btnCompanySave.Enabled = false; } else { MessageBox.Show("Only one Company is allowed", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
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(); }