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