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); }