예제 #1
0
        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);
        }