public SectionMasterVM GetEntityById(int entityId) { var sourceResult = dB_SPADevelopementEntities.Sections.Find(entityId); var destination = ConvertSourceToDest <Section, SectionMasterVM> .ConvertSourceToDestination(sourceResult); return(destination); }
public CategoryMasterVM GetEntityById(int entityId) { var result = dB_SPADevelopementEntities.Categories.Find(entityId); var destination = ConvertSourceToDest <Category, CategoryMasterVM> .ConvertSourceToDestination(result); return(destination); }
public ClassMasterVm GetEntityById(int entityId) { var result = dB_SPADevelopementEntities.Classes.Find(entityId); var destination = ConvertSourceToDest <Core.Class, ClassMasterVm> .ConvertSourceToDestination(result); return(destination); }
public string InsertEntity(CategoryMasterVM entity) { var result = ConvertSourceToDest <CategoryMasterVM, Category> .ConvertSourceToDestination(entity); dB_SPADevelopementEntities.Categories.Add(result); dB_SPADevelopementEntities.SaveChanges(); return("Category created successfully"); }
public string UpdateEntity(SectionMasterVM entity) { var destination = ConvertSourceToDest <SectionMasterVM, Section> .ConvertSourceToDestination(entity); dB_SPADevelopementEntities.Entry(destination).State = System.Data.Entity.EntityState.Modified; dB_SPADevelopementEntities.SaveChanges(); return("section master Updated successfully"); }
public string InsertEntity(SectionMasterVM entity) { var destination = ConvertSourceToDest <SectionMasterVM, Section> .ConvertSourceToDestination(entity); dB_SPADevelopementEntities.Sections.Add(destination); dB_SPADevelopementEntities.SaveChanges(); return("Section created successfully"); }
public string UpdateEntity(ClassMasterVm entity) { var result = ConvertSourceToDest <ClassMasterVm, Class> .ConvertSourceToDestination(entity); dB_SPADevelopementEntities.Entry(result).State = System.Data.Entity.EntityState.Modified; dB_SPADevelopementEntities.SaveChanges(); return("Class Updated SuccessFully"); }
public string InsertEntity(ClassMasterVm entity) { entity.CreatedDate = System.DateTime.Now.Date; var result = ConvertSourceToDest <ClassMasterVm, Class> .ConvertSourceToDestination(entity); dB_SPADevelopementEntities.Classes.Add(result); dB_SPADevelopementEntities.SaveChanges(); return("Class Created SuccessFully"); }
public FeeHeadMasterVM GetEntityById(int entityId) { using (dB_SPADevelopementEntities) { var result = dB_SPADevelopementEntities.FeeHeadMasters.Find(entityId); var destination = ConvertSourceToDest <FeeHeadMaster, FeeHeadMasterVM> .ConvertSourceToDestination(result); return(destination); } }
public string UpdateEntity(CategoryMasterVM entity) { var result = ConvertSourceToDest <CategoryMasterVM, Category> .ConvertSourceToDestination(entity); result.UpdatedBy = entity.CreatedBy; result.UpdatedDate = DateTime.Now.Date; dB_SPADevelopementEntities.Entry(result).State = System.Data.Entity.EntityState.Modified; dB_SPADevelopementEntities.SaveChanges(); return("Category updated successfully"); }
public AcademicMasterVm GetEntityById(int entityId) { using (dB_SPADevelopementEntities) { var result = dB_SPADevelopementEntities.AcademicMasters.Find(entityId); var destination = ConvertSourceToDest <AcademicMaster, AcademicMasterVm> .ConvertSourceToDestination(result); return(destination); } }
public string InsertEntity(InstitueDetail entity) { using (sMSDataLayerEntities) { var dest = ConvertSourceToDest <Contract.InstitueDetail, Core.InstituteDetail> .ConvertSourceToDestination(entity); sMSDataLayerEntities.InstituteDetails.Add(dest); sMSDataLayerEntities.SaveChanges(); return("Institute Created SuccessFully"); } }
public string InsertEntity(FeeHeadMasterVM entity) { using (dB_SPADevelopementEntities) { var destination = ConvertSourceToDest <FeeHeadMasterVM, FeeHeadMaster> .ConvertSourceToDestination(entity); dB_SPADevelopementEntities.FeeHeadMasters.Add(destination); dB_SPADevelopementEntities.SaveChanges(); return("Fee Head created successfully"); } }
public string InsertEntity(AcademicMasterVm entity) { using (dB_SPADevelopementEntities) { var result = ConvertSourceToDest <AcademicMasterVm, AcademicMaster> .ConvertSourceToDestination(entity); dB_SPADevelopementEntities.AcademicMasters.Add(result); dB_SPADevelopementEntities.SaveChanges(); return("Academic master created successfully"); } }
public string UpdateEntity(InstitueDetail entity) { using (sMSDataLayerEntities) { var dest = ConvertSourceToDest <Contract.InstitueDetail, Core.InstituteDetail> .ConvertSourceToDestination(entity); sMSDataLayerEntities.Entry(dest).State = System.Data.Entity.EntityState.Modified; sMSDataLayerEntities.SaveChanges(); return("Institute UpDated SuccessFully"); } }
public string UpdateEntity(FeeHeadMasterVM entity) { using (dB_SPADevelopementEntities) { var destination = ConvertSourceToDest <FeeHeadMasterVM, FeeHeadMaster> .ConvertSourceToDestination(entity); destination.Updatedby = entity.CreatedBy; destination.UpdatedDate = DateTime.Now.Date; dB_SPADevelopementEntities.Entry(destination).State = System.Data.Entity.EntityState.Modified; dB_SPADevelopementEntities.SaveChanges(); return("Fee head updated successfully"); } }
public string UpdateEntity(AcademicMasterVm entity) { using (dB_SPADevelopementEntities) { var result = ConvertSourceToDest <AcademicMasterVm, AcademicMaster> .ConvertSourceToDestination(entity); result.UpdateDate = entity.UpdateDate; result.UpdatedBy = entity.UpdatedBy; result.IsActive = 1; dB_SPADevelopementEntities.Entry(result).State = System.Data.Entity.EntityState.Modified; dB_SPADevelopementEntities.SaveChanges(); return("Academic Master updated successfully"); } }
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); } }