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