private void DeductionMethod(String ID) { String ConnString = ConfigurationManager.ConnectionStrings["PayrollConn"].ConnectionString; SqlConnection Conn = new SqlConnection(ConnString); try { SqlCommand cmd = new SqlCommand("Sp_Deduct", Conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Emp_ID", ID); cmd.Parameters.AddWithValue("@DetectionAmount", DecAmount); cmd.Parameters.AddWithValue("@Reason", ReasontextBox.Text); cmd.Parameters.AddWithValue("@DateorTime", DateTime.Now.ToString()); cmd.Parameters.AddWithValue("@Month", GetSelected.Month(dt.Month)); cmd.Parameters.AddWithValue("@Year", dt.Year); Conn.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Conn.Close(); } }
public void SearchAtt() { try { String ConnString = ConfigurationManager.ConnectionStrings["PayrollConn"].ConnectionString; SqlConnection conn = new SqlConnection(ConnString); using (conn) { SqlCommand cmds = new SqlCommand("SP_getEmployeeAttendance", conn); cmds.CommandType = CommandType.StoredProcedure; cmds.Parameters.Add("@ID", SqlDbType.VarChar).Value = IDTB.Text; cmds.Parameters.AddWithValue("@Month", GetSelected.Month(DT.Month)); cmds.Parameters.AddWithValue("@Year", DT.Year); SqlDataAdapter sda = new SqlDataAdapter(cmds); DataTable dt = new DataTable(); sda.Fill(dt); ViewdataGridView.DataSource = dt; GetData = dt; } MyConnectionMethods.NoDayUpdate(); } catch (Exception) { } }
private void UpdateBtn_Click(object sender, EventArgs e) { DialogResult res = MessageBox.Show("Do You Want To Put Entry", "yes Or No", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (DialogResult.Yes == res) { String ConnString = ConfigurationManager.ConnectionStrings["PayrollConn"].ConnectionString; DateTime Time = Convert.ToDateTime(DateTime.Now); DateTime RedLine = Convert.ToDateTime("09:20:00"); String Status = ""; if (Time >= RedLine) { Status = "Late"; } else { Status = "Present"; } SqlConnection Conn = new SqlConnection(ConnString); try { SqlCommand cmd = new SqlCommand("SP_EmployeeEntry", Conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Emp_ID", ID); cmd.Parameters.AddWithValue("@Status", Status); cmd.Parameters.AddWithValue("@Date", DateTime.Now.Date.ToString()); cmd.Parameters.AddWithValue("@year", dt.Year); cmd.Parameters.AddWithValue("@Month", GetSelected.Month(dt.Month)); Conn.Open(); cmd.ExecuteNonQuery(); Entrytime(Atdid(), ID); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Conn.Close(); } } this.Close(); }
private void ViewdataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e) { String ConnString = ConfigurationManager.ConnectionStrings["PayrollConn"].ConnectionString; DateTime Time = Convert.ToDateTime(DateTime.Now); DateTime RedLine = Convert.ToDateTime(LateRedLine); String Status = ""; if (Time >= RedLine) { Status = "Late"; } else { Status = "Present"; } SqlConnection Conn = new SqlConnection(ConnString); try { String ID = ViewdataGridView[2, e.RowIndex].Value.ToString(); SqlCommand cmd = new SqlCommand("SP_EmployeeEntry", Conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Emp_ID", ID); cmd.Parameters.AddWithValue("@Status", Status); cmd.Parameters.AddWithValue("@Date", DateTime.Now.Date.ToString()); cmd.Parameters.AddWithValue("@year", dt.Year); cmd.Parameters.AddWithValue("@Month", GetSelected.Month(dt.Month)); Conn.Open(); cmd.ExecuteNonQuery(); Entrytime(Atdid(), ID); ViewdataGridView[0, e.RowIndex].Value = Status; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Conn.Close(); } }
public bool CheckPayment() { DateTime Ddt = MonthYear.Value; String ConnString = ConfigurationManager.ConnectionStrings["PayrollConn"].ConnectionString; SqlConnection conn = new SqlConnection(ConnString); SqlDataReader reader; String sql; try { using (conn) { //Statuslabel sql = "Sp_getPayment"; SqlCommand cmd1 = new SqlCommand(sql, conn); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@Search", ""); cmd1.Parameters.AddWithValue("@ID", ""); cmd1.Parameters.AddWithValue("@Month", GetSelected.Month(Ddt.Month)); cmd1.Parameters.AddWithValue("@year", Ddt.Year); conn.Open(); reader = cmd1.ExecuteReader(); reader.Read(); if (reader.HasRows) { MessageBox.Show("Now You Can Not Add Hollyday You Have Done Payment To Employess", "Payment Done", MessageBoxButtons.OK, MessageBoxIcon.Information); return(true); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } return(false); }
public bool CheckAllowance(String ID) { String ConnString = ConfigurationManager.ConnectionStrings["PayrollConn"].ConnectionString; SqlConnection conn = new SqlConnection(ConnString); SqlDataReader reader; String sql; try { using (conn) { //Statuslabel sql = "getAllowance"; SqlCommand cmd1 = new SqlCommand(sql, conn); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@Search", ""); cmd1.Parameters.AddWithValue("@ID", ID); cmd1.Parameters.AddWithValue("@Month", GetSelected.Month(DT.Month)); cmd1.Parameters.AddWithValue("@year", DT.Year); conn.Open(); reader = cmd1.ExecuteReader(); reader.Read(); if (reader.HasRows) { DialogResult res = MessageBox.Show("ID : " + reader[0] + ", Name : " + reader[1] + " " + reader[2] + " Has Already Assigned Allowance Do You Want to Assign Again", "Allowance Already Assigned", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (res == DialogResult.No) { return(true); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } return(false); }
public void GetPresent(String Id) { String ConnString = ConfigurationManager.ConnectionStrings["PayrollConn"].ConnectionString; SqlConnection conn = new SqlConnection(ConnString); SqlDataReader reader; String sql; try { using (conn) { //Statuslabel sql = "SP_getEmployeePresent"; SqlCommand cmd1 = new SqlCommand(sql, conn); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.Add("@ID", SqlDbType.VarChar).Value = Id; cmd1.Parameters.Add("@Month", SqlDbType.VarChar).Value = GetSelected.Month(SelectedMonth); cmd1.Parameters.Add("@Year", SqlDbType.VarChar).Value = SelectedYear; conn.Open(); reader = cmd1.ExecuteReader(); reader.Read(); if (reader.HasRows) { // MessageBox.Show(reader[0].ToString()); // AbsenceTextBox.Text Present_Working_Days = reader[0].ToString(); } else { Present_Working_Days = "0"; } } } catch (Exception) { // MessageBox.Show(ex.Message); } }
//public void GetAbsent() //{ // String ConnString = ConfigurationManager.ConnectionStrings["PayrollConn"].ConnectionString; // SqlConnection conn = new SqlConnection(ConnString); // SqlDataReader reader; // String sql; // try // { // using (conn) // { // //Statuslabel // sql = "SP_getEmployeeAbsent"; // SqlCommand cmd1 = new SqlCommand(sql, conn); // cmd1.CommandType = CommandType.StoredProcedure; // cmd1.Parameters.Add("@ID", SqlDbType.VarChar).Value = IDTB.Text; // cmd1.Parameters.AddWithValue("@Month", MonthcomboBox.Text); // cmd1.Parameters.AddWithValue("@Year", YearcomboBox.Text); // conn.Open(); // reader = cmd1.ExecuteReader(); // reader.Read(); // if (reader.HasRows) // { // // MessageBox.Show(reader[0].ToString()); // // Absencelabel.Text = reader[0].ToString(); // } // else // { // MessageBox.Show("It Does Not Exist", "Emply", MessageBoxButtons.OK, MessageBoxIcon.Error); // } // } // } // catch (Exception ex) // { // MessageBox.Show(ex.Message); // } //} public void GetLate() { String ConnString = ConfigurationManager.ConnectionStrings["PayrollConn"].ConnectionString; SqlConnection conn = new SqlConnection(ConnString); SqlDataReader reader; String sql; try { using (conn) { //Statuslabel sql = "SP_getEmployeeLate"; SqlCommand cmd1 = new SqlCommand(sql, conn); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.Add("@ID", SqlDbType.VarChar).Value = IDTB.Text; cmd1.Parameters.AddWithValue("@Month", GetSelected.Month(DT.Month)); cmd1.Parameters.AddWithValue("@Year", DT.Year); conn.Open(); reader = cmd1.ExecuteReader(); reader.Read(); if (reader.HasRows) { // MessageBox.Show(reader[0].ToString()); Latelabel.Text = reader[0].ToString(); } else { MessageBox.Show("It Does Not Exist", "Emply", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void GetDeduction() { String ConnString = ConfigurationManager.ConnectionStrings["PayrollConn"].ConnectionString; SqlConnection conn = new SqlConnection(ConnString); SqlDataReader reader; String sql; try { using (conn) { //Statuslabel sql = "getDetection"; SqlCommand cmd1 = new SqlCommand(sql, conn); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@Search", ""); cmd1.Parameters.AddWithValue("@ID", IDTB.Text); cmd1.Parameters.AddWithValue("@Month", GetSelected.Month(DT.Month)); cmd1.Parameters.AddWithValue("@year", DT.Year); conn.Open(); reader = cmd1.ExecuteReader(); reader.Read(); if (reader.HasRows) { // MessageBox.Show(reader[3].ToString()); DeductedAmountTB.Text = reader[3].ToString(); } else { DeductedAmountTB.Text = "No Deducted Amount"; } } } catch (Exception ex) { // MessageBox.Show(ex.Message); } }
private void GetHollyday() { String ConnString = ConfigurationManager.ConnectionStrings["PayrollConn"].ConnectionString; SqlConnection conn = new SqlConnection(ConnString); SqlDataReader reader; String sql; try { using (conn) { //Statuslabel sql = "Sp_getHollydayForAtd"; SqlCommand cmd1 = new SqlCommand(sql, conn); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@Month", GetSelected.Month(SelectedMonth)); cmd1.Parameters.AddWithValue("@year", SelectedYear); conn.Open(); reader = cmd1.ExecuteReader(); reader.Read(); if (reader.HasRows) { //MessageBox.Show(reader[0].ToString());+ if (reader[0].ToString() != null) { Hollydays = int.Parse(reader[0].ToString()); } } } } catch (Exception ex) { //MessageBox.Show("HollyDay" + ex.Message); } }
public void GetHalfDays() { String ConnString = ConfigurationManager.ConnectionStrings["PayrollConn"].ConnectionString; SqlConnection conn = new SqlConnection(ConnString); SqlDataReader reader; String sql; try { using (conn) { //Statuslabel sql = "GetHalfDays"; SqlCommand cmd1 = new SqlCommand(sql, conn); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.Add("@ID", SqlDbType.VarChar).Value = IDTB.Text; cmd1.Parameters.AddWithValue("@Month", GetSelected.Month(DT.Month)); cmd1.Parameters.AddWithValue("@Year", DT.Year); conn.Open(); reader = cmd1.ExecuteReader(); reader.Read(); // MessageBox.Show(reader[0].ToString()); if (reader.HasRows) { // MessageBox.Show(reader[0].ToString()); halfDaylabel.Text = reader[0].ToString(); } } } catch (Exception ex) { /// MessageBox.Show(ex.Message); } }
private void AddRecord() { DateTime Ddt = MonthYear.Value; String ConnString = ConfigurationManager.ConnectionStrings["PayrollConn"].ConnectionString; SqlConnection Conn = new SqlConnection(ConnString); try { SqlCommand cmd = new SqlCommand("Sp_AddHollyday", Conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@DateTime", Dt); cmd.Parameters.AddWithValue("@Days", DaystextBox.Text); cmd.Parameters.AddWithValue("@Hollyday", HollydaysTb.Text); cmd.Parameters.AddWithValue("@Month", GetSelected.Month(Ddt.Month)); cmd.Parameters.AddWithValue("@Year", Ddt.Year); Conn.Open(); cmd.ExecuteNonQuery(); MessageBox.Show("Hollyday Added", "Record Inserted", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } catch (Exception) { // MessageBox.Show(ex.Message); } finally { Conn.Close(); } }
private void AddAllowanceMethod(String ID) { String ConnString = ConfigurationManager.ConnectionStrings["PayrollConn"].ConnectionString; SqlConnection Conn = new SqlConnection(ConnString); try { SqlCommand cmd = new SqlCommand("Add_Allowance", Conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Emp_ID", ID); cmd.Parameters.AddWithValue("@AllowanceAmount", AmounttextBox.Text); cmd.Parameters.AddWithValue("@Reason", ReasonCB.Text); cmd.Parameters.AddWithValue("@year", DT.Year); cmd.Parameters.AddWithValue("@Month", GetSelected.Month(DT.Month)); cmd.Parameters.AddWithValue("@AttendanceAllowance", AttendanceAllowancetb.SelectedIndex); cmd.Parameters.AddWithValue("@DateorTime", DateORTime); Conn.Open(); cmd.ExecuteNonQuery(); SearchAllowance(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Conn.Close(); } }
public void GetPresent() { String ConnString = ConfigurationManager.ConnectionStrings["PayrollConn"].ConnectionString; SqlConnection conn = new SqlConnection(ConnString); SqlDataReader reader; String sql; try { int Presents = 0; int TotalSunday = Calculate.GetSunday(MonthYear.Value); int NumberOfDays = Calculate.GetTotalDaysOfMonth(MonthYear.Value); int Totalpresents = 0; using (conn) { //Statuslabel sql = "SP_getEmployeePresent"; SqlCommand cmd1 = new SqlCommand(sql, conn); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.Add("@ID", SqlDbType.VarChar).Value = IDTB.Text; cmd1.Parameters.AddWithValue("@Month", GetSelected.Month(DT.Month)); cmd1.Parameters.AddWithValue("@Year", DT.Year); conn.Open(); reader = cmd1.ExecuteReader(); reader.Read(); if (reader.HasRows) { // MessageBox.Show(reader[0].ToString()); Presentlabel.Text = reader[0].ToString(); Presents = int.Parse(reader[0].ToString()); } else { MessageBox.Show("It Does Not Exist", "Emply", MessageBoxButtons.OK, MessageBoxIcon.Error); } } GetHollyday(); //MessageBox.Show("Hollydays " + Hollydays); //MessageBox.Show("TotalSunday " + TotalSunday); //MessageBox.Show("Presents " + Presents); Totalpresents = (Presents + TotalSunday + Hollydays); //MessageBox.Show("Totalpresents " + Totalpresents); //MessageBox.Show("NumberOfDays " + NumberOfDays); int Absence = NumberOfDays - Totalpresents; // MessageBox.Show("Absence " + Absence); if (Totalpresents < NumberOfDays) { Absencelabel.Text = Absence.ToString(); } if (Absence == 0) { Absencelabel.Text = "0"; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }