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