public async Task <ActionResult> AddPrevWorkExpDetails(string schoolId, string Staff_Id, string Name, string Address, string Designation, string FrmYear, string ToYear, string Subjects_Handled, string Designation_Id) { var userId = LoggedInUser.Id; JsonResult result = new JsonResult(); try { var schoolid = Convert.ToInt32(schoolId); var staffId = Convert.ToInt32(Staff_Id); var designation = Convert.ToInt32(Designation_Id); var frmYear = Convert.ToInt32(FrmYear); var toYear = Convert.ToInt32(ToYear); // , string FrmYear, string ToYear, string Leaving, string Comments var CheckStudent = db.Staff_Exp_Details.Where(a => a.Staff_Id == staffId && a.School_Id == schoolid).Count(); if (CheckStudent == 0) { Staff_Exp_Details addStaffWorkExpDetails = new Staff_Exp_Details(); addStaffWorkExpDetails.Staff_Id = staffId; addStaffWorkExpDetails.School_Id = schoolid; addStaffWorkExpDetails.Designation_Id = Convert.ToInt32(Designation_Id); addStaffWorkExpDetails.From_Year = frmYear; addStaffWorkExpDetails.Is_Deleted = false; addStaffWorkExpDetails.To_Year = toYear; addStaffWorkExpDetails.Subject_Id = Subjects_Handled; addStaffWorkExpDetails.Academic_Year = (DateTime.Now.Month < 3) ? DateTime.Now.Year - 1 : DateTime.Now.Year; //addStaffWorkExpDetails.Comments = Comments; addStaffWorkExpDetails.Created_On = DateTime.Now; addStaffWorkExpDetails.Created_By = userId; addStaffWorkExpDetails.Is_Active = true; db.Staff_Exp_Details.Add(addStaffWorkExpDetails); await db.SaveChangesAsync(); } else { } } catch (Exception ex) { result.Data = new { Result = "ERROR", Message = " This property already available in this block " }; } return(RedirectToAction("CreateStaffOtherDetails")); }
public async Task <ActionResult> DeleteWorkExpDetails(string schoolId, string StaffId) { var userId = LoggedInUser.Id; JsonResult result = new JsonResult(); try { var school_Id = Convert.ToInt32(schoolId); var staff_Id = Convert.ToInt32(StaffId); Staff_Exp_Details deleteWorkExpDetails = db.Staff_Exp_Details.Where(a => a.School_Id == school_Id && a.Staff_Id == staff_Id).FirstOrDefault(); db.Entry(deleteWorkExpDetails).CurrentValues.SetValues(deleteWorkExpDetails); deleteWorkExpDetails.Is_Deleted = true; db.Entry(deleteWorkExpDetails).State = EntityState.Modified; await db.SaveChangesAsync(); } catch (Exception ex) { result.Data = new { Result = "ERROR", Message = " This property already available in this block " }; } return(RedirectToAction("CreateStaffOtherDetails")); }
// GET: Core/Staffs/Delete/5 public async Task <ActionResult> Delete(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } //if (staff == null) //{ // return HttpNotFound(); //} using (StudentDbContext db = new StudentDbContext()) { Staff staff = await db.Staffs.FindAsync(id); if (staff != null) { staff.Is_Deleted = true; db.Entry(staff).CurrentValues.SetValues(staff); db.Entry(staff).State = EntityState.Modified; await db.SaveChangesAsync(); } } using (StudentDbContext db = new StudentDbContext()) { Staff_Educational_Details staffEducationalDetails = await db.Staff_Educational_Details.FindAsync(id); if (staffEducationalDetails != null) { staffEducationalDetails.Is_Deleted = true; db.Entry(staffEducationalDetails).CurrentValues.SetValues(staffEducationalDetails); db.Entry(staffEducationalDetails).State = EntityState.Modified; await db.SaveChangesAsync(); } } using (StudentDbContext db = new StudentDbContext()) { Staff_Salary_Detail staffSalaryDetail = await db.Staff_Salary_Details.FindAsync(id); if (staffSalaryDetail != null) { staffSalaryDetail.Is_Deleted = true; db.Entry(staffSalaryDetail).CurrentValues.SetValues(staffSalaryDetail); db.Entry(staffSalaryDetail).State = EntityState.Modified; await db.SaveChangesAsync(); } } using (StudentDbContext db = new StudentDbContext()) { Staff_Exp_Details stafExpDetails = await db.Staff_Exp_Details.FindAsync(id); if (stafExpDetails != null) { stafExpDetails.Is_Deleted = true; db.Entry(stafExpDetails).CurrentValues.SetValues(stafExpDetails); db.Entry(stafExpDetails).State = EntityState.Modified; await db.SaveChangesAsync(); } } return(RedirectToAction("Index")); }