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