private void CLCMethod()
{
try
{
calculateDecAmount();
}
catch (Exception)
{
}
int ConvanceAll = 0;
int MedicalAll = 0;
int Houserent = 0;
try
{
Calculate.Salary(int.Parse(BasicSalarytextBox.Text), ref ConvanceAll, ref Houserent, ref MedicalAll);
TotalAmount = int.Parse(BasicSalarytextBox.Text);
TotalAmount += ConvanceAll;
TotalAmount += MedicalAll;
TotalAmount += Houserent;
//if (AttendanceAllowancetb.Text == "Yes")
//{
// TotalAmount += 1000;
//}
Amountlabel.Text = "Total Salary : " + TotalAmount.ToString();
DeductionSalaryTb.Text = "Salary After Deduction : " + (TotalAmount - DecAmount);
}
catch (Exception)
{
// MessageBox.Show(ex.Message);
}
}
public void GetPresentByDr()
{
String ConnString = ConfigurationManager.ConnectionStrings["PayrollConn"].ConnectionString;
SqlConnection conn = new SqlConnection(ConnString);
SqlDataReader reader;
String sql;
try
{
int Presents = 0;
int TotalSunday = Calculate.GetSunday(StartTimePicker.Value);
int NumberOfDays = Calculate.GetTotalDaysOfMonth(StartTimePicker.Value);
int Totalpresents = 0;
using (conn)
{
//Statuslabel
sql = "SP_getEmployeePresentBydr";
SqlCommand cmd1 = new SqlCommand(sql, conn);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.Add("@ID", SqlDbType.VarChar).Value = IDTB.Text;
cmd1.Parameters.AddWithValue("@StartDate", StartTimePicker.Value);
cmd1.Parameters.AddWithValue("@EndDate", EndTimePicker.Value);
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);
}
}
GetHollydayByDr();
Totalpresents = (Presents + TotalSunday + Hollydays);
int Absence = NumberOfDays - Totalpresents;
if (Totalpresents < NumberOfDays)
{
if (Presents > 0)
{
Absencelabel.Text = Absence.ToString();
}
else
{
Absencelabel.Text = "0";
}
}
if (Absence == 0)
{
Absencelabel.Text = "0";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void GetDataMethod(String ID)
{
String ConnString = ConfigurationManager.ConnectionStrings["PayrollConn"].ConnectionString;
SqlConnection conn = new SqlConnection(ConnString);
SqlDataReader reader;
String sql;
using (conn)
{
//Statuslabel
sql = "SP_SearchEmployee";
SqlCommand cmd1 = new SqlCommand(sql, conn);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.Add("@id", SqlDbType.VarChar).Value = ID;
conn.Open();
reader = cmd1.ExecuteReader();
reader.Read();
if (reader.HasRows)
{
// MessageBox.Show(reader[12].ToString());+
IDTB.Text = reader[0].ToString();
FirstNameTB.Text = reader[1].ToString();
LastNametextBox.Text = reader[2].ToString();
//DateOfBirthTB.Text = reader[3].ToString();
//GenderTB.Text = reader[4].ToString();
//ContacttextBox.Text = reader[5].ToString();
//NICtextBox.Text = reader[6].ToString();
//HouseNOtextBox.Text = reader[7].ToString();
//AddLine1Tb.Text = reader[8].ToString();
//AddLine2tb.Text = reader[9].ToString();
//postCodetextBox.Text = reader[10].ToString();
DepartmentTextBoc.Text = reader[11].ToString();
designationtextBox.Text = reader[12].ToString();
// StatuscomboBox.Text = "" + reader[13];
// DateOfHired.Text = reader[14].ToString();
BasicSalarytextBox.Text = reader[15].ToString();
// JobTitletextBox.Text = reader[16].ToString();
////PassTb.Text = reader[17].ToString();
// dateTimePicker1.Value = DateTime.Now;
AddedAllowanceTB.Clear();
DeductedAmountTB.Clear();
NetSalaryTB.Clear();
MonthYear.Enabled = true;
}
else
{
MessageBox.Show("It Does Not Exist", "Emply", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
try
{
int ConvanceAll = 0;
int MedicalAll = 0;
int Houserent = 0;
Calculate.Salary(int.Parse(BasicSalarytextBox.Text), ref ConvanceAll, ref Houserent, ref MedicalAll);
TotalAmount = int.Parse(BasicSalarytextBox.Text);
TotalAmount += ConvanceAll;
TotalAmount += MedicalAll;
TotalAmount += Houserent;
ConvancetextBox.Text = "" + ConvanceAll;
HouseRentTextBoc.Text = "" + Houserent;
MedicalAlltextBox.Text = "" + MedicalAll;
TotalAmounttextBox.Text = "" + TotalAmount.ToString();
if (Calculate.IncomeText(int.Parse(BasicSalarytextBox.Text)) == 0)
{
IncomeTextextBox.Text = "No Tex Applied";
}
else
{
IncomeTextextBox.Text = "" + Calculate.IncomeText(int.Parse(BasicSalarytextBox.Text));
incomeTex = Calculate.IncomeText(int.Parse(BasicSalarytextBox.Text));
}
}
catch (Exception)
{
}
}
