public MasterTableModel Save(MasterTableModel entity)
{
var masterTable = _masterTableDataAccess.Save(Mapper.Map <MasterTable>(entity));
return(new MasterTableModel {
MasterTable_id = masterTable.MasterTable_id
});
}
/// <summary>
/// This method is used to get Master data to bind datagrid table
/// Added by Jiya
/// Date: 30 April 2019
/// </summary>
/// <param name="pageNo"></param>
/// <param name="pageSize"></param>
/// <param name="sortOrder"></param>
/// <param name="sortColumn"></param>
/// <returns></returns>
public List <MasterTableModel> GetAllMasterData(MasterTableModel objMasterTableModel)
{
List <MasterTableModel> getMasterTableModelList = new List <MasterTableModel>();
GEEDbContext context = new GEEDbContext();
var masterTableData = (from mstTbl in context.MasterTables
join mng in context.MasterTables on mstTbl.Parent_id equals mng.MasterTable_id into tempJoin
from t2 in tempJoin.DefaultIfEmpty()
where mstTbl.ISDeleted != true && mstTbl.Mastertabletype_id == objMasterTableModel.Mastertabletype_id
select new {
mstTbl.MasterTable_id,
mstTbl.Mastertabletype_id,
mstTbl.Code,
mstTbl.Name,
mstTbl.Parent_id,
mstTbl.Remark,
mstTbl.Sessionyear,
mstTbl.IsDefault,
ParentName = (t2.Name == null ? String.Empty : t2.Name),
DefaultValue = mstTbl.IsDefault == true ? "Yes" : "No"
});
//Sorting
if (!(string.IsNullOrEmpty(objMasterTableModel.SortColumn) && string.IsNullOrEmpty(objMasterTableModel.SortOrder)))
{
masterTableData = masterTableData.OrderBy(objMasterTableModel.SortColumn + " " + objMasterTableModel.SortOrder);
}
int recordsTotal = masterTableData.Count();
var data = masterTableData.Skip(objMasterTableModel.PageNo).Take(objMasterTableModel.PageSize).ToList();
foreach (var item in data)
{
MasterTableModel objMasterModel = new MasterTableModel();
objMasterModel.MasterTable_id = item.MasterTable_id;
objMasterModel.Mastertabletype_id = item.Mastertabletype_id;
objMasterModel.Code = item.Code;
objMasterModel.Name = item.Name;
objMasterModel.Parent_id = item.Parent_id;
objMasterModel.Remark = item.Remark;
objMasterModel.Sessionyear = item.Sessionyear;
objMasterModel.IsDefault = item.IsDefault;
objMasterModel.ParentName = item.ParentName;
objMasterModel.DefaultValue = item.DefaultValue;
objMasterModel.RowCount = recordsTotal;
getMasterTableModelList.Add(objMasterModel);
}
return(getMasterTableModelList);
}
public async Task <HttpResponseMessage> Save(MasterTableModel masterTable)
{
try
{
await _iMasterTable.SaveAsync(masterTable);
}
catch (Exception ex)
{
Common.MyLogger.Error(ex.Message + ex.StackTrace + ex.InnerException.ToString());
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Error"));
}
return(Request.CreateResponse(HttpStatusCode.OK, "Data Saved"));
}
public HttpResponseMessage Delete(MasterTableModel entity)
{
try
{
_iMasterTable.DeleteMaster(entity);
}
catch (Exception ex)
{
Common.MyLogger.Error(ex.Message + ex.StackTrace + ex.InnerException.ToString());
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Delete Error"));
}
return(Request.CreateResponse(HttpStatusCode.OK, "Data Updated"));
}
public async Task <MasterTableModel> SaveAsync(MasterTableModel entity)
{
var isExist = ChechIsDefaultInMasterTable((int)entity.SchoolID, (int)entity.GroupID);
if ((bool)entity.IsDefault && isExist)
{
UpdateIsDefault((int)entity.SchoolID, (int)entity.GroupID);
}
var masterTable = await _masterTableDataAccess.SaveAsync(Mapper.Map <MasterTable>(entity));
return(new MasterTableModel {
MasterTable_id = masterTable.MasterTable_id
});
}
public JsonResult <List <MasterTableModel> > GetAllMasterData(MasterTableModel objMasterTableModel)
{
try
{
var record = _iMasterTable.GetAllMasterData(objMasterTableModel);
//record.ForEach(a => a.MasterTabletype.MasterTables = null);
return(Json(record));
}
catch (Exception ex)
{
Common.MyLogger.Error(ex.Message + ex.StackTrace + ex.InnerException.ToString());
return(null);
}
}
public bool DeleteMaster(MasterTableModel entity)
{
bool result = false;
var objentity = _masterTableDataAccess.GetById(entity.MasterTable_id);
if (objentity != null)
{
objentity.ISDeleted = true;
objentity.ModifiedBy_ID = entity.ModifiedBy_ID;
objentity.ModifiedDate = entity.ModifiedDate;
_masterTableDataAccess.UpdateAsync(objentity);
result = true;
}
return(result);
}
public async Task DeleteAsync(MasterTableModel entity)
{
await _masterTableDataAccess.DeleteAsync(entity.MasterTable_id);
}
public void Delete(MasterTableModel entity)
{
_masterTableDataAccess.Delete(entity.MasterTable_id);
}
