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