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