/*
* public class ComboboxItem
* {
* public string Text { get; set; }
* public string Value { get; set; }
* public override string ToString() { return Text; }
* }
*
* private void DepartmentText_SelectedIndexChanged(object sender, EventArgs e)
* {
* ComboBox DeptBox = (ComboBox)sender;
* int selectedIndex = DeptBox.SelectedIndex;
* int selectedValue = (int)DeptBox.SelectedValue;
*
* ComboboxItem selectedDept = (ComboboxItem)DeptBox.SelectedItem;
* }
*/
private void CalcButton_Click(object sender, EventArgs e)
{
EmptyError.Hide();
hours = (int)HoursWorked.Value;
initialpay = Pay / 8;
grosspay = hours * initialpay;
GrossPayText.Text = "₱" + grosspay.ToString();
finalpay = grosspay * 0.80;
DeductionsText.Text = "₱" + (grosspay - finalpay).ToString();
NetPayText.Text = "₱" + finalpay.ToString();
if (string.IsNullOrWhiteSpace(EmployeeNameText.Text))
{
EmployeeNameText.Focus();
MessageBox.Show("Please Provide Details!", "Opps! Something went wrong!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
EmptyError.Show();
}
else
{
con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|/payroll_db.accdb");
const string sql = "insert into employee(empname) values (@empname)";
cmd = new OleDbCommand(sql, con);
con.Open();
cmd.Parameters.AddWithValue("@empname", EmployeeNameText.Text);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record Saved Successfully!", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void GenInvoice_Click(object sender, EventArgs e)
{
//string deduct = DeductionsText.Text;
//string net = NetPayText.Text;
if (EmployeeNameText.Text != "" && DepartmentText.Text != "" && GrossPayText.Text != "" && DeductionsText.Text != "" && NetPayText.Text != "")
//if(string.IsNullOrEmpty(employeename + department + grosspay.ToString() + deduct + net))
{
EmptyError.Hide();
employeename = EmployeeNameText.Text;
date = DatePicker.Text;
weeks = (int)WeekChooser.Value;
department = DepartmentText.Text;
hours = (int)HoursWorked.Value;
directory = DirectoryText.Text;
if (System.IO.Directory.Exists(directory))
{
string path = directory + @"\" + employeename + @" Payslip.txt";
if (!System.IO.File.Exists(path))
{
string[] createText = { "Pay Slip",
"\n ==================== \n",
"Employer Name: iTec-Ming-Ming corp.",
"Name: " + employeename,
"Department: " + department,
"\n -------------------- \n",
"Date of Pay: " + date.ToString(),
"Week Number: " + weeks.ToString(),
"Hours Worked: " + hours.ToString(),
"\n -------------------- \n",
"Gross Pay: " + GrossPayText.Text,
"Deductions: " + DeductionsText.Text,
"Net Pay: " + NetPayText.Text,
"\n ==================== \n",
"This Serves as Official Payslip for " + employeename,
"Date of Payment: " + DateTime.Now.ToShortDateString(),
"Date Printed: " + DateTime.Now.ToLongDateString(),
"\n ==================== \n", };
System.IO.File.WriteAllLines(path, createText);
MessageBox.Show("Payslip has been created for " + employeename, "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Payslip for " + employeename + " already exists!", "Opps! Something went wrong!", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
}
else
{
MessageBox.Show("The directory does not exist!", "Opps! Something went wrong!", MessageBoxButtons.OK, MessageBoxIcon.Error);
DirErrorLabel.Show();
}
}
else
{
EmptyError.Show();
}
}
private void CalcButton_Click(object sender, EventArgs e)
{
EmptyError.Hide();
hours = (int)HoursWorked.Value;
grosspay = hours * 12;
GrossPayText.Text = "£" + grosspay.ToString();
finalpay = grosspay * 0.72;
DeductionsText.Text = "£" + (grosspay - finalpay).ToString();
NetPayText.Text = "£" + finalpay.ToString();
}
private void GenInvoice_Click(object sender, EventArgs e)
{
if (EmployeeNameText.Text != "" && DepartmentText.Text != "" && GrossPayText.Text != "" && DeductionsText.Text != "" && NetPayText.Text != "")
{
EmptyError.Hide();
employeename = EmployeeNameText.Text;
date = DatePicker.Text;
weeks = (int)WeekChooser.Value;
department = DepartmentText.Text;
hours = (int)HoursWorked.Value;
directory = DirectoryText.Text;
if (System.IO.Directory.Exists(directory))
{
string path = directory + @"\" + employeename + @" Invoice.txt";
if (!System.IO.File.Exists(path))
{
string[] createText = { "iTecCrawley Invoice",
"--------------------",
"Name: " + employeename,
"Department: " + department,
"--------------------",
"Date of Pay: " + date.ToString(),
"Week Number: " + weeks.ToString(),
"Hours Worked: " + hours.ToString(),
"--------------------",
"Gross Pay: " + GrossPayText.Text,
"Deductions: " + DeductionsText.Text,
"Net Pay: " + NetPayText.Text,
"--------------------" };
System.IO.File.WriteAllLines(path, createText);
MessageBox.Show("An invoice has been created for " + employeename);
}
else
{
MessageBox.Show("An invoice for " + employeename + " already exists");
}
}
else
{
MessageBox.Show("That directory does not exist!");
}
}
else
{
EmptyError.Show();
}
}
private void WeekChooser_Click(object sender, EventArgs e)
{
EmptyError.Hide();
}
private void HoursWorked_Click(object sender, EventArgs e)
{
EmptyError.Hide();
}
private void DepartmentText_Click(object sender, EventArgs e)
{
EmptyError.Hide();
}
private void EmployeeNameText_Click(object sender, EventArgs e)
{
EmployeeNameText.Text = "";
EmptyError.Hide();
}
private void CalcButton_Click(object sender, EventArgs e)
{
hours = (int)HoursWorked.Value;
week = (int)WeekChooser.Value;
lates = (int)latechooser.Value;
EmptyError.Hide();
EmptyError1.Hide();
totweekhour = (int)WeekChooser.Value * 40;
latefee = Pay / 60 * (int)latechooser.Value;
OTrate = Pay * 1.25;
totOT = OTrate * hours;
grosspay = Pay * totweekhour;
GrossPayText.Text = "₱ " + grosspay.ToString();
deduc = grosspay * 0.20 + latefee;
finalpay = grosspay - deduc + totOT;
DeductionsText.Text = "₱ " + deduc.ToString();
NetPayText.Text = "₱ " + finalpay.ToString();
otPaytxt.Text = "₱ " + totOT.ToString();
totallatetxt.Text = "₱ " + latefee.ToString();
totWeektxt.Text = week.ToString();
totlatetxt.Text = lates.ToString();
totOTtxt.Text = hours.ToString();
GenInvoice.Enabled = true;
//(EmployeeNameText.TextLength >= 1 && empidtxt.TextLength >= 1 && WeekChooser.Minimum >= 1 && HoursWorked.Minimum >= 1)
if (string.IsNullOrWhiteSpace(empidtxt.Text) || string.IsNullOrWhiteSpace(EmployeeNameText.Text) || WeekChooser.Minimum >= 1 && HoursWorked.Minimum >= 1)
{
var result = MessageBox.Show("Opps! Something went wrong!", "Please Provide Details!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
EmptyError.Show();
EmptyError1.Show();
//MessageBox.Show("There are still unsaved changes." + Environment.NewLine + "are you sure you want to continue?", "Textbox has been filled!", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
empidtxt.Focus();
EmployeeNameText.Focus();
WeekChooser.Focus();
HoursWorked.Focus();
}
}
else
{
string action = "Add Employee Record";
string table = "employee";
string eid = "N/A";
string today = DateTime.Now.ToString("dd/MM/yyyy h:mm tt");
const string sql1 = "insert into audittrail (adminname,[action],[tablename],eid,[accesstime]) values (@adminname,@action,@tablename,@eid,@accesstime)";
cmd1 = new OleDbCommand(sql1, con);
cmd1.Parameters.AddWithValue("@adminname", adminlabel.Text);
cmd1.Parameters.AddWithValue("[@action]", action);
cmd1.Parameters.AddWithValue("[@tablename]", table);
cmd1.Parameters.AddWithValue("[@eid]", eid);
cmd1.Parameters.AddWithValue("[@accesstime]", today);
const string sql = "insert into employee(empid,empname,deptid,dept) values (@empid,@empname,@deptid,@dept)";
cmd = new OleDbCommand(sql, con);
cmd.Parameters.AddWithValue("@empid", empidtxt.Text);
cmd.Parameters.AddWithValue("@empname", EmployeeNameText.Text);
cmd.Parameters.AddWithValue("@deptid", DepartmentText.SelectedValue);
cmd.Parameters.AddWithValue("@dept", DepartmentText.Text);
con.Open();
int result = cmd.ExecuteNonQuery();
cmd1.ExecuteNonQuery();
if (result > 0)
{
MessageBox.Show("Record Saved Successfully!", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information);
con.Close();
}
else
{
MessageBox.Show("It seems that the record does not saved successfully", "Opps! Something went wrong!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
con.Close();
}
}
/*
* if (!string.IsNullOrWhiteSpace(empidtxt.Text) && !string.IsNullOrWhiteSpace(EmployeeNameText.Text) && WeekChooser.Minimum >= 1 && HoursWorked.Minimum >= 1)
* {
* empidtxt.Focus();
* MessageBox.Show("Opps! Something went wrong!", "Please Provide Details!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
* EmptyError.Show();
* EmptyError1.Show();
* }
* else
* {
* const string sql = "insert into employee(empid,empname,deptid,dept) values (@empid,@empname,@deptid,@dept)";
* cmd = new OleDbCommand(sql, con);
* con.Open();
* cmd.Parameters.AddWithValue("@empid", empidtxt.Text);
* cmd.Parameters.AddWithValue("@empname", EmployeeNameText.Text);
* cmd.Parameters.AddWithValue("@deptid", DepartmentText.SelectedValue);
* cmd.Parameters.AddWithValue("@dept", DepartmentText.Text);
* int result = cmd.ExecuteNonQuery();
*
* if (result > 0)
* {
* MessageBox.Show("Record Saved Successfully!", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information);
* con.Close();
* }
* else
* {
* MessageBox.Show("Opps! Something went wrong!", "Please Provide Details!!!!!!!!!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
* con.Close();
* }
* }
* else if (string.IsNullOrWhiteSpace(EmployeeNameText.Text) || string.IsNullOrWhiteSpace(empidtxt.Text) || WeekChooser.Minimum == 0 || HoursWorked.Minimum == 0)
* {
* empidtxt.Focus();
* MessageBox.Show("Opps! Something went wrong!", "Please Provide Details!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
* EmptyError.Show();
* EmptyError1.Show();
* }*/
}
private void Empidtxt_Click(object sender, EventArgs e)
{
empidtxt.Text = "";
EmptyError.Hide();
EmptyError1.Hide();
}
private void GenInvoice_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(empidtxt.Text) || !string.IsNullOrWhiteSpace(EmployeeNameText.Text) || WeekChooser.Minimum >= 1 || HoursWorked.Minimum >= 1)
{
EmptyError.Hide();
EmptyError1.Hide();
empid = empidtxt.Text;
employeename = EmployeeNameText.Text;
date = DatePicker.Text;
weeks = (int)WeekChooser.Value;
department = DepartmentText.Text;
hours = (int)HoursWorked.Value;
directory = DirectoryText.Text;
if (System.IO.Directory.Exists(directory))
{
string path = directory + @"\" + employeename + @" Payslip.txt";
if (!System.IO.File.Exists(path))
{
string action = "Generate Employee Payslip";
string table = "employee";
string eid = "N/A";
string today = DateTime.Now.ToString("dd/MM/yyyy h:mm tt");
const string sql1 = "insert into audittrail (adminname,[action],[tablename],eid,[accesstime]) values (@adminname,@action,@tablename,@eid,@accesstime)";
cmd1 = new OleDbCommand(sql1, con);
cmd1.Parameters.AddWithValue("@adminname", adminlabel.Text);
cmd1.Parameters.AddWithValue("[@action]", action);
cmd1.Parameters.AddWithValue("[@tablename]", table);
cmd1.Parameters.AddWithValue("[@eid]", eid);
cmd1.Parameters.AddWithValue("[@accesstime]", today);
con.Open();
cmd1.ExecuteNonQuery();
con.Close();
string[] createText = { "Pay Slip",
"\n ==================== \n",
"Employer Name: iTec-Ming-Ming corp.",
"ID: " + empid,
"Name: " + employeename,
"Department: " + department,
"\n -------------------- \n",
"Date of Pay: " + date.ToString(),
"Number of Week(s): " + weeks.ToString(),
"OverTime Hours Worked: " + hours.ToString() + " Hr(s)",
"Late: " + totlatetxt.Text + " Minute(s)",
"\n -------------------- \n",
"Deductions:",
"Pag-ibig, SSS, HMO, Etc: 20% of Gross Pay",
"Late: " + latefee,
"Total Deductions: " + DeductionsText.Text,
"\n -------------------- \n",
"Gross Pay: " + GrossPayText.Text,
"Overtime Pay: " + otPaytxt.Text,
"Net Pay: " + NetPayText.Text,
"\n ==================== \n",
"This Serves as Official Payslip for " + employeename,
"Date of Payment: " + DateTime.Now.ToShortDateString(),
"Date Printed: " + DateTime.Now.ToLongDateString(),
"\n ==================== \n", };
System.IO.File.WriteAllLines(path, createText);
MessageBox.Show("Payslip has been created for " + employeename, "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information);
Clear();
}
else
{
MessageBox.Show("Payslip for " + employeename + " already exists!", "Opps! Something went wrong!", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
}
else
{
MessageBox.Show("The directory does not exist!", "Opps! Something went wrong!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
EmptyError.Show();
}
}
static StaticExtensionBytesExchange()
{
ErrorHandler = new EmptyError();
}
