public ServiceResponseModel <List <LocationServiceModel> > GetLocationList(ServiceBaseModel ObjServiceBaseModel)
{
try
{
var lstLocation = new List <LocationServiceModel>();
var ObjServiceResponseModel = new ServiceResponseModel <List <LocationServiceModel> >();
if (ObjServiceBaseModel != null && ObjServiceBaseModel.ServiceAuthKey != null)
{
var userData = _workorderems.UserRegistrations.Where(x => x.ServiceAuthKey == ObjServiceBaseModel.ServiceAuthKey &&
x.IsDeleted == false).FirstOrDefault();
//_workorderems.EmployeeLocationMappings.Join(_workorderems.LocationMasters, q => q.LocationId, u => u.LocationId, (q, u) => new { q, u }).
// Where(x => x.q.)
if (userData != null)
{
lstLocation = _workorderems.LocationMasters.Where(x => x.IsDeleted == false).Select(a => new LocationServiceModel()
{
LocationId = a.LocationId,
LocationName = a.LocationName
}).ToList();
if (lstLocation.Count > 0)
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.SuccessResponse, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Message = CommonMessage.Successful();
ObjServiceResponseModel.Data = lstLocation;
}
else
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.NoRecord, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Message = CommonMessage.NoRecordMessage();
ObjServiceResponseModel.Data = null;
}
}
else
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.NoRecord, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Message = CommonMessage.NoRecordMessage();
ObjServiceResponseModel.Data = null;
}
return(ObjServiceResponseModel);
}
else
{
return(null);
}
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public ServiceResponseModel<List<LocationServiceModel>> GetLocationAssignedListByUserId(ServiceBaseModel ObjServiceBaseModel)", "Exception While Getting List of Location Assigned to user.", null);
throw;
}
}
/// <summary>
/// Created By : Ashwajit Bansod
/// Created Date : 20-Dec-2018
/// Created For : To get Pre Bill Number
/// </summary>
/// <param name="ObjServiceBaseModel"></param>
/// <returns></returns>
public ServiceResponseModel <BillNumberData> GetPreBillNumberData(ServiceBaseModel ObjServiceBaseModel)
{
var ObjServiceResponseModel = new ServiceResponseModel <BillNumberData>();
var objCommonRepository = new CommonRepository();
var ObjUserRepository = new UserRepository();
var billNumberValue = new BillNumberData();
try
{
var authuser = ObjUserRepository.GetSingleOrDefault(x => x.ServiceAuthKey == ObjServiceBaseModel.ServiceAuthKey && x.IsDeleted == false);
if (authuser != null && authuser.UserId > 0)
{
var BillNumber = _workorderems.spGetPreBillNumber().FirstOrDefault();
billNumberValue.BillNumber = BillNumber;
if (BillNumber != null)
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.SuccessResponse, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Data = billNumberValue;
ObjServiceResponseModel.Message = CommonMessage.Successful();
}
else
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.ExeptionResponse, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Data = billNumberValue;
ObjServiceResponseModel.Message = CommonMessage.WrongParameterMessage();
}
}
else
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.InvalidSessionResponse, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Message = CommonMessage.InvalidUser();
}
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public ServiceResponseModel<int?> GetPreBillNumberData(ServiceBaseModel ObjServiceBaseModel)", "Exception while gettig Bill number", ObjServiceBaseModel);
throw ex;
}
return(ObjServiceResponseModel);
}
public IHttpActionResult GetAllPendingPreventativeMaintenanceList(ServiceBaseModel obj)
{
var ObjServiceResponseModel = new ServiceResponseModel <List <PendingPM> >();
try
{
if (obj != null && obj.ServiceAuthKey != null && obj.UserId > 0 && obj.LocationID > 0)
{
//var ObjPreventativeMaintenaceManager = new PreventativeMaintenaceManager();
var PMList = _IEfleetPM.GetAllPendingPMReminderDescription(obj.LocationID);
if (PMList.Count > 0)
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.SuccessResponse, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Message = CommonMessage.Successful();
ObjServiceResponseModel.Data = PMList;
}
else
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.NoRecord, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Message = CommonMessage.NoRecordMessage();
}
return(Ok(ObjServiceResponseModel));
}
else
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.FailedResponse, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Message = CommonMessage.WrongParameterMessage();
return(Ok(ObjServiceResponseModel));
}
}
catch (Exception ex)
{
ObjServiceResponseModel.Message = ex.Message;
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.ExeptionResponse, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Data = null;
return(Ok(ObjServiceResponseModel));
}
}
public IHttpActionResult GetAllVehicleList(ServiceBaseModel obj)
{
var ObjServiceResponseModel = new ServiceResponseModel <List <VehicleDetailsModel> >();
try
{
if (obj != null && obj.ServiceAuthKey != null && obj.UserId > 0 && obj.LocationID > 0)
{
// var ObjVehicleManager = new VehicleManager();
var vehicleList = _IEfleetVehicle.GetAllVehicleListDetails(obj);
if (vehicleList.Count > 0)
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.SuccessResponse, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Message = CommonMessage.Successful();
ObjServiceResponseModel.Data = vehicleList;
}
else
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.NoRecord, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Message = CommonMessage.NoRecordMessage();
}
return(Ok(ObjServiceResponseModel));
}
else
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.FailedResponse, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Message = CommonMessage.WrongParameterMessage();
return(Ok(ObjServiceResponseModel));
}
}
catch (Exception ex)
{
ObjServiceResponseModel.Message = ex.Message;
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.ExeptionResponse, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Data = null;
return(Ok(ObjServiceResponseModel));
}
}
/// <summary>
/// Created By : Ashwajit Bansod
/// Created Date : 16-OCT-2018
/// Created For : To get miscellaneous Cost code List
/// </summary>
/// <param name="ObjServiceBaseModel"></param>
/// <returns></returns>
public ServiceResponseModel <List <MiscellaneousModel> > GetMiscellaneousList(ServiceBaseModel ObjServiceBaseModel)
{
try
{
var lstMiscellaneous = new List <MiscellaneousModel>();
var ObjServiceResponseModel = new ServiceResponseModel <List <MiscellaneousModel> >();
if (ObjServiceBaseModel != null && ObjServiceBaseModel.ServiceAuthKey != null)
{
var userData = _workorderems.UserRegistrations.Where(x => x.ServiceAuthKey == ObjServiceBaseModel.ServiceAuthKey &&
x.IsDeleted == false).FirstOrDefault();
if (userData != null)
{
lstMiscellaneous = _workorderems.CostCodes.Join(_workorderems.CostCodeMasters, q => q.CCD_CCM_CostCode, u => u.CCM_CostCode, (q, u) => new { q, u }).
Where(x => x.u.CCM_Description == "Miscellaneous" && x.q.CCD_IsActive == "Y").
Select(x => new MiscellaneousModel()
{
CostCodeId = x.q.CCD_CostCode,
CostCodeName = x.q.CCD_Description
}).ToList();
if (lstMiscellaneous.Count > 0)
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.SuccessResponse, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Message = CommonMessage.Successful();
ObjServiceResponseModel.Data = lstMiscellaneous;
}
else
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.NoRecord, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Message = CommonMessage.NoRecordMessage();
ObjServiceResponseModel.Data = null;
}
}
else
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.NoRecord, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Message = CommonMessage.NoRecordMessage();
ObjServiceResponseModel.Data = null;
}
return(ObjServiceResponseModel);
}
else
{
return(null);
}
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public ServiceResponseModel<List<MiscellaneousModel>> GetMiscellaneousList(ServiceBaseModel ObjServiceBaseModel)", "Exception While Getting List of Miscellaneous Cost code.", null);
throw;
}
}
/// <summary>
/// Created By: Ashwajit Bansod
/// Created Date : 17-OCT-2018
/// Created For : To get miscellaneous number
/// </summary>
/// <param name="ObjServiceBaseModel"></param>
/// <returns></returns>
public ServiceResponseModel <miscellaneousNumberModel> GetMiscellaneousNumberData(ServiceBaseModel ObjServiceBaseModel)
{
try
{
var MiscellaneousNumber = new miscellaneousNumberModel();
var ObjServiceResponseModel = new ServiceResponseModel <miscellaneousNumberModel>();
if (ObjServiceBaseModel != null && ObjServiceBaseModel.ServiceAuthKey != null)
{
var userData = _workorderems.UserRegistrations.Where(x => x.ServiceAuthKey == ObjServiceBaseModel.ServiceAuthKey &&
x.IsDeleted == false &&
x.IsEmailVerify == true).FirstOrDefault();
if (userData != null)
{
var number = _workorderems.spGetMisNumber().FirstOrDefault();
MiscellaneousNumber.MISNumber = "MIS" + number;
if (MiscellaneousNumber.MISNumber != null)
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.SuccessResponse, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Message = CommonMessage.Successful();
ObjServiceResponseModel.Data = MiscellaneousNumber;
}
else
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.NoRecord, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Message = CommonMessage.NoRecordMessage();
ObjServiceResponseModel.Data = null;
}
}
else
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.NoRecord, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Message = CommonMessage.NoRecordMessage();
ObjServiceResponseModel.Data = null;
}
return(ObjServiceResponseModel);
}
else
{
return(null);
}
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public ServiceResponseModel<miscellaneousNumberModel> GetMiscellaneousNumberData(ServiceBaseModel ObjServiceBaseModel)", "Exception While Getting Miscellaneous number.", null);
throw;
}
}
public List <eFleetPassengerTrackingRouteModel> GetAllPassengerTrackingRouteDetails(ServiceBaseModel obj)
{
try
{
var db = new workorderEMSEntities();
var Results = db.eFleetPassengerTrackingCounts.Where(a => a.IsDeleted == false).Select(a => new eFleetPassengerTrackingRouteModel()
{
RouteID = a.RouteID,
ServiceType = a.GlobalCode.GlobalCodeId
//VehicleIdentificationNo = a.VehicleIdentificationNo,
//VehicleNumber = a.VehicleNumber
}).ToList <eFleetPassengerTrackingRouteModel>();
return(Results);
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public List<eFleetPassengerTrackingRouteModel> GetAllPassengerTrackingRouteDetails(ServiceBaseModel obj)", "Exception While Listing Route detail.", obj.UserId);
throw;
}
}
