public void UpdateStatus(DTO.LABURNUM.COM.BusRouteModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
new FrontEndApi.BusRouteApi().UpdateIsActive(model);
}
}
private long AddValidation(DTO.LABURNUM.COM.BusRouteModel model)
{
model.BusStartFrom.TryValidate();
model.BusRouteNumber.TryValidate();
model.BusEndAt.TryValidate();
return(AddBusRoute(model));
}
public List <DTO.LABURNUM.COM.BusRouteModel> SearchBusRouteByAdvanceSearch(DTO.LABURNUM.COM.BusRouteModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
return(new BusRouteHelper(new FrontEndApi.BusRouteApi().GetBusRouteByAdvanceSearch(model)).Map());
}
else
{
return(null);
}
}
public long Add(DTO.LABURNUM.COM.BusRouteModel model)
{
if (new FrontEndApi.ApiClientApi().IsClientValid(model.ApiClientModel.UserName, model.ApiClientModel.Password))
{
return(new FrontEndApi.BusRouteApi().Add(model));
}
else
{
return(-1);
}
}
private long AddBusRoute(DTO.LABURNUM.COM.BusRouteModel model)
{
API.LABURNUM.COM.BusRoute apibusRoute = new BusRoute()
{
BusRouteNumber = model.BusRouteNumber,
BusStartFrom = model.BusStartFrom,
BusEndAt = model.BusEndAt,
TranportCharges = model.TranportCharges,
CreatedOn = new Component.Utility().GetISTDateTime(),
IsActive = true
};
this._laburnum.BusRoutes.Add(apibusRoute);
this._laburnum.SaveChanges();
return(apibusRoute.BusRouteId);
}
private DTO.LABURNUM.COM.BusRouteModel MapCore(API.LABURNUM.COM.BusRoute apiBusRoute)
{
DTO.LABURNUM.COM.BusRouteModel dtoClass = new DTO.LABURNUM.COM.BusRouteModel()
{
BusRouteId = apiBusRoute.BusRouteId,
BusRouteNumber = apiBusRoute.BusRouteNumber,
BusStartFrom = apiBusRoute.BusStartFrom,
BusEndAt = apiBusRoute.BusEndAt,
TranportCharges = apiBusRoute.TranportCharges,
CreatedOn = apiBusRoute.CreatedOn,
IsActive = apiBusRoute.IsActive,
LastUpdate = apiBusRoute.LastUpdate,
StartPointEndPoint = apiBusRoute.BusStartFrom + " To " + apiBusRoute.BusEndAt
};
return(dtoClass);
}
public void UpdateIsActive(DTO.LABURNUM.COM.BusRouteModel model)
{
model.BusRouteId.TryValidate();
IQueryable <API.LABURNUM.COM.BusRoute> iQuery = this._laburnum.BusRoutes.Where(x => x.BusRouteId == model.BusRouteId && x.IsActive == true);
List <API.LABURNUM.COM.BusRoute> dbRoutes = iQuery.ToList();
if (dbRoutes.Count == 0)
{
throw new Exception(API.LABURNUM.COM.Component.Constants.ERRORMESSAGES.NO_RECORD_FOUND);
}
if (dbRoutes.Count > 1)
{
throw new Exception(API.LABURNUM.COM.Component.Constants.ERRORMESSAGES.MORE_THAN_ONE_RECORDFOUND);
}
dbRoutes[0].IsActive = model.IsActive;
dbRoutes[0].LastUpdate = new Component.Utility().GetISTDateTime();
this._laburnum.SaveChanges();
}
public long Add(DTO.LABURNUM.COM.BusRouteModel model)
{
return(AddValidation(model));
}
public List <API.LABURNUM.COM.BusRoute> GetBusRouteByAdvanceSearch(DTO.LABURNUM.COM.BusRouteModel model)
{
IQueryable <API.LABURNUM.COM.BusRoute> iQuery = null;
//Search Bus Route Id.
if (model.BusRouteId > 0)
{
iQuery = this._laburnum.BusRoutes.Where(x => x.BusRouteId == model.BusRouteId && x.IsActive == true);
}
//Search Bus Number.
if (iQuery != null)
{
if (model.BusRouteNumber != null)
{
iQuery = iQuery.Where(x => x.BusRouteNumber.Trim().ToLower().Equals(model.BusRouteNumber.Trim().ToLower()) && x.IsActive == true);
}
}
else
{
if (model.BusRouteNumber != null)
{
iQuery = this._laburnum.BusRoutes.Where(x => x.BusRouteNumber.Trim().ToLower().Equals(model.BusRouteNumber.Trim().ToLower()) && x.IsActive == true);
}
}
//Search Bus Start From.
if (iQuery != null)
{
if (model.BusStartFrom != null)
{
iQuery = iQuery.Where(x => x.BusStartFrom.Trim().ToLower().Contains(model.BusStartFrom.Trim().ToLower()) && x.IsActive == true);
}
}
else
{
if (model.BusStartFrom != null)
{
iQuery = this._laburnum.BusRoutes.Where(x => x.BusStartFrom.Trim().ToLower().Contains(model.BusStartFrom.Trim().ToLower()) && x.IsActive == true);
}
}
//Search Bus End At.
if (iQuery != null)
{
if (model.BusEndAt != null)
{
iQuery = iQuery.Where(x => x.BusEndAt.Trim().ToLower().Contains(model.BusEndAt.Trim().ToLower()) && x.IsActive == true);
}
}
else
{
if (model.BusEndAt != null)
{
iQuery = this._laburnum.BusRoutes.Where(x => x.BusEndAt.Trim().ToLower().Contains(model.BusEndAt.Trim().ToLower()) && x.IsActive == true);
}
}
List <API.LABURNUM.COM.BusRoute> dbBusRoute = iQuery.ToList();
return(dbBusRoute);
}
