// GET: eFleetMaintenance
public ActionResult Index()
{
var objeFleetMaintenanceModel = new eFleetMaintenanceModel();
var objeFleetPMModel = new eFleetPMModel();
try
{
//Added by Ashwajit Bansod dated Sept-20-2017 creating as session for eFleet Maintenance Reporting
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;
}
}
}
ViewBag.VehicleNumber = _IEfleetMaintenance.GetVehicleNumber(ObjLoginModel.LocationID);
ViewBag.MaintenanceType = _IEfleetMaintenance.GetAllMaintenanceType();
ViewBag.RemainderMetricDesc = _IEfleetMaintenance.GetAllPendingPMReminderDescription(ObjLoginModel.LocationID);
return(View("CreateeFleetMaintenance", objeFleetMaintenanceModel));
}
catch (Exception ex)
{
ViewBag.Message = ex.Message;
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;
}
return(View("CreateeFleetMaintenance"));
}
public ActionResult Index()
{
try
{
//Added by Ashwajit Bansod on 28/08/2017 for scenario as if view Driver Registration.
eTracLoginModel ObjLoginModel = null;
var objeFleetPMModel = new eFleetPMModel();
if (Session != null)
{
if (Session["eTrac"] != null)
{
ObjLoginModel = (eTracLoginModel)(Session["eTrac"]);
if (Convert.ToInt64(Session["eTrac_SelectedDasboardLocationID"]) == 0)
{
(Session["eTrac_SelectedDasboardLocationID"]) = ObjLoginModel.LocationID;
}
}
}
ViewBag.VehicleNumber = _IEfleetPM.GetAllVehicleNumber();
ViewBag.MeterList = _IEfleetPM.GetAllMeterList();
ViewBag.MilesValue = _IEfleetPM.GetAllMilesValue();
ViewBag.Category = _IEfleetPM.GetAllCategory();
ModelState.Clear();
return(View("CreateeFleetPM", objeFleetPMModel));
}
catch (Exception ex)
{
ViewBag.Message = ex.Message;
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;
}
return(View());
}
/// <summary>
/// Created By ashwajit Bansod for edit vehicle by VehicleID
/// </summary>
/// <param name="VehicleID"></param>
/// <returns></returns>
public eFleetPMModel GeteFleetPMDetailsById(long pmId)
{
try
{
var db = new workorderEMSEntities();
var ObjeFleetPreventativeMaintenanceRepository = new eFleetPreventativeMaintenanceRepository();
var editeFleetPMDetails = new eFleetPMModel();
var meterval = Convert.ToInt64(eFleetEnum.Hours);
var objeFleetPreventativeMaintenance = new eFleetPreventativeMaintenance();
var efleetDetails = ObjeFleetPreventativeMaintenanceRepository.GetSingleOrDefault(u => u.ID == pmId);
if (efleetDetails.ID > 0) // PmID in Ashwajit created Table
{
AutoMapper.Mapper.CreateMap <eFleetPreventativeMaintenance, eFleetPMModel>();
editeFleetPMDetails.PmID = efleetDetails.ID;
var objfleetVehicleMapper = AutoMapper.Mapper.Map(efleetDetails, editeFleetPMDetails);
if (editeFleetPMDetails.Meter == meterval)
{
editeFleetPMDetails.HoursValue = efleetDetails.ReminderMetric;
}
}
return(editeFleetPMDetails);
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public eFleetPMModel GeteFleetPMDetailsById(long pmId)", "Exception While Editing Preventative Maintenence.", null);
throw;
}
}
/// <summary>
/// Created By Ashwajit Bansod 08/31/2017
/// For creating JQGrid List
/// </summary>
/// <param name="objeFleetDriverList"></param>
/// <returns></returns>
public ActionResult ListeFleetPM(eFleetPMModel objeFleetPMModelList)
{
try
{
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;
}
}
}
var eFleetPMList = _IEfleetPM.GetAlleFleetPMList(objeFleetPMModelList);
return(View("eFleetPMList", eFleetPMList));
}
catch (Exception ex)
{
ViewBag.Message = ex.Message;
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;
}
return(View());
}
/// <summary>
/// Get all Vehicle Data from Database in a List Form
/// created By Ashwajit Bansod
/// Date : 08/12/2017
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public eDetailsPM GetListeFleetPMDetails(long?UserId, int?pageIndex, int?numberOfRows, string sortColumnName, string sortOrderBy, long?locationId, string textSearch, string statusType)
{
try
{
workorderEMSEntities db = new workorderEMSEntities();
var objeDetailsPM = new eDetailsPM();
var objeFleetMeter = new eFleetMeter();
int pageindex = Convert.ToInt32(pageIndex) - 1;
int pageSize = Convert.ToInt32(numberOfRows);
eFleetPMModel objeFleetPMModel = new eFleetPMModel();
var Results = db.eFleetPreventativeMaintenances.Where(a => a.IsDeleted == false).Select(a => new eFleetPMModel()
{
PmID = a.ID,//PmID in Ashwajit Tale of PM
VehicleID = a.VehicleID,
QRCodeID = a.QRCodeID,
VehicleNumber = a.VehicleNumber,
ListMeter = a.GlobalCode.CodeName,
HoursValue = a.ReminderMetric,
ListReminderMetric = (from em in db.eFleetMeters where em.ID == a.ReminderMetric select em.MeterValue).FirstOrDefault(),//db.eFleetMeters.Where(rm => rm.ID == a.ReminderMetric).FirstOrDefault().MeterValue, // (from rm in db.eFleetMeters where rm.ID == a.ReminderMetric select rm.MeterValue).FirstOrDefault(),
PMCategoryList = a.GlobalCode1.CodeName,
// Category = a.GlobalCode1.GlobalCodeId, //(from gc in db.GlobalCodes where gc.GlobalCodeId == a.Category select gc.CodeName).FirstOrDefault(),
OtherMilesComment = a.OtherMilesComment,
ReminderMetricDesc = a.ReminderMetricDesc,
ServiceDueDate = a.ServiceDueDate
});
int totRecords = Results.Count();
var totalPages = (int)Math.Ceiling((float)totRecords / (float)numberOfRows);
Results = Results.OrderByDescending(s => s.PmID);
objeDetailsPM.pageindex = pageindex;
objeDetailsPM.total = totalPages;
objeDetailsPM.records = totRecords;
objeDetailsPM.rows = Results.ToList();
return(objeDetailsPM);
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "GetListeFleetPMDetails(long? UserId, int? pageIndex, int? numberOfRows, string sortColumnName, string sortOrderBy, long? locationId, string textSearch, string statusType)", "Exception While Listing Preventative Maintenence.", null);
throw;
}
}
/// <summary>
/// Created By Ashwajit Bansod Dated:08/31/2017
/// eFleet Preventative Maintanance List Display in a Grid form
/// </summary>
/// <param name="objeFleetPMModelList"></param>
/// <returns></returns>
public eFleetPMModel GetAlleFleetPMList(eFleetPMModel objeFleetPMModelList)
{
return(objeFleetPMModelList);
}
/// <summary>
/// Created By Ashwajit Bansod Dated 08/29/2017
/// Save and edit Preventative maintenance Data
/// </summary>
/// <param name="objeFleetPMModel"></param>
/// <returns></returns>
public eFleetPMModel SaveEfleetPreventativeMaintenance(eFleetPMModel objeFleetPMModel)
{
try
{
workorderEMSEntities db = new workorderEMSEntities();
var objLocationMaster = new LocationMaster();
var objeFleetPreventativeMaintenance = new eFleetPreventativeMaintenance();
var objeFleetVehicleModel = new eFleetVehicleModel();
var meterval = Convert.ToInt64(eFleetEnum.Hours);
var objeFleetPreventativeMaintenanceRepository = new eFleetPreventativeMaintenanceRepository();
var objeTracLoginModel = new eTracLoginModel();
if (objeFleetPMModel.ID == 0)
{
AutoMapper.Mapper.CreateMap <eFleetPMModel, eFleetPreventativeMaintenance>();
if (objeFleetPMModel.Meter == meterval)
{
objeFleetPMModel.ReminderMetric = objeFleetPMModel.HoursValue;
}
var objfleetPMMapper = AutoMapper.Mapper.Map(objeFleetPMModel, objeFleetPreventativeMaintenance);
objeFleetPreventativeMaintenanceRepository.Add(objfleetPMMapper);
objeFleetPreventativeMaintenanceRepository.SaveChanges();
objeFleetPMModel.Result = Result.Completed;
if (objeFleetPMModel.Result == Result.Completed)
{
#region Save DAR
DARModel objDAR = new DARModel();
objDAR.ActivityDetails = DarMessage.NeweFleetPMCreated(objeFleetPMModel.LocationName);
objDAR.LocationId = objeFleetPMModel.LocationID;
objDAR.UserId = objeFleetPMModel.UserId;
objDAR.CreatedBy = objeFleetPMModel.UserId;
objDAR.CreatedOn = DateTime.UtcNow;
objDAR.TaskType = (long)TaskTypeCategory.PreventativeMaintenanceSubmission;
Result result = _ICommonMethod.SaveDAR(objDAR);
#endregion Save DAR
//Created By Ashwajit Bansod Date: Oct-04-2017 for sending a mail regarding Prevenatative maintenance to the manager
#region Email
var objEmailLogRepository = new EmailLogRepository();
var objEmailReturn = new List <EmailToManagerModel>();
var objListEmailog = new List <EmailLog>();
var objTemplateModel = new TemplateModel();
if (result == Result.Completed)
{
objEmailReturn = objEmailLogRepository.SendEmailToManagerForeFleetInspection(objeFleetPMModel.LocationID, objeFleetPMModel.UserId).Result;
}
if (objEmailReturn.Count > 0 && result == Result.Completed)
{
foreach (var item in objEmailReturn)
{
bool IsSent = false;
var objEmailHelper = new EmailHelper();
objEmailHelper.emailid = item.ManagerEmail;
objEmailHelper.ManagerName = item.ManagerName;
if (objeFleetPMModel.ReminderMetric == null)
{
objEmailHelper.RemiderMetric = "N/A";
}
else
{
objEmailHelper.RemiderMetric = (from em in db.eFleetMeters where em.ID == objeFleetPMModel.ReminderMetric select em.MeterValue).FirstOrDefault();
}
objEmailHelper.Meter = (from gc in db.GlobalCodes where gc.GlobalCodeId == objeFleetPMModel.Meter select gc.CodeName).FirstOrDefault();
objEmailHelper.Category = (from gc in db.GlobalCodes where gc.GlobalCodeId == objeFleetPMModel.Category select gc.CodeName).FirstOrDefault();;
objEmailHelper.VehicleNumber = objeFleetPMModel.VehicleNumber;
objEmailHelper.LocationName = objeFleetPMModel.LocationName;
objEmailHelper.UserName = item.UserName;
objEmailHelper.QrCodeId = objeFleetPMModel.QRCodeID;
objEmailHelper.ServiceDueDate = objeFleetPMModel.ServiceDueDate.ToString();
objEmailHelper.PMMetric = objeFleetPMModel.ReminderMetricDesc;
//objEmailHelper.InfractionStatus = obj.Status;
objEmailHelper.MailType = "PreventativeMaintenance";
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.eFleetPreventativeMaintenanceReported(objeFleetPMModel.LocationName, objeFleetPMModel.QRCodeID, objeFleetPMModel.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
}
}
}
//edit Data
else
{
var PreventativeData = objeFleetPreventativeMaintenanceRepository.GetAll(v => v.IsDeleted == false && v.ID == objeFleetPMModel.PmID).SingleOrDefault(); //PmID = ID PmID in Ashwajit Table
//objeFleetPMModel.DriverImage = DriverData.DriverImage;//== null ? "" : HostingPrefix + ProfilePicPath.Replace("~", "") + DriverData.DriverImage;
AutoMapper.Mapper.CreateMap <eFleetPMModel, eFleetPreventativeMaintenance>();
if (objeFleetPMModel.Meter == meterval)
{
objeFleetPMModel.ReminderMetric = objeFleetPMModel.HoursValue;
}
var objfleetDriverMapper = AutoMapper.Mapper.Map(objeFleetPMModel, PreventativeData);
objeFleetPreventativeMaintenanceRepository.SaveChanges();
objeFleetPMModel.Result = Result.UpdatedSuccessfully;
if (objeFleetPMModel.Result == Result.UpdatedSuccessfully)
{
#region Save DAR
DARModel objDAR = new DARModel();
objDAR.ActivityDetails = DarMessage.NeweFleetPMUpdated(objeFleetPMModel.LocationName);
objDAR.LocationId = objeFleetPMModel.LocationID;
objDAR.UserId = objeFleetPMModel.UserId;
objDAR.ModifiedBy = objeFleetPMModel.UserId;
objDAR.ModifiedOn = DateTime.UtcNow;
objDAR.TaskType = (long)TaskTypeCategory.UpdatePreventativeMaintenance;
Result result = _ICommonMethod.SaveDAR(objDAR);
#endregion Save DAR
}
}
return(objeFleetPMModel);
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public eFleetPMModel SaveEfleetPreventativeMaintenance(eFleetPMModel objeFleetPMModel)", "Exception While saving Preventative Maintenence request.", objeFleetPMModel);
throw;
}
}
public ActionResult Index(eFleetPMModel objeFleetPMModel)
{
var objeTracLoginModel = new eTracLoginModel();
bool isUpdate = false;
if (Session != null)
{
if (Session["eTrac"] != null)
{
objeTracLoginModel = (eTracLoginModel)(Session["eTrac"]);
if (Convert.ToInt64(Session["eTrac_SelectedDasboardLocationID"]) == 0)
{
(Session["eTrac_SelectedDasboardLocationID"]) = objeTracLoginModel.LocationID;
}
}
}
try
{
if (objeFleetPMModel.PmID == 0)
{
objeFleetPMModel.CreatedBy = objeTracLoginModel.UserId;
objeFleetPMModel.CreatedDate = DateTime.UtcNow;
objeFleetPMModel.IsDeleted = false;
objeFleetPMModel.QRCID = objeTracLoginModel.LocationCode;
objeFleetPMModel.LocationID = objeTracLoginModel.LocationID;
//if (objeFleetPMModel.DriverImageFile != null) // will use in Future of Vehicle Image is Required..
//{
// string ImageName = objeTracLoginModel.UserId + "_" + DateTime.Now.Ticks.ToString() + "_" + objeFleetDriverModel.DriverImageFile.FileName.ToString();
// CommonHelper obj_CommonHelper = new CommonHelper();
// obj_CommonHelper.UploadImage(objeFleetDriverModel.DriverImageFile, Server.MapPath(ConfigurationManager.AppSettings["DriverImage"]), ImageName);
// objeFleetDriverModel.DriverImage = ImageName;
//}
objeFleetPMModel.LocationName = objeTracLoginModel.Location;
objeFleetPMModel.UserId = objeTracLoginModel.UserId;
var tt = _IEfleetPM.SaveEfleetPreventativeMaintenance(objeFleetPMModel);
if (objeFleetPMModel.Result == Result.Completed)
{
ModelState.Clear();
ViewBag.Message = CommonMessage.eFleetPrevantativeMaintenanceSaveSuccessMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Success;
}
}
//for updating edited data
else
{
isUpdate = true;
objeFleetPMModel.ModifiedBy = objeTracLoginModel.UserId;
objeFleetPMModel.ModifiedDate = DateTime.UtcNow;
objeFleetPMModel.LocationID = objeTracLoginModel.LocationID;
objeFleetPMModel.ID = objeFleetPMModel.PmID;
objeFleetPMModel.LocationName = objeTracLoginModel.Location;
var tt = _IEfleetPM.SaveEfleetPreventativeMaintenance(objeFleetPMModel);
if (objeFleetPMModel.Result == Result.UpdatedSuccessfully)
{
ModelState.Clear();
ViewBag.Message = CommonMessage.eFleetPrevantativeMaintenanceUpdateSuccessMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Success;
}
}
}
catch (Exception ex)
{
ViewBag.Message = ex.Message; ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;
}
finally
{
ViewBag.VehicleNumber = _IEfleetPM.GetAllVehicleNumber();
ViewBag.MeterList = _IEfleetPM.GetAllMeterList();
ViewBag.MilesValue = _IEfleetPM.GetAllMilesValue();
ViewBag.Category = _IEfleetPM.GetAllCategory();
}
if (isUpdate = true && objeFleetPMModel.PmID > 0)
{
ModelState.Clear();
return(View("eFleetPMList", objeFleetPMModel));
}
// if (ModelState.IsValid)
ModelState.Clear();
eFleetPMModel PMModel = new eFleetPMModel();
return(View("CreateeFleetPM", PMModel));
}
