//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; } } } } } }