public JsonResult Create(StudentMasterVM studentMasterVM) { studentMasterVM.IsActive = 1; studentMasterVM.CreatedBy = 1; studentMasterVM.Id = Convert.ToInt32(TempData["Id"]); var result = _studentMasterRepository.UpSertStudentMaster(studentMasterVM); return(Json(result)); }
public string UpSertStudentMaster(StudentMasterVM studentMasterVM) { try { int studentId = 0; var result = ConvertSourceToDest <StudentMasterVM, Core.StudentMaster> .ConvertSourceToDestination(studentMasterVM); if (studentMasterVM.Id == 0) { using (dB_SPADevelopementEntities) { using (var transaction = dB_SPADevelopementEntities.Database.BeginTransaction()) { try { result.CreatedDate = DateTime.Now.Date; dB_SPADevelopementEntities.StudentMasters.Add(result); dB_SPADevelopementEntities.SaveChanges(); studentId = result.Id; StudentClassMapping studentClassMapping = new StudentClassMapping(); studentClassMapping.StudentId = studentId; studentClassMapping.AcademicYear = 1; studentClassMapping.classId = result.ClassId; studentClassMapping.sectionId = result.SectionId; studentClassMapping.CreatedBy = result.CreatedBy; studentClassMapping.CreatedDate = DateTime.Now.Date; dB_SPADevelopementEntities.StudentClassMappings.Add(studentClassMapping); dB_SPADevelopementEntities.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); } } } } //this code is used to perform the Student Master Update: else { using (dB_SPADevelopementEntities) { using (var transaction = dB_SPADevelopementEntities.Database.BeginTransaction()) { try { dB_SPADevelopementEntities.Entry(result).State = System.Data.Entity.EntityState.Modified; dB_SPADevelopementEntities.SaveChanges(); StudentClassMapping studentClassMapping = dB_SPADevelopementEntities.StudentClassMappings.Where(item => item.StudentId == result.Id).FirstOrDefault(); studentClassMapping.AcademicYear = studentMasterVM.AcademicYear; studentClassMapping.classId = studentMasterVM.ClassId; studentClassMapping.sectionId = studentMasterVM.SectionId; studentClassMapping.StudentId = result.Id; studentClassMapping.UpdatedBy = result.CreatedBy; studentClassMapping.UpdatedDate = DateTime.Now.Date; dB_SPADevelopementEntities.Entry(studentClassMapping).State = System.Data.Entity.EntityState.Modified; dB_SPADevelopementEntities.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); return(ex.Message); } } } } return("Student created successfully"); } catch (Exception e) { return(e.Message); } }