Example #1
0
 public PayrollVMModel AddAndUpdatePayrollFunc(PayrollVMModel model)//add update function
 {
     try
     {
         if (model.ID > 0)
         {
             var rec = _db.Payrolls.OrderByDescending(x => x.ID).Where(x => x.ID == model.ID).FirstOrDefault();
             rec.EmployeeID     = model.EmployeeID;
             rec.NoOfLeaves     = model.NoOfLeaves;
             rec.GrossSalary    = model.GrossSalary;
             rec.TotalDeduction = model.TotalDeduction;
             rec.NetPay         = model.NetPay;
             _db.SaveChanges();
         }
         else
         {
             Payroll _Payroll = new Payroll();
             _Payroll.EmployeeID     = model.EmployeeID;
             _Payroll.NoOfLeaves     = model.NoOfLeaves;
             _Payroll.GrossSalary    = model.GrossSalary;
             _Payroll.TotalDeduction = model.TotalDeduction;
             _Payroll.NetPay         = model.NetPay;
             _db.Payrolls.Add(_Payroll);
             _db.SaveChanges();
             model.ID = _Payroll.ID;
         }
     }
     catch (Exception ex)
     {
     }
     return(model);
 }
Example #2
0
        protected void Submit_Click(object sender, EventArgs e)//Add update
        {
            PayrollVMModel vmModel = new PayrollVMModel();

            vmModel.EmployeeID     = Convert.ToInt32(EmployeeID.Text);
            vmModel.NoOfLeaves     = Convert.ToDecimal(NoOfLeaves.Text);
            vmModel.GrossSalary    = Convert.ToDecimal(GrossSalary.Text);
            vmModel.TotalDeduction = Convert.ToDecimal(TotalDeduction.Text);
            vmModel.NetPay         = Convert.ToDecimal(NetPay.Text);
            if (HiddenField1.Value != "")
            {
                vmModel.ID = Convert.ToInt32(HiddenField1.Value);
            }
            vmModel = iPayrollInterface.AddAndUpdatePayrollFunc(vmModel);
            if (vmModel.ID > 0)
            {
                Response.Write("<script>alert('Record saved successfully')</script>");
                Response.Redirect("Payroll.aspx");
            }
            bindGrid();
        }