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