public async Task <ActionResult> AddSiblingDetails(string studentId, string RefSibling_Id) { var userId = LoggedInUser.Id; JsonResult result = new JsonResult(); try { var stduId = Convert.ToInt32(studentId); var SiblingstduId = Convert.ToInt32(RefSibling_Id); var student = db.Students.Where(a => a.Student_Id == stduId).FirstOrDefault(); var CheckSibling = db.Student_Sibling_Details.Where(a => a.Sibling_Id == stduId && a.Student_Id == SiblingstduId).Count(); if (CheckSibling == 0) { Student_Sibling_Details addSibling = new Student_Sibling_Details(); addSibling.Student_Id = SiblingstduId; addSibling.Sibling_Id = student.Student_Id; addSibling.Sibling_Name = student.First_Name + ' ' + student.Middle_Name + ' ' + student.Last_Name; addSibling.Class_Id = student.Class_Id; addSibling.Section_Id = student.Section_Id; addSibling.Is_Active = student.Is_Active; addSibling.Is_Deleted = student.Is_Deleted; addSibling.Academic_Year = student.Academic_Year; addSibling.Created_On = DateTime.Now; addSibling.Created_By = userId; db.Student_Sibling_Details.Add(addSibling); await db.SaveChangesAsync(); } else { } } catch (Exception ex) { result.Data = new { Result = "ERROR", Message = " This property already available in this block " }; } return(RedirectToAction("SaveAndContiune")); }
public async Task <ActionResult> DeleteSiblingDetails(string studentId, string RefSibling_Id) { var userId = LoggedInUser.Id; JsonResult result = new JsonResult(); try { var stduId = Convert.ToInt32(studentId); var SiblingstduId = Convert.ToInt32(RefSibling_Id); Student_Sibling_Details deleteSibling = db.Student_Sibling_Details.Where(a => a.Student_Id == SiblingstduId && a.Sibling_Id == stduId).FirstOrDefault(); db.Entry(deleteSibling).CurrentValues.SetValues(deleteSibling); deleteSibling.Is_Deleted = true; db.Entry(deleteSibling).State = EntityState.Modified; await db.SaveChangesAsync(); } catch (Exception ex) { result.Data = new { Result = "ERROR", Message = " This property already available in this block " }; } return(RedirectToAction("SaveAndContiune")); }