public async Task <ActionResult> DeleteConfirmed(int id) { hr_EmployeeSalary hr_EmployeeSalary = await db.hr_EmployeeSalary.FindAsync(id); db.hr_EmployeeSalary.Remove(hr_EmployeeSalary); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public ActionResult Save(hr_EmployeeSalary Item) { int status = 0; // Start Validation cheack if (ModelState.IsValid) { //################### Edit Item ###################// //Item.EmployeeJobID = .; var salary = new hr_SalaryHistory(); Item = db.hr_EmployeeSalary.Where(a => a.EmployeeID == Item.EmployeeID).FirstOrDefault(); salary.ImployeeID = Item.EmployeeID ?? 0; salary.SalaryHistoryAllownaceAmount = Item.EmployeesSalaryAllownace; salary.SalaryHistoryAmount = Item.EmployeesSalary ?? 0; salary.SalaryHistoryDeducationAmount = Item.EmployeesSalarydeducate; salary.SalaryHistoryProcduerDate = DateTime.Now; salary.SalaryHistoryDate = Item.EmployeesSalarydate; salary.ImployeeName = db.hr_Employees.Find(Item.EmployeeID).EmployeeFullName; db.hr_SalaryHistory.Add(salary); db.SaveChanges(); //////////////////// var employeeDebtRecords = db.hr_EmployeeDebtRecords.Where(h => h.DebtRecordsEmpoloyeeID == Item.EmployeeID); foreach (var item in employeeDebtRecords.Where(x => employeeDebtRecords.Any(y => y.DebtRecordsEmpoloyeeID == Item.EmployeeID)).ToList()) { db.hr_EmployeeDebtRecords.Remove(item); } db.SaveChanges(); status = 2; // 2 fro //End Save New Item return(new JsonResult { Data = new { status = status } }); } // End Validation cheack // Start Send validation error else { var errorList = ModelState.Values.SelectMany(m => m.Errors) .Select(e => e.ErrorMessage) .ToList(); return(new JsonResult { Data = new { status = errorList } }); } // End Send validation error }
public async Task <ActionResult> Edit([Bind(Include = "Id,EmployeeID,EmployeesSalary,EmployeesSalarydate")] hr_EmployeeSalary hr_EmployeeSalary) { if (ModelState.IsValid) { db.Entry(hr_EmployeeSalary).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(hr_EmployeeSalary)); }
public async Task <ActionResult> Create([Bind(Include = "Id,EmployeeID,EmployeesSalary,EmployeesSalarydate")] hr_EmployeeSalary hr_EmployeeSalary) { if (ModelState.IsValid) { db.hr_EmployeeSalary.Add(hr_EmployeeSalary); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(hr_EmployeeSalary)); }
// GET: EmployeeSalary/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } hr_EmployeeSalary hr_EmployeeSalary = await db.hr_EmployeeSalary.FindAsync(id); if (hr_EmployeeSalary == null) { return(HttpNotFound()); } return(View(hr_EmployeeSalary)); }
public ActionResult Save(hr_Employees Item, FormCollection form) { int status = 0; if (!EmployeeValidation(Item)) { NameErrow = "الرجاء إدخال إسم الموظف"; ViewBag.NameErrow = NameErrow; return(View()); } // Start Validation cheack if (ModelState.IsValid) { //################### Edit Item ###################// if (Item.EmployeeID > 0) { var v = db.hr_Employees.Where(I => I.EmployeeID == Item.EmployeeID).FirstOrDefault(); if (v != null) { v.EmployeeID = Item.EmployeeID; v.EmployeeFullName = Item.EmployeeFullName; v.EmployeeDepartmentID = Item.EmployeeDepartmentID; v.EmployeeJobID = Item.EmployeeJobID; v.EmployeePhone = Item.EmployeePhone; v.EmployeeAddress = Item.EmployeeAddress; v.PointOfsaleID = Item.PointOfsaleID; v.EmployeeStatus = Item.EmployeeStatus ?? 1; db.SaveChanges(); status = 1; // 1 for update } status = 1; // 1 for update } //################### Edit Item //################### // Start Save New Item else { //Item.EmployeeJobID = .; Item.EmployeeStatus = 1; Item.EmployeeGender = 1; db.hr_Employees.Add(Item); db.SaveChanges(); var salary = new hr_EmployeeSalary(); salary.EmployeeID = Item.EmployeeID; salary.EmployeesSalarydate = DateTime.Now; salary.EmployeesSalary = Double.Parse(db.hr_JobsName.Find(Item.EmployeeJobID).JobNameBasicSalary.ToString()); db.hr_EmployeeSalary.Add(salary); db.SaveChanges(); status = 2; // 2 fro } //End Save New Item return(new JsonResult { Data = new { status = status } }); } // End Validation cheack // Start Send validation error else { var errorList = ModelState.Values.SelectMany(m => m.Errors) .Select(e => e.ErrorMessage) .ToList(); return(new JsonResult { Data = new { status = errorList } }); } // End Send validation error }
public ActionResult Save(hr_EmpDedicationAllowance Item) { int status = 0; // Start Validation cheack if (ModelState.IsValid) { var type = db.hr_DedicationAllowanceList.Find(Item.DedicationAllowanceListID).DeductionAllowanceID; //################### Edit Item ###################// if (Item.EmpDedicationAllowanceID > 0) { var v = db.hr_EmpDedicationAllowance.Where(I => I.EmpDedicationAllowanceID == Item.EmpDedicationAllowanceID).FirstOrDefault(); if (v != null) { updateSalary(Item.DedicationAllowanceListID, (int)v.EmpBatchValue, (int)Item.EmpBatchValue, Item.EmployeeID, type); v.EmpBatchValue = Item.EmpBatchValue; db.SaveChanges(); status = 1; // 1 for update /////////////////////////////// } status = 1; // 1 for update } //################### Edit Item //################### // Start Save New Item else { Item.EmpBatchDate = DateTime.Now; db.hr_EmpDedicationAllowance.Add(Item); db.SaveChanges(); ///////////////////////////////////////////// var salary = new hr_EmployeeSalary(); salary = db.hr_EmployeeSalary.Where(I => I.EmployeeID == Item.EmployeeID).FirstOrDefault(); if (type == 1) { salary.EmployeesSalaryAllownace = salary.EmployeesSalaryAllownace + (Double)Item.EmpBatchValue; } else { salary.EmployeesSalarydeducate = salary.EmployeesSalarydeducate + (Double)Item.EmpBatchValue; } db.SaveChanges(); status = 2; } //End Save New Item return(new JsonResult { Data = new { status = status } }); } // End Validation cheack // Start Send validation error else { var errorList = ModelState.Values.SelectMany(m => m.Errors) .Select(e => e.ErrorMessage) .ToList(); return(new JsonResult { Data = new { status = errorList } }); } // End Send validation error }