public IHttpActionResult SaveeFleetFueling(eFleetFuelingModelForService objeFleetFuelingModel)
{
var ObjServiceResponseModel = new ServiceResponseModel <string>();
try
{
// var objeFleetCommonManager = new eFleetCommonManager();
if (objeFleetFuelingModel != null && objeFleetFuelingModel.ServiceAuthKey != null && objeFleetFuelingModel.UserId > 0)
{
var ObjRespnse = _IFuelingManager.InserteFleetFueling(objeFleetFuelingModel);
return(Ok(ObjRespnse));
}
else
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.FailedResponse, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Message = CommonMessage.InvalidUser();
return(Ok(ObjServiceResponseModel));
}
}
catch (Exception ex)
{
ObjServiceResponseModel.Message = ex.InnerException.ToString();
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.ExeptionResponse, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Data = null;
return(Ok(ObjServiceResponseModel));
}
}
public eFleetFuelingModelForService GeteFleetFuelingDetailsById(long fuelID)
{
try
{
var db = new workorderEMSEntities();
var editeFleetfuelDetails = new eFleetFuelingModelForService();
var efleetfuelingDetails = db.eFleetFuelings.Where(u => u.FuelID == fuelID).FirstOrDefault();
if (efleetfuelingDetails.FuelID > 0)
{
AutoMapper.Mapper.CreateMap <eFleetFueling, eFleetFuelingModelForService>();
var objfleetVehicleMapper = AutoMapper.Mapper.Map(efleetfuelingDetails, editeFleetfuelDetails);
}
return(editeFleetfuelDetails);
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "eFleetFuelingModelForService GeteFleetFuelingDetailsById(long fuelID)", "Exception While getting fuel detail by id.", null);
throw;
}
}
public JsonResult GetFuelingList(int?rows = 20, int?page = 1, int?TotalRecords = 10, string sord = null, string txtSearch = null, string frmDate = null, string todate = null, string sidx = null, string statusType = null)
{
eTracLoginModel ObjLoginModel = null;
if (Session != null)
{
if (Session["eTrac"] != null)
{
ObjLoginModel = (eTracLoginModel)(Session["eTrac"]);
if (Convert.ToInt64(Session["eTrac_SelectedDasboardLocationID"]) == 0)
{
(Session["eTrac_SelectedDasboardLocationID"]) = ObjLoginModel.LocationID;
}
}
}
//Getting client date time.
var clientdt = DateTime.UtcNow.GetClientDateTimeNow();
//flag status for if user filter record in time span so to date is till midnight.
bool isUTCDay = true;
//Fetching record like 2017-06-11T00:00:00-04:00 to 2017-06-12T00:0000-04:00
string fromDate = (frmDate == null || frmDate == " " || frmDate == "") ? clientdt.Date.ToString() : frmDate;
string toDate = (todate == null || todate == " " || todate == "") ? clientdt.AddDays(1).Date.ToString() : todate;
//maintaining flag if interval date come then need to fetch record till midnight of todate day
if (todate != null && todate != "" && frmDate != null && frmDate != "")
{
DateTime tt = Convert.ToDateTime(toDate);
if (tt.ToLongTimeString() == "12:00:00 AM")
{
isUTCDay = false;
}
}
if (fromDate != null && toDate != null)
{
DateTime frmd = Convert.ToDateTime(fromDate);
DateTime tod = Convert.ToDateTime(toDate);
////if interval date come then need to fetch record till midnight of todate day
if ((frmd.Date != tod.Date) && (tod.ToLongTimeString() == "12:00:00 AM") && isUTCDay == false)
{
tod = tod.AddDays(1).Date;
toDate = tod.ToString();
}
if ((frmd.Date == tod.Date) && (tod.ToLongTimeString() == "12:00:00 AM"))
{
tod = tod.AddDays(1).Date;
toDate = tod.ToString();
}
}
//Converting datetime from userTZ to UTC
DateTime fDate = Convert.ToDateTime(fromDate).ConvertClientTZtoUTC();
DateTime tDate = Convert.ToDateTime(toDate).ConvertClientTZtoUTC();
var objeFleetFuelingModelForService = new eFleetFuelingModelForService();
JQGridResults result = new JQGridResults();
List <JQGridRow> rowss = new List <JQGridRow>();
sord = string.IsNullOrEmpty(sord) ? "desc" : sord;
sidx = string.IsNullOrEmpty(sidx) ? "FuelingDate" : sidx;
txtSearch = string.IsNullOrEmpty(txtSearch) ? "" : txtSearch; //UserType = Convert.ToInt64(Helper.UserType.ITAdministrator);
try
{
var eFleetFuelingList = _IeFleetFuelingManager.GetListeFleetFuelingForJQGridDetails(ObjLoginModel.LocationID, rows, TotalRecords, sidx, sord, txtSearch, Convert.ToInt64(statusType), fDate, tDate);
foreach (var eFleetFuel in eFleetFuelingList.rows)
{
JQGridRow row = new JQGridRow();
row.id = Cryptography.GetEncryptedData(Convert.ToString(eFleetFuel.FuelID), true);
row.cell = new string[11];
row.cell[0] = eFleetFuel.VehicleNumber;
row.cell[1] = eFleetFuel.QRCodeID;
row.cell[2] = eFleetFuel.Mileage;
//row.cell[3] = eFleetFuel.CurrentFuel;
row.cell[3] = eFleetFuel.FuelTypeName;
//row.cell[5] = eFleetFuel.ReceiptNo;
row.cell[4] = eFleetFuel.FuelingDate.ToString("MM'/'dd'/'yyyy hh:mm tt");
row.cell[5] = Convert.ToString(eFleetFuel.Gallons);
row.cell[6] = ("$" + Convert.ToString(eFleetFuel.PricePerGallon));
row.cell[7] = ("$" + Convert.ToString(eFleetFuel.Total));
row.cell[8] = eFleetFuel.GasStatioName;
//row.cell[11] = eFleetFuel.CardNo;
row.cell[9] = eFleetFuel.DriverName;
row.cell[10] = eFleetFuel.FuelReceiptImage;
rowss.Add(row);
}
result.rows = rowss.ToArray();
result.page = Convert.ToInt32(page);
result.total = (int)Math.Ceiling((decimal)Convert.ToInt32(TotalRecords.Value) / rows.Value);
result.records = Convert.ToInt32(TotalRecords.Value);
}
catch (Exception ex)
{
Exception_B.exceptionHandel_Runtime(ex, "JsonResult GetFuelingList(string _search, int? rows = 20, int? page = 1, int? TotalRecords = 10, string sord = null, string txtSearch = null, string sidx = null, string statusType = null)", "eFleetFuelingController", null);
List <JQGridRow> rowsss = new List <JQGridRow>();
result.rows = rowsss.ToArray();
result.page = 0;
result.total = 0;
result.records = 0;
return(Json(result, JsonRequestBehavior.AllowGet));
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ServiceResponseModel <string> InserteFleetFueling(eFleetFuelingModelForService objModel)
{
var objReturnModel = new ServiceResponseModel <string>();
try
{
var objFuelingRepository = new FuelingRepository();
var objDARRepository = new DARRepository();
var objDARDetail = new DARDetail();
var objDAR = new DARModel();
var Obj = new eFleetFueling();
AutoMapper.Mapper.CreateMap <eFleetFuelingModelForService, eFleetFueling>();
Obj = AutoMapper.Mapper.Map(objModel, Obj);
Obj.CreatedBy = objModel.UserId;
Obj.CreatedDate = DateTime.UtcNow;
objFuelingRepository.Add(Obj);
if (Obj.FuelID > 0)
{
objDARDetail.ActivityDetails = DarMessage.RegisterNeweFleetFueling(objModel.LocationName);
//objDAR.ActivityDetails = objModel.ActivityDetails;
objDARDetail.LocationId = objModel.LocationID;
objDARDetail.TaskType = (long)TaskTypeCategory.EfleetFuelingSubmission;
objDARDetail.CreatedBy = objModel.UserId;
objDARDetail.CreatedOn = DateTime.UtcNow;
objDARDetail.DeletedBy = null;
objDARDetail.DeletedOn = null;
objDARDetail.IsDeleted = false;
objDARDetail.IsManual = false;
objDARDetail.ModifiedBy = null;
objDARDetail.ModifiedOn = null;
objDARDetail.UserId = objModel.UserId;
objDARDetail.StartTime = objModel.FuelingDate;
objDARDetail.EndTime = DateTime.UtcNow;
objDARRepository.Add(objDARDetail);
//Result result = _ICommonMethod.SaveDAR(objDARDetail);
#region Email
var objEmailLogRepository = new EmailLogRepository();
var objEmailReturn = new List <EmailToManagerModel>();
var objListEmailog = new List <EmailLog>();
var objTemplateModel = new TemplateModel();
Result result;
workorderEMSEntities db = new workorderEMSEntities();
if (objDARDetail.DARId > 0)
{
objEmailReturn = objEmailLogRepository.SendEmailToManagerForeFleetInspection(objModel.LocationID, objModel.UserId).Result;
}
if (objEmailReturn.Count > 0 && objDARDetail.DARId > 0)
{
foreach (var item in objEmailReturn)
{
bool IsSent = false;
var objEmailHelper = new EmailHelper();
objEmailHelper.emailid = item.ManagerEmail;
objEmailHelper.ManagerName = item.ManagerName;
objEmailHelper.DriverNameforFueling = objModel.DriverName;
objEmailHelper.FuelType = (from gc in db.GlobalCodes where gc.GlobalCodeId == objModel.FuelType select gc.CodeName).FirstOrDefault();
objEmailHelper.GasStatioName = objModel.GasStatioName;
objEmailHelper.Mileage = objModel.Mileage;
objEmailHelper.CurrentFuel = objModel.CurrentFuel;
objEmailHelper.Total = objModel.Total.ToString();
objEmailHelper.VehicleNumber = objModel.VehicleNumber;
objEmailHelper.LocationName = objModel.LocationName;
objEmailHelper.UserName = item.UserName;
objEmailHelper.QrCodeId = objModel.QRCodeID;
objEmailHelper.FuelingDate = objModel.FuelingDate.ToString();
//objEmailHelper.InfractionStatus = obj.Status;
objEmailHelper.MailType = "EfleetFueling";
objEmailHelper.SentBy = item.RequestBy;
objEmailHelper.LocationID = item.LocationID;
objEmailHelper.TimeAttempted = DateTime.UtcNow.ToMobileClientTimeZone(objTemplateModel.TimeZoneName, objTemplateModel.TimeZoneOffset, objTemplateModel.IsTimeZoneinDaylight, false).ToString();
IsSent = objEmailHelper.SendEmailWithTemplate();
//Push Notification
string message = PushNotificationMessages.eFleetFuelingReported(objModel.LocationName, objModel.QRCodeID, objModel.VehicleNumber);
PushNotification.GCMAndroid(message, item.DeviceId, objEmailHelper);
if (IsSent == true)
{
var objEmailog = new EmailLog();
try
{
objEmailog.CreatedBy = item.RequestBy;
objEmailog.CreatedDate = DateTime.UtcNow;
objEmailog.DeletedBy = null;
objEmailog.DeletedOn = null;
objEmailog.LocationId = item.LocationID;
objEmailog.ModifiedBy = null;
objEmailog.ModifiedOn = null;
objEmailog.SentBy = item.RequestBy;
objEmailog.SentEmail = item.ManagerEmail;
objEmailog.Subject = objEmailHelper.Subject;
objEmailog.SentTo = item.ManagerUserId;
objListEmailog.Add(objEmailog);
}
catch (Exception)
{
throw;
}
}
}
using (var context = new workorderEMSEntities())
{
context.EmailLogs.AddRange(objListEmailog);
context.SaveChanges();
}
// //var x = EmailLogRepository.InsertEntitiesNew("EmailLog", objListEmailog);
// //Task<bool> x = null;
// //foreach (var i in objListEmailog)
// //{
// // x = objEmailLogRepository.SaveEmailLogAsync(i);
// //}
//}
#endregion Email
if (objDARDetail.DARId > 0)
{
objReturnModel.Response = Convert.ToInt32(ServiceResponse.SuccessResponse, CultureInfo.InvariantCulture);
objReturnModel.Message = CommonMessage.Successful();
}
else
{
objReturnModel.Response = Convert.ToInt32(ServiceResponse.FailedResponse, CultureInfo.CurrentCulture);
objReturnModel.Message = CommonMessage.FailureMessage();
}
}
}
}
catch (Exception ex)
{
WorkOrderEMS.BusinessLogic.Exception_B.Exception_B.exceptionHandel_Runtime(ex, "ServiceResponseModel<string> InsertPreventativeMaintenance(eFleetPreventaticeMaintenanceModel objModel)", "while insert preventative maintenance", objModel);
objReturnModel.Message = ex.Message;
objReturnModel.Response = Convert.ToInt32(ServiceResponse.ExeptionResponse, CultureInfo.CurrentCulture);
objReturnModel.Data = null;
}
return(objReturnModel);
}
