/// <summary>
/// Save Async
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public async Task <SubjectMasterModel> SaveAsync(SubjectMasterModel entity)
{
var subjectMasterMaster = await _subjectMasterDataAccess.SaveAsync(Mapper.Map <SubjectMaster>(entity));
return(new SubjectMasterModel {
SubjectMaster_ID = subjectMasterMaster.SubjectMaster_ID
});
}
/// <summary>
/// Save
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public SubjectMasterModel Save(SubjectMasterModel entity)
{
var subjectMasterMaster = _subjectMasterDataAccess.Save(Mapper.Map <SubjectMaster>(entity));
return(new SubjectMasterModel {
SubjectMaster_ID = subjectMasterMaster.SubjectMaster_ID
});
}
/// <summary>
/// Get All Subject Master Data
/// </summary>
/// <param name="objSubjectMasterTableModel"></param>
/// <returns></returns>
public List <SubjectMasterModel> GetAllSubjectMasterData(int pageNo, int pageSize, string sortOrder, string sortColumn)
{
List <SubjectMasterModel> getSubjectModelList = new List <SubjectMasterModel>();
GEEDbContext context = new GEEDbContext();
var masterTableData = (from subjectmstrTbl in context.SubjectMasters.Where(a => a.IsDeleted == false)
select new
{
subjectmstrTbl.SubjectMaster_ID,
subjectmstrTbl.SubjectType_Id,
subjectmstrTbl.AssessmentStructure_ID,
subjectmstrTbl.GradeStructure_ID,
subjectmstrTbl.SubjectGroup_ID,
subjectmstrTbl.Code,
subjectmstrTbl.Name,
subjectmstrTbl.Sessionyear,
subjectmstrTbl.isOptional,
subjectmstrTbl.IncludedInCGPA,
subjectmstrTbl.ExculdedfromAtt,
subjectmstrTbl.isScholastic
});
//Sorting
if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortOrder)))
{
masterTableData = masterTableData.OrderBy(sortColumn + " " + sortOrder);
}
int recordsTotal = masterTableData.Count();
var data = masterTableData.Skip(pageNo).Take(pageSize).ToList();
foreach (var item in data)
{
var master = context.MasterTables.Where(a => a.MasterTable_id == item.SubjectType_Id).FirstOrDefault();
SubjectMasterModel objSubjectMasterModel = new SubjectMasterModel();
objSubjectMasterModel.SubjectMaster_ID = item.SubjectMaster_ID;
objSubjectMasterModel.SubjectType_Id = item.SubjectType_Id;
objSubjectMasterModel.AssessmentStructure_ID = item.AssessmentStructure_ID;
objSubjectMasterModel.GradeStructure_ID = item.GradeStructure_ID;
objSubjectMasterModel.SubjectType_Id = item.SubjectType_Id;
objSubjectMasterModel.Code = item.Code;
objSubjectMasterModel.Name = item.Name;
objSubjectMasterModel.IncludedInCGPA = item.IncludedInCGPA;
objSubjectMasterModel.ExculdedfromAtt = item.ExculdedfromAtt;
objSubjectMasterModel.isScholastic = item.isScholastic;
objSubjectMasterModel.isOptional = item.isOptional;
objSubjectMasterModel.AssessmentStructureName = item.AssessmentStructure_ID != null?context.MasterTables.Where(a => a.MasterTable_id == item.AssessmentStructure_ID).FirstOrDefault().Name : "";
objSubjectMasterModel.GradeStructureName = item.GradeStructure_ID != null?context.MasterTables.Where(a => a.MasterTable_id == item.GradeStructure_ID).FirstOrDefault().Name : "";
objSubjectMasterModel.SubjectTypeName = item.SubjectType_Id != null?context.MasterTables.Where(a => a.MasterTable_id == item.SubjectType_Id).FirstOrDefault().Name : "";
objSubjectMasterModel.SubjectGroupName = item.SubjectGroup_ID != null?context.MasterTables.Where(a => a.MasterTable_id == item.GradeStructure_ID).FirstOrDefault().Name : "";
getSubjectModelList.Add(objSubjectMasterModel);
}
getSubjectModelList[0].RowCount = recordsTotal;
return(getSubjectModelList);
}
public async Task <HttpResponseMessage> Update(SubjectMasterModel subjectMaster)
{
try
{
await _subjectMaster.UpdateAsync(subjectMaster);
}
catch (Exception ex)
{
Common.MyLogger.Error(ex.Message + ex.StackTrace + ex.InnerException.ToString());
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Update Error"));
}
return(Request.CreateResponse(HttpStatusCode.OK, "Data Updated"));
}
public JsonResult <List <SubjectMasterModel> > GetAllSubjectMasterData(SubjectMasterModel objSubjectMasterModel)
{
try
{
var record = _subjectMaster.GetAllSubjectMasterData(objSubjectMasterModel.PageNo, objSubjectMasterModel.PageSize, objSubjectMasterModel.SortOrder, objSubjectMasterModel.SortColumn);
return(Json(record));
}
catch (Exception ex)
{
Common.MyLogger.Error(ex.Message + ex.StackTrace + ex.InnerException.ToString());
return(null);
}
}
/// <summary>
/// Delete
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool DeleteSubjectMaster(SubjectMasterModel entity)
{
bool isDelete = false;
try
{
var objentity = _subjectMasterDataAccess.GetById(entity.SubjectMaster_ID);
if (objentity != null)
{
objentity.IsDeleted = true;
objentity.Modifiedby_ID = (int)entity.ModifiedBy_ID;
objentity.ModifiedDate = (DateTime)entity.ModifiedDate;
_subjectMasterDataAccess.UpdateAsync(objentity);
isDelete = true;
}
}
catch (Exception)
{
isDelete = false;
}
return(isDelete);
}
/// <summary>
/// Delete Async
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public async Task DeleteAsync(SubjectMasterModel entity)
{
await _subjectMasterDataAccess.DeleteAsync(entity.SubjectMaster_ID);
}
/// <summary>
/// Delete
/// </summary>
/// <param name="entity"></param>
public void Delete(SubjectMasterModel entity)
{
_subjectMasterDataAccess.Delete(entity.SubjectMaster_ID);
}
