public JsonResult Upload(HttpPostedFileBase file, long?student_Id) { //long nStudent_Id = Convert.ToInt64(TempData.Peek("Student_Id")); long nStudent_Id = Convert.ToInt64(student_Id); Student studentToBeModified = new Student(); byte[] bytes; try { if (file != null) { using (BinaryReader br = new BinaryReader(file.InputStream)) { bytes = br.ReadBytes(file.ContentLength); } using (var dbcontext = new SchoolERPDBContext()) { studentToBeModified = dbcontext.Student.Find(nStudent_Id); studentToBeModified.Photo = bytes; dbcontext.Entry(studentToBeModified).CurrentValues.SetValues(studentToBeModified); dbcontext.SaveChanges(); } } return(Json("OK", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex.Message.ToString(), JsonRequestBehavior.AllowGet)); } //return null; }
public JsonResult Upload(HttpPostedFileBase file) { long nAssignment_Id = Convert.ToInt32(TempData.Peek("Assignment_Id")); Assignment assignmentToBeModified = new Assignment(); byte[] bytes; try { if (file != null) { using (BinaryReader br = new BinaryReader(file.InputStream)) { bytes = br.ReadBytes(file.ContentLength); } using (var dbcontext = new SchoolERPDBContext()) { assignmentToBeModified = dbcontext.Assignment.Find(nAssignment_Id); assignmentToBeModified.Photo = bytes; dbcontext.Entry(assignmentToBeModified).CurrentValues.SetValues(assignmentToBeModified); dbcontext.SaveChanges(); } } return(Json("Assignment Successfully Added", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex.Message.ToString(), JsonRequestBehavior.AllowGet)); } return(null); }
public async Task <ActionResult> Delete(int id) { using (var dbcontext = new SchoolERPDBContext()) { Class cls = await dbcontext.Class.FindAsync(id); if (cls != null) { cls.Is_Deleted = true; dbcontext.Entry(cls).CurrentValues.SetValues(cls); dbcontext.Entry(cls).State = EntityState.Modified; await dbcontext.SaveChangesAsync(); } } return(RedirectToAction("ClassList")); }
public async Task <ActionResult> Delete(int id) { using (var dbcontext = new SchoolERPDBContext()) { User_Role userRole = await dbcontext.User_Roles.FindAsync(id); if (userRole != null) { userRole.Is_Deleted = true; dbcontext.Entry(userRole).CurrentValues.SetValues(userRole); dbcontext.Entry(userRole).State = EntityState.Modified; await dbcontext.SaveChangesAsync(); } } return(RedirectToAction("RoleList")); }
public async Task <ActionResult> Delete(int id) { using (var dbcontext = new SchoolERPDBContext()) { Exam exam = await dbcontext.Exam.FindAsync(id); if (exam != null) { exam.Is_Deleted = true; dbcontext.Entry(exam).CurrentValues.SetValues(exam); dbcontext.Entry(exam).State = EntityState.Modified; await dbcontext.SaveChangesAsync(); } } return(RedirectToAction("ExamList")); }
public ActionResult EditAndSaveStudentOtherDetails(Student_Other_Details Student_Other_Detail) { long nStudent_Id = Convert.ToInt64(Student_Other_Detail.Student_Id); Student_Other_Details student_OtherDetails_ToBeEdited = new Student_Other_Details(); string sReturn_Text = string.Empty; try { using (var dbcontext = new SchoolERPDBContext()) { //var id = dbcontext.Student_Other_Details.Where(x => x.Student_Id == nStudent_Id).FirstOrDefault().StudentDetail_Id; if (dbcontext.Student_Other_Details.Where(x => x.Student_Id == nStudent_Id).Count() == 1) { var studen_OtherDetailsTotEdit = dbcontext.Student_Other_Details.Find(Student_Other_Detail.StudentDetail_Id); studen_OtherDetailsTotEdit.Identification_Mark1 = Student_Other_Detail.Identification_Mark1; studen_OtherDetailsTotEdit.Identification_Mark2 = Student_Other_Detail.Identification_Mark2; studen_OtherDetailsTotEdit.Is_Allergic = Student_Other_Detail.Is_Allergic; studen_OtherDetailsTotEdit.Allergy_Details = Student_Other_Detail.Allergy_Details; studen_OtherDetailsTotEdit.Father_Occupation_Id = Student_Other_Detail.Father_Occupation_Id; studen_OtherDetailsTotEdit.Father_Designation = Student_Other_Detail.Father_Designation; studen_OtherDetailsTotEdit.Father_Company_Name = Student_Other_Detail.Father_Company_Name; studen_OtherDetailsTotEdit.Father_Office_Address = Student_Other_Detail.Father_Office_Address; studen_OtherDetailsTotEdit.Father_Annual_Income = Student_Other_Detail.Father_Annual_Income; studen_OtherDetailsTotEdit.Mother_Occupation_Id = Student_Other_Detail.Mother_Occupation_Id; studen_OtherDetailsTotEdit.Mother_Designation = Student_Other_Detail.Mother_Designation; studen_OtherDetailsTotEdit.Mother_Company_Name = Student_Other_Detail.Mother_Company_Name; studen_OtherDetailsTotEdit.Mother_Office_Address = Student_Other_Detail.Mother_Office_Address; studen_OtherDetailsTotEdit.Mother_Annual_Income = Student_Other_Detail.Mother_Annual_Income; studen_OtherDetailsTotEdit.Medical_History_Details = Student_Other_Detail.Medical_History_Details; studen_OtherDetailsTotEdit.Second_Language_Opted_Id = Student_Other_Detail.Second_Language_Opted_Id; studen_OtherDetailsTotEdit.Updated_On = DateTime.Now; dbcontext.Entry(studen_OtherDetailsTotEdit).State = EntityState.Modified; dbcontext.SaveChanges(); } else { Student_Other_Detail.Created_On = DateTime.Now; Student_Other_Detail.Created_By = 5; dbcontext.Student_Other_Details.Add(Student_Other_Detail); dbcontext.SaveChanges(); } TempData["Student_Id"] = nStudent_Id; TempData.Keep("Student_Id"); sReturn_Text = "OK"; } } catch (Exception ex) { sReturn_Text = ex.InnerException.Message.ToString(); } return(Json(sReturn_Text, JsonRequestBehavior.AllowGet)); // return View(); }
public ActionResult Delete(long id) { using (var dbcontext = new SchoolERPDBContext()) { var studenToBeDeleted = dbcontext.Student.Find(id); studenToBeDeleted.Is_Deleted = true; studenToBeDeleted.Is_Active = true; studenToBeDeleted.Updated_By = 5; studenToBeDeleted.Updated_On = DateTime.Now; dbcontext.Entry(studenToBeDeleted).State = EntityState.Modified; dbcontext.SaveChanges(); } return(RedirectToAction("StudentList")); }
public ActionResult Delete(long Id) { using (var dbcontext = new SchoolERPDBContext()) { var hostelRoomToBeDeleted = dbcontext.Hostel_Room.Find(Id); hostelRoomToBeDeleted.Is_Deleted = true; hostelRoomToBeDeleted.Is_Active = false; hostelRoomToBeDeleted.Updated_By = 5; hostelRoomToBeDeleted.Updated_On = DateTime.Now; dbcontext.Entry(hostelRoomToBeDeleted).State = EntityState.Modified; dbcontext.SaveChanges(); } return(RedirectToAction("HostelRoomList")); //return View(); }
public JsonResult DeleteStudentSiblingDetail(string id) { int idTobemodified = Convert.ToInt16(id); List <Student_SiblingList_ViewModel> modifiedStudentSiblingDetails = new List <Student_SiblingList_ViewModel>(); using (var dbcontext = new SchoolERPDBContext()) { var studentSiblingDetailTobedeleted = dbcontext.Student_Sibling_Detail.Find(idTobemodified); studentSiblingDetailTobedeleted.Is_Deleted = true; studentSiblingDetailTobedeleted.Updated_On = DateTime.Now; studentSiblingDetailTobedeleted.Updated_By = 5; dbcontext.Entry(studentSiblingDetailTobedeleted).CurrentValues.SetValues(studentSiblingDetailTobedeleted); dbcontext.SaveChanges(); } modifiedStudentSiblingDetails = getStudenSiblingDetail(); return(Json(new { items = modifiedStudentSiblingDetails }, JsonRequestBehavior.AllowGet)); }
public JsonResult UploadStudentDocuments(HttpPostedFileBase file1, HttpPostedFileBase file2, HttpPostedFileBase file3, HttpPostedFileBase file4, HttpPostedFileBase file5, HttpPostedFileBase file6) { //long nStudent_Id = // long nStudent_Id = Convert.ToInt64(TempData.Peek("Student_Id")); long nStudent_Id = Convert.ToInt64(TempData.Peek("Student_Id"));; Student_Document StudentDocumentToBeAddededOrUpdated = new Student_Document(); HttpPostedFileBase[] fileBaseArr = new HttpPostedFileBase[6]; //byte[] bytes1, bytes2 , bytes3, bytes4, bytes5, bytes6; try { using (var dbcontext = new SchoolERPDBContext()) { if (file1 != null) { StudentDocumentToBeAddededOrUpdated.document1 = ConvertFiletoBYteStream(file1); } else { } if (file2 != null) { StudentDocumentToBeAddededOrUpdated.document2 = ConvertFiletoBYteStream(file2); } if (file3 != null) { StudentDocumentToBeAddededOrUpdated.document3 = ConvertFiletoBYteStream(file3); } if (file4 != null) { StudentDocumentToBeAddededOrUpdated.document4 = ConvertFiletoBYteStream(file4); } if (file5 != null) { StudentDocumentToBeAddededOrUpdated.document5 = ConvertFiletoBYteStream(file5); } if (file6 != null) { StudentDocumentToBeAddededOrUpdated.document6 = ConvertFiletoBYteStream(file6); } if (dbcontext.Student_Document.Where(x => x.Student_Id == nStudent_Id).ToList().Count() > 0) { var studentDocumentId = dbcontext.Student_Document.Where(x => x.Student_Id == nStudent_Id).FirstOrDefault().Id; var studentDocToBeModified = dbcontext.Student_Document.Find(studentDocumentId); studentDocToBeModified.document1 = StudentDocumentToBeAddededOrUpdated.document1 == null ? studentDocToBeModified.document1 : StudentDocumentToBeAddededOrUpdated.document1; studentDocToBeModified.document2 = StudentDocumentToBeAddededOrUpdated.document2 == null ? studentDocToBeModified.document2 : StudentDocumentToBeAddededOrUpdated.document2; studentDocToBeModified.document3 = StudentDocumentToBeAddededOrUpdated.document3 == null ? studentDocToBeModified.document3 : StudentDocumentToBeAddededOrUpdated.document3; studentDocToBeModified.document4 = StudentDocumentToBeAddededOrUpdated.document4 == null ? studentDocToBeModified.document4 : StudentDocumentToBeAddededOrUpdated.document4; studentDocToBeModified.document5 = StudentDocumentToBeAddededOrUpdated.document5 == null ? studentDocToBeModified.document5 : StudentDocumentToBeAddededOrUpdated.document5; studentDocToBeModified.document6 = StudentDocumentToBeAddededOrUpdated.document6 == null ? studentDocToBeModified.document6 : StudentDocumentToBeAddededOrUpdated.document6; dbcontext.Entry(studentDocToBeModified).CurrentValues.SetValues(studentDocToBeModified); dbcontext.SaveChanges(); } else { StudentDocumentToBeAddededOrUpdated.Student_Id = nStudent_Id; dbcontext.Student_Document.Add(StudentDocumentToBeAddededOrUpdated); dbcontext.SaveChanges(); } // } return(Json("Student Documents Successfully Uploaded", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex.Message.ToString(), JsonRequestBehavior.AllowGet)); } }
public ActionResult EditStudent(Student student) { string sReturnText = string.Empty; try { if (ModelState.IsValid) { using (var dbcontext = new SchoolERPDBContext()) { Student studentToBeUpdated = dbcontext.Student.Find(student.Student_Id); studentToBeUpdated.First_Name = student.First_Name; studentToBeUpdated.Last_Name = student.Last_Name; studentToBeUpdated.Middle_Name = student.Middle_Name; studentToBeUpdated.Father_Name = student.Father_Name; studentToBeUpdated.Mother_Name = student.Mother_Name; studentToBeUpdated.Aadhar_No = student.Aadhar_No; studentToBeUpdated.Address_Line1 = student.Address_Line1; studentToBeUpdated.Address_Line2 = student.Address_Line2; studentToBeUpdated.Blood_Group_Id = student.Blood_Group_Id; studentToBeUpdated.Email_Id = student.Email_Id; studentToBeUpdated.DOB = student.DOB; studentToBeUpdated.Enrollment_Date = student.Enrollment_Date; studentToBeUpdated.City_Id = student.City_Id; studentToBeUpdated.State_Id = student.State_Id; studentToBeUpdated.Country_Id = student.Country_Id; studentToBeUpdated.Blood_Group_Id = student.Blood_Group_Id; studentToBeUpdated.Is_HostelStudent = student.Is_HostelStudent; studentToBeUpdated.Phone_No1 = student.Phone_No1; studentToBeUpdated.Phone_No2 = student.Phone_No2; studentToBeUpdated.Section_Id = student.Section_Id; studentToBeUpdated.Class_Id = student.Class_Id; studentToBeUpdated.Gender_Id = student.Gender_Id; studentToBeUpdated.Pincode = student.Pincode; studentToBeUpdated.Updated_On = DateTime.Now; studentToBeUpdated.Updated_By = 5; if (student.Email_Id.Trim() != studentToBeUpdated.Email_Id.Trim()) { if (!CheckIfEmailAlreadyExists(student.Email_Id, true, false)) { dbcontext.Entry(studentToBeUpdated).State = EntityState.Modified; dbcontext.SaveChanges(); sReturnText = "OK"; } else { sReturnText = "Email Already Exists"; } } else { dbcontext.Entry(studentToBeUpdated).State = EntityState.Modified; dbcontext.SaveChanges(); sReturnText = "OK"; } } } } catch (Exception ex) { sReturnText = ex.InnerException.Message.ToString(); } return(Json(sReturnText, JsonRequestBehavior.AllowGet)); }
public JsonResult SaveMarksForClass(List <string[]> myData) { Mark newmarkToBeAdded = new Mark(); string sReturnText = string.Empty; int nUser_Id; int[] nSubjectIdArr = (int[])TempData.Peek("SubjectId_For_Marks"); nStudentIdArr = (long[])TempData.Peek("StudentIdArr_For_Marks"); using (var dbcontext = new SchoolERPDBContext()) { //nUser_Id = dbcontext.Users.Where(x => x.User_Id == User.Identity.Name).ToList()[0].Id; ; nUser_Id = 4; } int nCount = myData.ToList().Count; int nLoopCount = 0; using (var dbcontext = new SchoolERPDBContext()) { using (var transaction = dbcontext.Database.BeginTransaction()) { try { for (int iMarkDetailLoopCount = 1; iMarkDetailLoopCount < myData.ToList().Count(); iMarkDetailLoopCount++) { Mark newMarkDetail = new Mark(); newMarkDetail.Class_Id = Convert.ToInt16(TempData.Peek("Class_Id_For_Marks")); newMarkDetail.Section_Id = Convert.ToInt16(TempData.Peek("Section_Id_For_Marks")); newMarkDetail.Student_Id = nStudentIdArr[iMarkDetailLoopCount - 1]; newMarkDetail.Is_Active = true; newMarkDetail.Is_Deleted = false; newMarkDetail.Exam_Id = Convert.ToInt16(TempData.Peek("Exam_Id_For_Marks")); newMarkDetail.Created_By = 4; newMarkDetail.Created_On = DateTime.Now; newMarkDetail.Academic_Year = Convert.ToInt16(TempData.Peek("Year_For_Marks")); for (int nSubjectCount = 0; nSubjectCount < nSubjectIdArr.Count(); nSubjectCount++) { newMarkDetail.GetType().GetProperty("Subject_Id" + (nSubjectCount + 1)).SetValue(newMarkDetail, nSubjectIdArr[nSubjectCount], null); newMarkDetail.GetType().GetProperty("Mark" + (nSubjectCount + 1)).SetValue(newMarkDetail, myData[iMarkDetailLoopCount][nSubjectCount + 2] == "" ? 0 : Convert.ToInt16(myData[iMarkDetailLoopCount][nSubjectCount + 2]), null); //newMarkDetail.GetType().GetProperty("Total").SetValue(newMarkDetail, myData[iMarkDetailLoopCount][12] == "" ? 0 : Convert.ToInt32(myData[iMarkDetailLoopCount][12]), null); //newMarkDetail.GetType().GetProperty("Average").SetValue(newMarkDetail, myData[iMarkDetailLoopCount][12] == "" ? 0 : Convert.ToDecimal(myData[iMarkDetailLoopCount][13]), null); } newMarkDetail.GetType().GetProperty("Total").SetValue(newMarkDetail, myData[iMarkDetailLoopCount][12] == "" ? 0 : Convert.ToInt32(myData[iMarkDetailLoopCount][12]), null); newMarkDetail.GetType().GetProperty("Average").SetValue(newMarkDetail, myData[iMarkDetailLoopCount][13] == "" ? 0 : Convert.ToDecimal(myData[iMarkDetailLoopCount][13]), null); if (dbcontext.Mark.Where(a => a.Student_Id == newMarkDetail.Student_Id && a.Academic_Year == newMarkDetail.Academic_Year && a.Exam_Id == newMarkDetail.Exam_Id && (a.Is_Deleted == false || a.Is_Deleted == null)).Count() == 0) { dbcontext.Mark.Add(newMarkDetail); dbcontext.SaveChanges(); } else { var markId = dbcontext.Mark.Where(a => a.Student_Id == newMarkDetail.Student_Id && a.Academic_Year == newMarkDetail.Academic_Year && a.Exam_Id == newMarkDetail.Exam_Id && (a.Is_Deleted == false || a.Is_Deleted == null)).ToList()[0].Id; Mark markToBeUpdated = dbcontext.Mark.Find(markId); markToBeUpdated.Is_Active = true; markToBeUpdated.Mark1 = newMarkDetail.Mark1; markToBeUpdated.Mark2 = newMarkDetail.Mark2; markToBeUpdated.Mark3 = newMarkDetail.Mark3; markToBeUpdated.Mark4 = newMarkDetail.Mark4; markToBeUpdated.Mark5 = newMarkDetail.Mark5; markToBeUpdated.Mark6 = newMarkDetail.Mark6; markToBeUpdated.Mark7 = newMarkDetail.Mark7; markToBeUpdated.Mark8 = newMarkDetail.Mark8; markToBeUpdated.Mark9 = newMarkDetail.Mark9; markToBeUpdated.Mark10 = newMarkDetail.Mark10; markToBeUpdated.Total = newMarkDetail.Total; markToBeUpdated.Average = newMarkDetail.Average; dbcontext.Entry(markToBeUpdated).State = EntityState.Modified; dbcontext.SaveChanges(); } if (iMarkDetailLoopCount == (myData.ToList().Count() - 1)) { transaction.Commit(); sReturnText = "OK"; } } } catch (Exception ex) { transaction.Rollback(); } } return(Json(sReturnText, JsonRequestBehavior.AllowGet)); } }
public ActionResult SaveExamTimeTable_ForClass(string[][] exam_timetable) { string sReturnText = string.Empty; using (var dbcontext = new SchoolERPDBContext()) { using (var transaction = dbcontext.Database.BeginTransaction()) { try { if (exam_timetable.Length > 0) { for (int nRowCount = 0; nRowCount < exam_timetable.Length; nRowCount++) { Exam_TimeTable newexam_TimeTable = new Exam_TimeTable(); int nSection_Id = Convert.ToInt32(exam_timetable[nRowCount][2]); long nAcademic_Year = Convert.ToInt64(exam_timetable[nRowCount][5]); int nClass_Id = Convert.ToInt32(exam_timetable[nRowCount][3]); int nExam_Id = Convert.ToInt32(exam_timetable[nRowCount][4]); int nSubject_Id = Convert.ToInt32(exam_timetable[nRowCount][1]); DateTime dtExamDate = Convert.ToDateTime(exam_timetable[nRowCount][0]); int nExam_Session = Convert.ToInt16(exam_timetable[nRowCount][6]); if (dbcontext.Exam_TimeTable.Where(x => x.Section_Id == nSection_Id && x.Academic_Year == nAcademic_Year && x.Exam_Id == nExam_Id && x.Subject_Id == nSubject_Id && (x.Is_Deleted == null || x.Is_Deleted == false)).Count() == 0) { newexam_TimeTable.Academic_Year = nAcademic_Year; newexam_TimeTable.Section_Id = nSection_Id; newexam_TimeTable.Class_Id = dbcontext.Section.Where(x => x.Id == nSection_Id).FirstOrDefault().Class_Id; newexam_TimeTable.Section_Id = nSection_Id; newexam_TimeTable.Exam_Id = nExam_Id; newexam_TimeTable.Exam_Date = dtExamDate; newexam_TimeTable.Subject_Id = nSubject_Id; newexam_TimeTable.Created_By = 5; newexam_TimeTable.Created_On = DateTime.Now; newexam_TimeTable.Is_Active = true; newexam_TimeTable.Exam_Session = nExam_Session; dbcontext.Exam_TimeTable.Add(newexam_TimeTable); dbcontext.SaveChanges(); } else { var exam_TimeTable_Id_ToBeModified = dbcontext.Exam_TimeTable.Where(x => x.Section_Id == nSection_Id && x.Academic_Year == nAcademic_Year && x.Exam_Id == nExam_Id && x.Subject_Id == nSubject_Id && (x.Is_Deleted == null || x.Is_Deleted == false)).FirstOrDefault().Id; var exam_TimeTable_ToBeModified = dbcontext.Exam_TimeTable.Find(exam_TimeTable_Id_ToBeModified); exam_TimeTable_ToBeModified.Exam_Date = dtExamDate; exam_TimeTable_ToBeModified.Updated_By = 5; exam_TimeTable_ToBeModified.Updated_On = DateTime.Now; exam_TimeTable_ToBeModified.Exam_Session = nExam_Session; dbcontext.Entry(exam_TimeTable_ToBeModified).State = EntityState.Modified; dbcontext.SaveChanges(); } if (nRowCount == (exam_timetable.Length - 1)) { transaction.Commit(); sReturnText = "OK"; } } } } catch (Exception ex) { transaction.Rollback(); sReturnText = ex.InnerException.Message.ToString(); } } } return(Json(sReturnText, JsonRequestBehavior.AllowGet)); }
public ActionResult SaveTimeTable_For_Staff(string[][] data) { string sReturnText = string.Empty; using (var dbcontext = new SchoolERPDBContext()) { using (var transaction = dbcontext.Database.BeginTransaction()) { try { if (data.Length > 0) { int nStaff_Id = Convert.ToInt32(data[0][8]); long nAcademic_Year = Convert.ToInt64(data[0][9]); for (int nRowCount = 0; nRowCount < data.Length; nRowCount++) { Staff_TimeTable staff_TimeTable = new Staff_TimeTable(); if (dbcontext.Staff_TimeTable.Where(x => x.Staff_Id == nStaff_Id && x.Academic_Year == nAcademic_Year && (x.Is_Deleted == null || x.Is_Deleted == false) && x.Week == (nRowCount + 1)).Count() == 0) { staff_TimeTable.Academic_Year = nAcademic_Year; staff_TimeTable.Staff_Id = nStaff_Id; //staff_TimeTable.Class_Id = dbcontext.Section.Where(x => x.Id == nSection_Id).FirstOrDefault().Class_Id; staff_TimeTable.Section_Id_Period1 = Convert.ToInt16(data[nRowCount][0]); staff_TimeTable.Section_Id_Period2 = Convert.ToInt16(data[nRowCount][1]); staff_TimeTable.Section_Id_Period3 = Convert.ToInt16(data[nRowCount][2]); staff_TimeTable.Section_Id_Period4 = Convert.ToInt16(data[nRowCount][3]); staff_TimeTable.Section_Id_Period5 = Convert.ToInt16(data[nRowCount][4]); staff_TimeTable.Section_Id_Period6 = Convert.ToInt16(data[nRowCount][5]); staff_TimeTable.Section_Id_Period7 = Convert.ToInt16(data[nRowCount][6]); staff_TimeTable.Section_Id_Period8 = Convert.ToInt16(data[nRowCount][7]); staff_TimeTable.Week = nRowCount + 1; staff_TimeTable.Created_By = 5; staff_TimeTable.Created_On = DateTime.Now; staff_TimeTable.Is_Active = true; dbcontext.Staff_TimeTable.Add(staff_TimeTable); dbcontext.SaveChanges(); } else { var staff_TimeTable_Id_ToBeModified = dbcontext.Staff_TimeTable.Where(x => x.Staff_Id == nStaff_Id && x.Academic_Year == nAcademic_Year && (x.Is_Deleted == null || x.Is_Deleted == false) && x.Week == (nRowCount + 1)).FirstOrDefault().Id; var Staff_TimeTable_ToBeModified = dbcontext.Staff_TimeTable.Find(staff_TimeTable_Id_ToBeModified); Staff_TimeTable_ToBeModified.Section_Id_Period1 = Convert.ToInt16(data[nRowCount][0]); Staff_TimeTable_ToBeModified.Section_Id_Period2 = Convert.ToInt16(data[nRowCount][1]); Staff_TimeTable_ToBeModified.Section_Id_Period3 = Convert.ToInt16(data[nRowCount][2]); Staff_TimeTable_ToBeModified.Section_Id_Period4 = Convert.ToInt16(data[nRowCount][3]); Staff_TimeTable_ToBeModified.Section_Id_Period5 = Convert.ToInt16(data[nRowCount][4]); Staff_TimeTable_ToBeModified.Section_Id_Period6 = Convert.ToInt16(data[nRowCount][5]); Staff_TimeTable_ToBeModified.Section_Id_Period7 = Convert.ToInt16(data[nRowCount][6]); Staff_TimeTable_ToBeModified.Section_Id_Period8 = Convert.ToInt16(data[nRowCount][7]); Staff_TimeTable_ToBeModified.Updated_By = 5; Staff_TimeTable_ToBeModified.Updated_On = DateTime.Now; dbcontext.Entry(Staff_TimeTable_ToBeModified).State = EntityState.Modified; dbcontext.SaveChanges(); } if (nRowCount == (data.Length - 1)) { transaction.Commit(); sReturnText = "OK"; } } } } catch (Exception ex) { transaction.Rollback(); sReturnText = ex.InnerException.Message.ToString(); } } } return(Json(sReturnText, JsonRequestBehavior.AllowGet)); }
public JsonResult SaveAttendanceForClass(List <string[]> myData) { int nUser_Id; nStudentIdArr = (long[])TempData.Peek("StudentIdArr"); string sReturnText = string.Empty; DateTime termEndDate; DateTime termStartDate; using (var dbcontext = new SchoolERPDBContext()) { //nUser_Id = dbcontext.Users.Where(x => x.User_Id == User.Identity.Name).ToList()[0].Id; ; nUser_Id = 4; } int nCount = myData.ToList().Count; int nTerm_Id = Convert.ToInt16(TempData.Peek("Term_Id_For_Attendance")); int nLoopCount = 0; using (var dbcontext = new SchoolERPDBContext()) { termEndDate = dbcontext.Term.Where(x => x.Id == nTerm_Id).ToList()[0].To_Date; termStartDate = dbcontext.Term.Where(x => x.Id == nTerm_Id).ToList()[0].From_Date; } TimeSpan difference = termEndDate - termStartDate; int nDays = Convert.ToInt16(difference.TotalDays); nDays = nDays + 1; using (var dbcontext = new SchoolERPDBContext()) { using (var transaction = dbcontext.Database.BeginTransaction()) { try { for (int iAttendanceLoopCount = 1; iAttendanceLoopCount < myData.ToList().Count(); iAttendanceLoopCount++) { for (int nColumnCount = 3; nColumnCount < 3 + nDays; nColumnCount++) { Attendance newAttendance = new Attendance(); newAttendance.Academic_Year = Convert.ToInt32(GetAcademicYear()); if (Convert.ToString(myData[iAttendanceLoopCount][nColumnCount]) != "P" && Convert.ToString(myData[iAttendanceLoopCount][nColumnCount]) != "H" && Convert.ToString(myData[iAttendanceLoopCount][nColumnCount]) != "PH" && Convert.ToString(myData[iAttendanceLoopCount][nColumnCount]) != null) { newAttendance.Class_Id = Convert.ToInt16(TempData.Peek("Class_Id_For_Attendance")); newAttendance.Section_Id = Convert.ToInt16(TempData.Peek("Section_Id_For_Attendance")); newAttendance.Leave_Date = termStartDate.AddDays(nColumnCount - 3); newAttendance.Student_Id = nStudentIdArr[iAttendanceLoopCount - 1]; newAttendance.Leave_Reason = myData[iAttendanceLoopCount][nColumnCount]; newAttendance.Is_Active = true; //newAttendance.Is_Deleted = false; newAttendance.Term_Id = Convert.ToInt16(TempData.Peek("Term_Id_For_Attendance")); newAttendance.Created_By = 4; newAttendance.Created_On = DateTime.Now; newAttendance.Academic_Year = Convert.ToInt16(TempData.Peek("Year_For_Attendance")); if (dbcontext.Attendance.Where(a => a.Student_Id == newAttendance.Student_Id && a.Academic_Year == newAttendance.Academic_Year && a.Leave_Date == newAttendance.Leave_Date && (a.Is_Deleted == false || a.Is_Deleted == null)).Count() == 0) { dbcontext.Attendance.Add(newAttendance); dbcontext.SaveChanges(); } else { var attendanceId = dbcontext.Attendance.Where(a => a.Student_Id == newAttendance.Student_Id && a.Academic_Year == newAttendance.Academic_Year && a.Leave_Date == newAttendance.Leave_Date && (a.Is_Deleted == false || a.Is_Deleted == null)).ToList()[0].Id; Attendance attendanceToBeUpdated = dbcontext.Attendance.Find(attendanceId); attendanceToBeUpdated.Leave_Reason = myData[iAttendanceLoopCount][nColumnCount]; attendanceToBeUpdated.Is_Active = true; dbcontext.Entry(attendanceToBeUpdated).State = EntityState.Modified; dbcontext.SaveChanges(); } } else { newAttendance.Leave_Date = termStartDate.AddDays(nColumnCount - 3); string LeaveReason = myData[iAttendanceLoopCount][nColumnCount]; if (dbcontext.Attendance.Where(a => a.Student_Id == newAttendance.Student_Id && a.Academic_Year == newAttendance.Academic_Year && a.Leave_Date == newAttendance.Leave_Date && (a.Is_Deleted == false || a.Is_Deleted == null) && a.Leave_Reason != LeaveReason).Count() > 0) { var attendanceId = dbcontext.Attendance.Where(a => a.Student_Id == newAttendance.Student_Id && a.Academic_Year == newAttendance.Academic_Year && a.Leave_Date == newAttendance.Leave_Date && (a.Is_Deleted == false || a.Is_Deleted == null)).ToList()[0].Id; Attendance attendanceToBeUpdated = dbcontext.Attendance.Find(attendanceId); attendanceToBeUpdated.Leave_Reason = myData[iAttendanceLoopCount][nColumnCount]; attendanceToBeUpdated.Is_Active = false; attendanceToBeUpdated.Is_Deleted = true; dbcontext.Entry(attendanceToBeUpdated).State = EntityState.Modified; dbcontext.SaveChanges(); } } if (iAttendanceLoopCount == myData.ToList().Count() - 1 && nColumnCount == 3 + (nDays - 1)) { transaction.Commit(); sReturnText = "OK"; } } } } catch (Exception ex) { transaction.Rollback(); } } return(Json(sReturnText, JsonRequestBehavior.AllowGet)); } }
public JsonResult SaveFeeConfiguration(List <string[]> myData, string Academic_Year) { Fee_Configuration newFeeConfig = new Fee_Configuration(); int nUser_Id; nFeeIdArr = (int[])TempData.Peek("FeeIdArr"); string sReturnText = string.Empty; using (var dbcontext = new SchoolERPDBContext()) { //nUser_Id = dbcontext.Users.Where(x => x.User_Id == User.Identity.Name).ToList()[0].Id; ; nUser_Id = 4; } int nCount = myData.ToList().Count; int nLoopCount = 0; //var matchingvalues = myData.Where(stringToCheck => stringToCheck.Contains("Hostel Fees")); string hostelFeesIindex = Convert.ToString(myData.FindIndex(s => s.Contains("Hostel Fees"))); //var hostelFeesIndex = myData.FindIndex(matchingvalues); string schoolBusIndex = Convert.ToString(myData.FindIndex(s => s.Contains("School Bus"))); using (var dbcontext = new SchoolERPDBContext()) { using (var transaction = dbcontext.Database.BeginTransaction()) { try { for (int i = 0; i < nCount - 1; i++) { if (myData[i][0] != string.Empty && myData[i][0] != null) { for (int j = 0; j < 4; j++) { newFeeConfig.Class_Id = Convert.ToInt16(TempData.Peek("Class_Id")); newFeeConfig.Academic_Year = Convert.ToInt64(myData[i][1]); newFeeConfig.Fee_Id = Convert.ToInt16(nFeeIdArr[i]); newFeeConfig.Is_Active = true; if (j == 0) { newFeeConfig.Frequency = 1; newFeeConfig.Amount = (myData[i][2] == "") ? 0 : Convert.ToDecimal(myData[i][2]); newFeeConfig.Total = Convert.ToDecimal(myData[nCount - 1][2]); if (hostelFeesIindex != string.Empty) { int nhostelFeesIindex = Convert.ToInt16(hostelFeesIindex); newFeeConfig.Total_Excluding_HostelFees = Convert.ToDecimal(myData[nCount - 1][2]) - Convert.ToDecimal(myData[nhostelFeesIindex][2]); } if (schoolBusIndex != string.Empty) { int nschoolBusIndex = Convert.ToInt16(schoolBusIndex); newFeeConfig.Total_Excluding_Bus_Fees = Convert.ToDecimal(myData[nCount - 1][2]) - Convert.ToDecimal(myData[nschoolBusIndex][2]); } } else if (j == 1) { newFeeConfig.Frequency = 2; newFeeConfig.Amount = (myData[i][3] == "") ? 0 : Convert.ToDecimal(myData[i][3]); newFeeConfig.Total = Convert.ToDecimal(myData[nCount - 1][3]); if (hostelFeesIindex != string.Empty) { int nhostelFeesIindex = Convert.ToInt16(hostelFeesIindex); newFeeConfig.Total_Excluding_HostelFees = Convert.ToDecimal(myData[nCount - 1][3]) - Convert.ToDecimal(myData[nhostelFeesIindex][3]); } if (schoolBusIndex != string.Empty) { int nschoolBusIndex = Convert.ToInt16(schoolBusIndex); newFeeConfig.Total_Excluding_Bus_Fees = Convert.ToDecimal(myData[nCount - 1][3]) - Convert.ToDecimal(myData[nschoolBusIndex][3]); } } else if (j == 2) { newFeeConfig.Frequency = 3; newFeeConfig.Amount = (myData[i][4] == "") ? 0 : Convert.ToDecimal(myData[i][4]); newFeeConfig.Total = Convert.ToDecimal(myData[nCount - 1][4]); if (hostelFeesIindex != string.Empty) { int nhostelFeesIindex = Convert.ToInt16(hostelFeesIindex); newFeeConfig.Total_Excluding_HostelFees = Convert.ToDecimal(myData[nCount - 1][4]) - Convert.ToDecimal(myData[nhostelFeesIindex][4]); } if (schoolBusIndex != string.Empty) { int nschoolBusIndex = Convert.ToInt16(schoolBusIndex); newFeeConfig.Total_Excluding_Bus_Fees = Convert.ToDecimal(myData[nCount - 1][4]) - Convert.ToDecimal(myData[nschoolBusIndex][4]); } } else { newFeeConfig.Frequency = 4; newFeeConfig.Amount = (myData[i][5] == "") ? 0 : Convert.ToDecimal(myData[i][5]); newFeeConfig.Total = Convert.ToDecimal(myData[nCount - 1][5]); if (hostelFeesIindex != string.Empty) { int nhostelFeesIindex = Convert.ToInt16(hostelFeesIindex); newFeeConfig.Total_Excluding_HostelFees = Convert.ToDecimal(myData[nCount - 1][5]) - Convert.ToDecimal(myData[nhostelFeesIindex][5]); } if (schoolBusIndex != string.Empty) { int nschoolBusIndex = Convert.ToInt16(schoolBusIndex); newFeeConfig.Total_Excluding_Bus_Fees = Convert.ToDecimal(myData[nCount - 1][5]) - Convert.ToDecimal(myData[nschoolBusIndex][5]); } } newFeeConfig.Created_By = nUser_Id; newFeeConfig.Created_On = DateTime.Now; if (dbcontext.Fee_Configuration.Where(a => a.Class_Id == newFeeConfig.Class_Id && a.Fee_Id == newFeeConfig.Fee_Id && a.Academic_Year == newFeeConfig.Academic_Year && a.Frequency == newFeeConfig.Frequency && (a.Is_Deleted == false || a.Is_Deleted == null)).Count() == 0) { dbcontext.Fee_Configuration.Add(newFeeConfig); dbcontext.SaveChanges(); if (nCount - 3 == i && j == 3) { transaction.Commit(); sReturnText = "OK"; } } else { var feeConfigId = dbcontext.Fee_Configuration.Where(x => x.Fee_Id == newFeeConfig.Fee_Id && x.Class_Id == newFeeConfig.Class_Id && x.Academic_Year == newFeeConfig.Academic_Year && x.Frequency == newFeeConfig.Frequency && (x.Is_Deleted == false || x.Is_Deleted == null)).FirstOrDefault().Id; Fee_Configuration feeConfigToBeUpdated = dbcontext.Fee_Configuration.Find(feeConfigId); feeConfigToBeUpdated.Fee_Id = newFeeConfig.Fee_Id; feeConfigToBeUpdated.Class_Id = newFeeConfig.Class_Id; feeConfigToBeUpdated.Frequency = newFeeConfig.Frequency; feeConfigToBeUpdated.Amount = newFeeConfig.Amount; feeConfigToBeUpdated.Academic_Year = newFeeConfig.Academic_Year; feeConfigToBeUpdated.Total = newFeeConfig.Total; feeConfigToBeUpdated.Is_Active = true; feeConfigToBeUpdated.Total_Excluding_Bus_Fees = newFeeConfig.Total_Excluding_Bus_Fees; feeConfigToBeUpdated.Total_Excluding_HostelFees = newFeeConfig.Total_Excluding_HostelFees; dbcontext.Entry(feeConfigToBeUpdated).State = EntityState.Modified; dbcontext.SaveChanges(); if (nCount - 3 == i && j == 3) { transaction.Commit(); sReturnText = "Updated"; } } } } } } catch (Exception ex) { transaction.Rollback(); } } return(Json(sReturnText, JsonRequestBehavior.AllowGet)); } }