/// <summary>
/// Save Async
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public async Task <StopMasterModel> SaveAsync(StopMasterModel entity)
{
var StopMasterMaster = await _StopMasterDataAccess.SaveAsync(Mapper.Map <StopMaster>(entity));
return(new StopMasterModel {
StopMasterID = StopMasterMaster.StopMasterID
});
}
/// <summary>
/// Save
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public StopMasterModel Save(StopMasterModel entity)
{
var StopMasterMaster = _StopMasterDataAccess.Save(Mapper.Map <StopMaster>(entity));
return(new StopMasterModel {
StopMasterID = StopMasterMaster.StopMasterID
});
}
public async Task <HttpResponseMessage> Update(StopMasterModel StopMaster)
{
try
{
await _StopMaster.UpdateAsync(StopMaster);
}
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 <StopMasterModel> > GetAllStopMasterData(StopMasterModel objStopMasterModel)
{
try
{
var record = _StopMaster.GetAllStopMasterData(objStopMasterModel.PageNo, objStopMasterModel.PageSize, objStopMasterModel.SortOrder, objStopMasterModel.SortColumn);
return(Json(record));
}
catch (Exception ex)
{
Common.MyLogger.Error(ex.Message + ex.StackTrace + ex.InnerException.ToString());
return(null);
}
}
/// <summary>
/// Get All stop Master Data
/// </summary>
/// <param name="objStopMasterTableModel"></param>
/// <returns></returns>
public List <StopMasterModel> GetAllStopMasterData(int pageNo, int pageSize, string sortOrder, string sortColumn)
{
List <StopMasterModel> getstopModelList = new List <StopMasterModel>();
GEEDbContext context = new GEEDbContext();
var masterTableData = (from stopmstrTbl in context.StopMasters.Where(a => a.IsDeleted == false)
select new
{
stopmstrTbl.StopMasterID,
stopmstrTbl.StopCode,
stopmstrTbl.StopName,
stopmstrTbl.Locality,
stopmstrTbl.StopAddress,
stopmstrTbl.PinCode,
stopmstrTbl.GeoCoordinates,
stopmstrTbl.Sessionyear,
});
//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)
{
StopMasterModel stopmstrTbl = new StopMasterModel();
stopmstrTbl.StopMasterID = item.StopMasterID;
stopmstrTbl.StopCode = item.StopCode;
stopmstrTbl.StopName = item.StopName;
stopmstrTbl.Locality = item.Locality;
stopmstrTbl.StopAddress = item.StopAddress;
stopmstrTbl.PinCode = item.PinCode;
stopmstrTbl.GeoCoordinates = item.GeoCoordinates;
stopmstrTbl.Sessionyear = item.Sessionyear;
getstopModelList.Add(stopmstrTbl);
}
if (getstopModelList.Count > 0)
{
getstopModelList[0].RowCount = recordsTotal;
}
return(getstopModelList);
}
/// <summary>
/// Delete
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool DeleteStopMaster(StopMasterModel entity)
{
bool isDelete = false;
try
{
var objentity = _StopMasterDataAccess.GetById(entity.StopMasterID);
if (objentity != null)
{
objentity.IsDeleted = true;
objentity.Modifiedby_ID = (int)entity.ModifiedBy_ID;
objentity.ModifiedDate = (DateTime)entity.ModifiedDate;
_StopMasterDataAccess.UpdateAsync(objentity);
isDelete = true;
}
}
catch (Exception)
{
isDelete = false;
}
return(isDelete);
}
/// <summary>
/// Delete Async
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public async Task DeleteAsync(StopMasterModel entity)
{
await _StopMasterDataAccess.DeleteAsync(entity.StopMasterID);
}
/// <summary>
/// Delete
/// </summary>
/// <param name="entity"></param>
public void Delete(StopMasterModel entity)
{
_StopMasterDataAccess.Delete(entity.StopMasterID);
}
