public ActionResult Edit(Deductions obj) { if (ModelState.IsValid) { try { var result = iDeductions.Update(obj, "u"); return(Json(new { ErrorCode = result.ErrorCode, Message = result.Msg, Id = result.Id, JsonRequestBehavior.AllowGet })); } catch (Exception ex) { return(Json(new { ErrorCode = 1, Message = ex.Message }, JsonRequestBehavior.AllowGet)); } } Response.TrySkipIisCustomErrors = true; string messages = string.Join("; ", ModelState.Values .SelectMany(x => x.Errors) .Select(x => x.ErrorMessage)); return(Json(new { ErrorCode = 1, Message = messages }, JsonRequestBehavior.AllowGet)); }
public PaycheckContext(EmployeeInfo employeeInfo, Earnings earnings, Deductions deductions, Taxes taxes, Benefits benefits) { EmployeeInfo = employeeInfo; Earnings = earnings; Deductions = deductions; Taxes = taxes; Benefits = benefits; }
public ActionResult Edit(string id) { try { Deductions obj = iDeductions.GetById(id); return(PartialView(obj)); } catch (Exception ex) { return(Json(new { ErrorCode = 1, Message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public Deductions GetById(string Id) { SqlParameter[] param = { new SqlParameter("@flag", SqlDbType.VarChar, 50) { Value = "s" } , new SqlParameter("@Id", SqlDbType.Int) { Value = Id } }; DataRow result = SqlHelper.ExecuteDataRow("spDeductions", param); Deductions obj = new Deductions(); obj.Id = Convert.ToInt32(result["Id"]); obj.Name = result["Name"].ToString(); obj.IsActive = Convert.ToBoolean(result["IsActive"].ToString()); return(obj); }
public Deductions ComputeTaxes(UserInterpreted userInterpreted) { var input = userInterpreted; Incoming = input.HoursRate * input.HoursWorked; var d = new Deductions() { Employeelocation = input.EmployeesLocation, GrossAmount = Incoming, IncomeTax = CalculateincomeTaxRate(), UniversalSocialCharge = CalculeteUniversalSocialCharge(), Pension = CompulsoryPension(), NetAmount = 0 }; d.NetAmount = d.GrossAmount - d.IncomeTax - d.UniversalSocialCharge - d.Pension; return(d); }
public DbResult Update(Deductions obj, string flag) { SqlParameter[] param = { new SqlParameter("@flag", SqlDbType.VarChar, 20) { Value = flag == "i"? "i":"u" } , new SqlParameter("@Name", SqlDbType.VarChar, 50) { Value = obj.Name } , new SqlParameter("@IsActive", SqlDbType.Bit) { Value = obj.IsActive } , new SqlParameter("@Id", SqlDbType.Int) { Value = obj.Id } }; return(SqlHelper.ParseDbResult("spDeductions", param)); }
private int checkMinutesToDeduct(int minutes) { Deductions deduct = new Deductions(); int deductions = 0; if (minutes >= deduct.LateFrom && minutes <= deduct.LateTo) { deductions = deduct.Deduction; } else if (minutes >= deduct.LateFrom2 && minutes <= deduct.LateTo2) { deductions = deduct.Deduction2; } else if (minutes >= deduct.LateFrom3 && minutes <= deduct.LateTo3) { deductions = deduct.Deduction3; } else if (minutes >= deduct.LateFrom4 && minutes <= deduct.LateTo4) { deductions = deduct.Deduction4; } return(deductions); }
public List <Deductions> List() { List <Deductions> lst = new List <Deductions>(); SqlParameter[] param = { new SqlParameter("@flag", SqlDbType.VarChar, 50) { Value = "a" } }; DataTable result = SqlHelper.ExecuteDataTable("spDeductions", param); if (result != null && result.Rows.Count > 0) { foreach (DataRow drow in result.Rows) { Deductions obj = new Deductions(); obj.Id = Convert.ToInt32(drow["Id"]); obj.Name = drow["Name"].ToString(); obj.IsActive = Convert.ToBoolean(drow["IsActive"]); lst.Add(obj); } } return(lst); }
public void ComputeSalary(DateTime?start, DateTime?end) { try { var dailyTimeRecord = db.DailyTimeRecords.Where(a => a.DateTimeStamps >= start && a.DateTimeStamps <= end).ToList(); var userList = db.Employees.ToList(); var getHoliday = db.Holidays.ToList(); foreach (var user in userList) { Deductions deduction = new Deductions(); double basicSalaryPerMinute = ((user.Salary / 9) / 60); int daysPresent = 0; foreach (var dtr in dailyTimeRecord) { foreach (var hol in getHoliday) { if (dtr.Accumulated >= 400) { if (hol.Month.Value.Month == dtr.DateTimeStamps.Value.Month && hol.Month.Value.Day == dtr.DateTimeStamps.Value.Day) { //This is a holiday. dtr.Remarks += " " + hol.HolidayName; if (hol.SalaryInrease == 30) { double percentage = 0.30 * dtr.Accumulated; // salary increase dtr.Accumulated += percentage; } else { double percentage = 1.0 * dtr.Accumulated; dtr.Accumulated += percentage; } } } } if (user.UserName == dtr.UserName) { if (dtr.TimeOut != null) { daysPresent++; } deduction.AllAccumulatedTimeAddition += dtr.Accumulated * basicSalaryPerMinute; deduction.LateDeduction += dtr.Late * basicSalaryPerMinute; if (user.SickLeaveCredit != 0) { deduction.AllAccumulatedTimeAddition += (540 * user.SickLeaveCredit) * basicSalaryPerMinute; deduction.Remarks += $" Added {user.SickLeave} Sick Leave/s"; user.SickLeaveCredit = 0; db.SaveChanges(); } } } deduction.TotalSalary = deduction.AllAccumulatedTimeAddition; deduction.PayrollPK = db.Payrolls.FirstOrDefault(a => a.StartPayroll == start && a.EndPayroll == end).PayrollPK; deduction.UserName = user.UserName; if (end.Value.AddDays(1).Date.Day == 26) { double monthlySalary = user.Salary * 26; deduction.SSSDeduction = monthlySalary * 0.0363; deduction.PagibigDeduction = monthlySalary * 0.0200; deduction.TinDeduction = monthlySalary * 0.01375; deduction.TotalSalary -= deduction.SSSDeduction; deduction.TotalSalary -= deduction.PagibigDeduction; deduction.TotalSalary -= deduction.TinDeduction; } deduction.BasicSalary = user.Salary; db.Deductionss.Add(deduction); db.SaveChanges(); } }catch (Exception e) { } }
public DbResult Update(Deductions entity, string flag) { return(repo.Update(entity, flag)); }