/*public void tcs()
* {
* SignInEmp ae = new SignInEmp();
* EmpInfoLinqDataContext cntx = new EmpInfoLinqDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\Project Salary Manager\SalaryManager\SalaryManager\EmpployeeInfo.mdf;Integrated Security=True;Connect Timeout=30");
* var str = from a in cntx.Travels
* select a;
* Travel p = str.Where(obj => obj.Id2 == ae.id2).First();
* TravelC tc = new TravelC();
* p.Cause = tc.Cau;
* p.Division = tc.Div;
* p.From = tc.Frm;
* p.To = tc.Too;
* p.TicketPrice = tc.TP;
* p.TravelledBy = tc.TrvB;
* cntx.SubmitChanges();
*
* }*/
public void TPayment()
{
SignInEmp ae = new SignInEmp();
EmpInfoLinqDataContext cntx = new EmpInfoLinqDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\Project Salary Manager\SalaryManager\SalaryManager\EmpployeeInfo.mdf;Integrated Security=True;Connect Timeout=30");
var str = from a in cntx.SalaryGs
select a;
SalaryG p = str.Where(obj => obj.SalaryGrade == ae.SalGrade).First();
FPayment fp = new FPayment();
fp.Bas = Convert.ToInt32(p.Salary);
fp.Hoal = Convert.ToInt32(p.HomeAlp);
fp.Heal = Convert.ToInt32(p.HealthAlp);
fp.BON = Convert.ToInt32(p.Bonus);
//taxC(fp.Bas);
}
private void QueryTax_Load(object sender, EventArgs e)
{
SignInEmp si = new SignInEmp();
TaxIn ti = new TaxIn();
AddEmp2 ae = new AddEmp2();
FPayment fp = new FPayment();
EmpInfoLinqDataContext cntx = new EmpInfoLinqDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\Project Salary Manager\SalaryManager\SalaryManager\EmpployeeInfo.mdf;Integrated Security=True;Connect Timeout=30");
var str = from a in cntx.Loans_Leaves
where a.Id2 == si.id2
select a;
Loans_Leave tsl = str.First();
metroLabel2.Text = DateTime.Now.ToString("yyyy");
metroLabel32.Text = Convert.ToString(tsl.SavingsAccount);
ae.TPayment();
EmpInfoLinqDataContext cntx1 = new EmpInfoLinqDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\Project Salary Manager\SalaryManager\SalaryManager\EmpployeeInfo.mdf;Integrated Security=True;Connect Timeout=30");
var str1 = from a in cntx1.taxAndSals
where a.Id2 == si.id2
select a;
taxAndSal tt = str1.First();
metroLabel30.Text = Convert.ToString(tt.PendingTax);
}
private void TakePayment_Load(object sender, EventArgs e)
{
metroButton1.Enabled = false;
metroButton3.Enabled = false;
SignInEmp ae = new SignInEmp();
metroLabel20.Text = DateTime.Now.ToString("dd : MM : yyyy");
AddEmp2 ae1 = new AddEmp2();
FPayment fp = new FPayment();
LoanLeaveC llc = new LoanLeaveC();
ae1.TPayment();
metroLabel2.Text = Convert.ToString(fp.Bas);
metroLabel4.Text = Convert.ToString(fp.Hoal);
metroLabel5.Text = Convert.ToString(fp.Heal);
SignInEmp si = new SignInEmp();
EmpInfoLinqDataContext cntx = new EmpInfoLinqDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\Project Salary Manager\SalaryManager\SalaryManager\EmpployeeInfo.mdf;Integrated Security=True;Connect Timeout=30");
var str = from a in cntx.CheckIns
select a;
CheckIn p = str.Where(obj => obj.Id2 == si.id2).First();
{
if (Convert.ToInt32(p.PCheckInMark) > 65)
{
metroLabel13.Text = Convert.ToString(((fp.BON * fp.Bas) / 100) + 5000);
}
else
{
metroLabel13.Text = Convert.ToString((fp.BON * fp.Bas) / 100);
}
}
ae1.FindL();
metroLabel7.Text = Convert.ToString(llc.TPA);
}
