//string query -> query
//ComboBox combobox -> combobox
//string tables -> table
//string displaymember -> display text
// string valuemember -> value combobox
public void FillComboBox(string query, ComboBox combobox, string table, string displaymember, string valuemember)
{
dbcon.Initialize();
if (dbcon.OpenCon() == true)
{
adapter = new MySqlDataAdapter(query, dbcon.con);
ds = new DataSet();
adapter.Fill(ds, table);
combobox.DisplayMember = displaymember;
combobox.ValueMember = valuemember;
combobox.DataSource = ds.Tables[table];
dbcon.con.Close();
}
}
public bool CheckIfLeavenameExist(string leavename)
{
bool exist = false;
if (dbcon.OpenCon() == true)
{
string query = "SELECT count(*) from tbl_payroll_leave_temp where payroll_leave_temp_name='" + leavename + "' AND payroll_leave_temp_archived=0";
cmd = new MySqlCommand(query, dbcon.con);
Int32 count = Convert.ToInt32(cmd.ExecuteScalar());
dbcon.CloseCon();
if (count > 0)
{
exist = true;
return(exist);
}
}
return(exist);
}
public MySqlDataReader GetEmployeeDetails(string empid)
{
if (dbcon.OpenCon() == true)
{
string query = "SELECT * from tbl_payroll_employee_basic where payroll_employee_id=" + empid + "";
cmd = new MySqlCommand(query, dbcon.con);
read = cmd.ExecuteReader();
read.Read();
return(read);
}
return(read);
}
private void Holiday_Load(object sender, EventArgs e)
{
this.LoadActiveHoliday();
this.LoadArchiveHoliday();
payroll_holiday_category.SelectedIndex = 0;
if (dbcon.OpenCon() == true)
{
Button box;
string query = "SELECT * from tbl_payroll_company where payroll_company_archived=0";
cmd = new MySqlCommand(query, dbcon.con);
read = cmd.ExecuteReader();
int y = 6;
while (read.Read())
{
//initialize box
box = new Button();
//set box properties
box.Location = new Point(6, y);
box.AutoSize = true;
box.Tag = read["payroll_company_id"].ToString();
box.Text = read["payroll_company_name"].ToString();
//add box to groupbox
panelHoliday.Controls.Add(box);
//add event to checkbox
int id = Convert.ToInt32(read["payroll_company_id"]);
box.Click += (se, ev) => payroll.TagEmployee(se, ev, id, "Holiday");
y += 29;
}
dbcon.CloseCon();
}
}
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 TagEmployee_Load(object sender, EventArgs e)
{
employeecontroller.LoadDepartment(payroll_filter_dept_tag);
employeecontroller.LoadJobTitle(payroll_filter_job_tag, payroll_filter_dept_tag.SelectedValue.ToString());
if (dbcon.OpenCon() == true)
{
CheckBox box;
MySqlDataReader read;
if (company_id != 0)
{
string query = "SELECT * from tbl_payroll_employee_basic where payroll_employee_company_id=" + company_id + " ORDER by payroll_employee_last_name";
MySqlCommand cmd = new MySqlCommand(query, dbcon.con);
read = cmd.ExecuteReader();
}
else
{
string query = "SELECT * from tbl_payroll_employee_basic ORDER by payroll_employee_last_name";
MySqlCommand cmd = new MySqlCommand(query, dbcon.con);
read = cmd.ExecuteReader();
}
int y = 3;
while (read.Read())
{
//initialize box
box = new CheckBox();
//set box properties
box.Location = new Point(6, y);
box.AutoSize = true;
box.Tag = read["payroll_employee_id"].ToString();
box.Text = read["payroll_employee_last_name"].ToString() + ", " + read["payroll_employee_first_name"] + " " + read["payroll_employee_middle_name"];
//add box to panel
panelEmployee.Controls.Add(box);
y += 23;
}
dbcon.CloseCon();
}
//mark check the checkbox if found in dictionary(array)
if (empid.Count != 0)
{
//loop the checkbox
foreach (Control c in panelEmployee.Controls)
{
if (c is CheckBox)
{
//if company exist in dictionary
if (empid.ContainsKey(company_id))
{
//if employee found in the dictionary
if (empid[company_id].Contains(Convert.ToInt32(c.Tag)))
{
((CheckBox)c).CheckState = CheckState.Checked;
}
}
}
}
}
}