public ActionResult AddStudentSiblingDetails(Student_Sibling_Detail stuSiblingDetail)
{
stuSiblingDetail.Created_On = DateTime.Now;
stuSiblingDetail.Academic_Year = GetAcademicYear();
stuSiblingDetail.Is_Active = true;
List <Student_SiblingList_ViewModel> addedStudentSiblingDetails = new List <Student_SiblingList_ViewModel>();
addedStudentSiblingDetails = GetStudentSiblingDetails(stuSiblingDetail);
return(Json(new { items = addedStudentSiblingDetails }, JsonRequestBehavior.AllowGet));
}
public List <Student_SiblingList_ViewModel> GetStudentSiblingDetails(Student_Sibling_Detail stuSiblingDetail)
{
long nYear = GetAcademicYear();
long nStudent_Id = Convert.ToInt64(TempData.Peek("Student_Id"));
stuSiblingDetail.Student_Id = nStudent_Id;
List <Student_SiblingList_ViewModel> addedStudentSiblingDetails = new List <Student_SiblingList_ViewModel>();
try
{
using (var dbcontext = new SchoolERPDBContext())
{
if (stuSiblingDetail != null)
{
dbcontext.Student_Sibling_Detail.Add(stuSiblingDetail);
dbcontext.SaveChanges();
}
}
using (var dbcontext = new SchoolERPDBContext())
{
addedStudentSiblingDetails = (from stu in dbcontext.Student
join studentSiblingDetail in dbcontext.Student_Sibling_Detail on stu.Student_Id equals studentSiblingDetail.Sibling_Student_Id
join cls in dbcontext.Class on stu.Class_Id equals cls.Id
join sec in dbcontext.Section on stu.Section_Id equals sec.Id
where studentSiblingDetail.Student_Id == nStudent_Id && studentSiblingDetail.Academic_Year == nYear && studentSiblingDetail.Is_Deleted == null || studentSiblingDetail.Is_Deleted == false
select new Student_SiblingList_ViewModel
{
Sibling_Detail_Id = studentSiblingDetail.Sibling_Detail_Id,
Class = cls.Name,
Section = sec.Name,
Student_Name = stu.First_Name + " " + stu.Last_Name,
Roll_No = stu.Roll_No,
Updated_On = studentSiblingDetail.Updated_On,
Student_Id = studentSiblingDetail.Student_Id,
Sibling_Relation = studentSiblingDetail.Sibling_Relation
}).ToList();
}
}
catch (Exception ex)
{
}
return(addedStudentSiblingDetails);
}