/// <summary>
/// Created By Ashwajit Bansod Dated : Sept-22-2017
/// For creating a JQGrid List of Maintenance
/// </summary>
/// <param name="objeFleetMaintenanceModelList"></param>
/// <returns></returns>
public ActionResult ListeFleetMaintenance(eFleetMaintenanceModel objeFleetMaintenanceModelList)
{
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 MaintenanceList = _IEfleetMaintenance.GetAllMaintenanceList(objeFleetMaintenanceModelList);
return(View("ListeFleetMaintenance", MaintenanceList));
}
catch (Exception ex)
{
ViewBag.Message = ex.Message;
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;
}
return(View());
}
// 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"));
}
/// <summary>
/// Created By Ashwajit Bansod Dated : Sept-22-2017
/// for fetching the Data from Database for editing
/// </summary>
/// <param name="maintenanceId"></param>
/// <returns></returns>
public eFleetMaintenanceModel GeteFleetMaintenanceDetailsById(long maintenanceId)
{
try
{
var db = new workorderEMSEntities();
var ObjeFleetMaintenanceRepository = new eFleetMaintenanceRepository();
var editeFleetMaintenanceDetails = new eFleetMaintenanceModel();
var efleetmaintenanceDetails = ObjeFleetMaintenanceRepository.GetSingleOrDefault(u => u.MaintenanceID == maintenanceId);
if (efleetmaintenanceDetails.MaintenanceID > 0)
{
AutoMapper.Mapper.CreateMap <eFleetMaintenance, eFleetMaintenanceModel>();
var objfleetVehicleMapper = AutoMapper.Mapper.Map(efleetmaintenanceDetails, editeFleetMaintenanceDetails);
//if (editeFleetPMDetails.Meter == 423)
//{
// editeFleetPMDetails.HoursValue = efleetDetails.ReminderMetric;
//}
}
return(editeFleetMaintenanceDetails);
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public eFleetMaintenanceModel GeteFleetPMDetailsById(long maintenanceId)", "Exception While Editing Maintenence.", null);
throw;
}
}
public JsonResult GetListMaintenance(string _search, long?UserId, long?locationId, int?rows = 20, int?page = 1, int?TotalRecords = 10, string sord = null, string txtSearch = null, string sidx = null, string UserType = null)
{
eTracLoginModel ObjLoginModel = null;
if (Session["eTrac"] != null)
{
ObjLoginModel = (eTracLoginModel)(Session["eTrac"]);
if (locationId == null)
{
locationId = ObjLoginModel.LocationID;
}
UserId = ObjLoginModel.UserId;
}
var objeFleetMaintenanceModel = new eFleetMaintenanceModel();
JQGridResults result = new JQGridResults();
List <JQGridRow> rowss = new List <JQGridRow>();
sord = string.IsNullOrEmpty(sord) ? "desc" : sord;
sidx = string.IsNullOrEmpty(sidx) ? "UserEmail" : sidx;
txtSearch = string.IsNullOrEmpty(txtSearch) ? "" : txtSearch; //UserType = Convert.ToInt64(Helper.UserType.ITAdministrator);
try
{
var eFleetMaintenanceList = _IEfleetMaintenance.GetListeFleetMaintenanceDetails(UserId, rows, TotalRecords, sidx, sord, locationId, txtSearch, UserType);
foreach (var efleetmaintenanceList in eFleetMaintenanceList.rows)
{
if (efleetmaintenanceList.IsDeleted == false)
{
JQGridRow row = new JQGridRow();
row.id = Cryptography.GetEncryptedData(Convert.ToString(efleetmaintenanceList.MaintenanceID), true);
row.cell = new string[10];
row.cell[0] = efleetmaintenanceList.VehicleNumber;
row.cell[1] = efleetmaintenanceList.MaintenanceTypeList;
row.cell[2] = efleetmaintenanceList.MaintenanceDate.Value.ToString("dd/MM/yyyy");
row.cell[3] = efleetmaintenanceList.ReminderMetricDesc;
row.cell[4] = efleetmaintenanceList.DaysOutOfService.ToString();
row.cell[5] = efleetmaintenanceList.DriverName;
// row.cell[6] = Convert.ToString(efleetmaintenanceList.OthersCosts == "") ? efleetmaintenanceList.OthersCosts.ToString() : "N/A";
row.cell[6] = efleetmaintenanceList.TotalCost.ToString();
row.cell[7] = efleetmaintenanceList.Miles;
row.cell[8] = efleetmaintenanceList.Note;
row.cell[9] = efleetmaintenanceList.MaintenanceAttachment;
// Vehicle Image will be use in Future if Image is Required for PM
// row.cell[5] = (vehicleList.VehicleImage == "" || vehicleList.VehicleImage == null) ? "" : HostingPrefix + ProfileImagePath.Replace("~", "") + vehicleList.VehicleImage;
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)
{ return(Json(ex.Message, JsonRequestBehavior.AllowGet)); }
//{ViewBag.Message = ex.Message;ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;}
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Created By Ashwajit Bansod : Dated Sept-22-2017
/// For Fetching all required data from database and Display in JQ Grid Listing
/// </summary>
/// <param name="UserId"></param>
/// <param name="pageIndex"></param>
/// <param name="numberOfRows"></param>
/// <param name="sortColumnName"></param>
/// <param name="sortOrderBy"></param>
/// <param name="locationId"></param>
/// <param name="textSearch"></param>
/// <param name="statusType"></param>
/// <returns></returns>
public eDetailsMaintenance GetListeFleetMaintenanceDetails(long?UserId, int?pageIndex, int?numberOfRows, string sortColumnName, string sortOrderBy, long?locationId, string textSearch, string statusType)
{
try
{
workorderEMSEntities db = new workorderEMSEntities();
var objeDetailsMaintenance = new eDetailsMaintenance();
int pageindex = Convert.ToInt32(pageIndex) - 1;
int pageSize = Convert.ToInt32(numberOfRows);
var objeFleetMaintenanceModel = new eFleetMaintenanceModel();
var Results = db.eFleetMaintenances.Where(a => a.IsDeleted == false && a.LocationID == locationId).Select(a => new eFleetMaintenanceModel()
{
PmID = a.PmID,
VehicleID = a.VehicleID,
MaintenanceID = a.MaintenanceID,
//QRCodeID = a.QRCodeID,
VehicleNumber = a.VehicleNumber,
MaintenanceTypeList = a.GlobalCode.CodeName,
DriverName = a.DriverName,
//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(),
//ScheduledPM = a.ScheduledPM,
// Category = a.GlobalCode1.GlobalCodeId, //(from gc in db.GlobalCodes where gc.GlobalCodeId == a.Category select gc.CodeName).FirstOrDefault(),
DaysOutOfService = a.DaysOutOfService,
ReminderMetricDesc = a.ReminderMetricDesc,
MaintenanceDate = a.MaintenanceDate,
TotalCost = a.TotalCost,
Miles = a.Miles,
Note = a.Note,
LabourCost = a.LabourCost,
PartsCost = a.PartsCost,
});
int totRecords = Results.Count();
var totalPages = (int)Math.Ceiling((float)totRecords / (float)numberOfRows);
Results = Results.OrderByDescending(s => s.MaintenanceID);
objeDetailsMaintenance.pageindex = pageindex;
objeDetailsMaintenance.total = totalPages;
objeDetailsMaintenance.records = totRecords;
objeDetailsMaintenance.rows = Results.ToList();
return(objeDetailsMaintenance);
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "GetListeFleetMaintenanceDetails(long? UserId, int? pageIndex, int? numberOfRows, string sortColumnName, string sortOrderBy, long? locationId, string textSearch, string statusType)", "Exception While Listing Maintenence.", null);
throw;
}
}
public ActionResult Index(eFleetMaintenanceModel objeFleetMaintenanceModel)
{
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 (objeFleetMaintenanceModel.MaintenanceID == 0)
{
objeFleetMaintenanceModel.CreatedBy = objeTracLoginModel.UserId;
objeFleetMaintenanceModel.CreatedDate = DateTime.UtcNow;
objeFleetMaintenanceModel.IsDeleted = false;
objeFleetMaintenanceModel.LocationID = objeTracLoginModel.LocationID;
if (objeFleetMaintenanceModel.AttachmentOfMaintenanceFile != null)
{
string ImageName = objeTracLoginModel.UserId + "_" + DateTime.Now.Ticks.ToString() + "_" + Convert.ToString(objeFleetMaintenanceModel.AttachmentOfMaintenanceFile.FileName.TrimWhiteSpace());
CommonHelper.StaticUploadImage(objeFleetMaintenanceModel.AttachmentOfMaintenanceFile, Server.MapPath(ConfigurationManager.AppSettings["AttachmentOfMaintenance"] + "AttachmentMaintenance/"), ImageName);
objeFleetMaintenanceModel.MaintenanceAttachment = ImageName;
}
objeFleetMaintenanceModel.LocationName = objeTracLoginModel.Location;
objeFleetMaintenanceModel.UserID = objeTracLoginModel.UserId;
var tt = _IEfleetMaintenance.SaveEfleetMaintenance(objeFleetMaintenanceModel);
if (objeFleetMaintenanceModel.Result == Result.Completed)
{
ModelState.Clear();
ViewBag.Message = CommonMessage.eFleetMaintenanceSaveSuccessMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Success;
}
}
//for updating edited data
else
{
isUpdate = true;
objeFleetMaintenanceModel.ModifiedBy = objeTracLoginModel.UserId;
objeFleetMaintenanceModel.ModifiedDate = DateTime.UtcNow;
objeFleetMaintenanceModel.LocationID = objeTracLoginModel.LocationID;
if (objeFleetMaintenanceModel.AttachmentOfMaintenanceFile != null)
{
string ImageName = objeTracLoginModel.UserId + "_" + DateTime.Now.Ticks.ToString() + "_" + Convert.ToString(objeFleetMaintenanceModel.AttachmentOfMaintenanceFile.FileName.TrimWhiteSpace());
CommonHelper.StaticUploadImage(objeFleetMaintenanceModel.AttachmentOfMaintenanceFile, Server.MapPath(ConfigurationManager.AppSettings["AttachmentOfMaintenance"] + "AttachmentMaintenance/"), ImageName);
objeFleetMaintenanceModel.MaintenanceAttachment = ImageName;
}
objeFleetMaintenanceModel.LocationName = objeTracLoginModel.Location;
objeFleetMaintenanceModel.UserID = objeTracLoginModel.UserId;
var tt = _IEfleetMaintenance.SaveEfleetMaintenance(objeFleetMaintenanceModel);
if (objeFleetMaintenanceModel.Result == Result.UpdatedSuccessfully)
{
ModelState.Clear();
ViewBag.Message = CommonMessage.eFleetMaintenanceUpdateSuccessMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Success;
}
}
}
catch (Exception ex)
{
ViewBag.Message = ex.Message; ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;
}
finally
{
ViewBag.VehicleNumber = _IEfleetMaintenance.GetVehicleNumber(objeTracLoginModel.LocationID);
ViewBag.MaintenanceType = _IEfleetMaintenance.GetAllMaintenanceType();
ViewBag.RemainderMetricDesc = _IEfleetMaintenance.GetAllPendingPMReminderDescription(objeTracLoginModel.LocationID);
}
if (isUpdate = true && objeFleetMaintenanceModel.MaintenanceID > 0)
{
ModelState.Clear();
return(View("ListeFleetMaintenance", objeFleetMaintenanceModel));
}
ModelState.Clear();
eFleetMaintenanceModel objeFleetMaintenance = new eFleetMaintenanceModel();
return(View("CreateeFleetMaintenance", objeFleetMaintenance));
}
/// <summary>
/// Created By Ashwajit Bansod Dated : Sept-22-2017
/// For Creating JQ Grid List
/// </summary>
/// <param name="objeFleetVehicleList"></param>
/// <returns></returns>
public eFleetMaintenanceModel GetAllMaintenanceList(eFleetMaintenanceModel objeFleetMaintenanceModelList)
{
return(objeFleetMaintenanceModelList);
}
/// <summary>
/// Created By Ashwajit Bansod Dated : Sept-22-2017
/// For Saving and editing Maintenance Report
/// </summary>
/// <param name="objeFleetMaintenanceModel"></param>
/// <returns></returns>
public eFleetMaintenanceModel SaveEfleetMaintenance(eFleetMaintenanceModel objeFleetMaintenanceModel)
{
try
{
LocationMaster objLocationMaster = new LocationMaster();
var objeFleetMaintenance = new eFleetMaintenance();
var objeFleetMaintenanceRepository = new eFleetMaintenanceRepository();
var objeTracLoginModel = new eTracLoginModel();
if (objeFleetMaintenanceModel.MaintenanceID == 0)
{
AutoMapper.Mapper.CreateMap <eFleetMaintenanceModel, eFleetMaintenance>();
var objfleetMaintenanceMapper = AutoMapper.Mapper.Map(objeFleetMaintenanceModel, objeFleetMaintenance);
objeFleetMaintenanceRepository.Add(objfleetMaintenanceMapper);
//objeFleetDriver.QRCCodeID = objeFleetMaintenanceModel.QRCCodeID + "EFD" + (objeFleetDriver.DriverID + 100).ToString();
objeFleetMaintenanceRepository.SaveChanges();
if (objeFleetMaintenance.MaintenanceID > 0)
{
if (objeFleetMaintenance.MaintenanceType == 445 && objeFleetMaintenanceModel.PmID != null && objeFleetMaintenanceModel.PmID > 0)
{
var objeFleetPreventativeMaintenanceRepository = new eFleetPreventativeMaintenanceRepository();
var pmData = objeFleetPreventativeMaintenanceRepository.GetAll(pm => pm.ID == objeFleetMaintenanceModel.PmID && pm.LocationID == objeFleetMaintenanceModel.LocationID && pm.IsDeleted == false).FirstOrDefault();
if (pmData != null && pmData.ID > 0)
{
pmData.IsCompleted = true;
pmData.CompletedBy = objeFleetMaintenanceModel.UserID;
pmData.CompletedOn = DateTime.UtcNow;
objeFleetPreventativeMaintenanceRepository.Update(pmData);
}
}
// objeFleetMaintenanceModel.Result = Result.Completed;
if (objeFleetMaintenanceModel.Result == Result.Completed)
{
#region Save DAR
DARModel objDAR = new DARModel();
objDAR.ActivityDetails = DarMessage.RegisterNeweFleetMaintenance(objeTracLoginModel.LocationNames);
objDAR.LocationId = objeFleetMaintenanceModel.LocationID;
objDAR.UserId = objeFleetMaintenanceModel.UserID;
objDAR.CreatedBy = objeFleetMaintenanceModel.UserID;
objDAR.CreatedOn = DateTime.UtcNow;
objDAR.TaskType = (long)TaskTypeCategory.eFleetDriverSubmission;
Result result = _ICommonMethod.SaveDAR(objDAR);
#endregion Save DAR
}
}
}
//edit Data
else
{
var MaintenanceData = objeFleetMaintenanceRepository.GetAll(v => v.IsDeleted == false && v.MaintenanceID == objeFleetMaintenanceModel.MaintenanceID && v.LocationID == objeFleetMaintenanceModel.LocationID).SingleOrDefault();
//objeFleetDriverModel.QRCCodeID = MaintenanceData.QRCCodeID;
//objeFleetDriverModel.DriverImage = MaintenanceData.DriverImage;//== null ? "" : HostingPrefix + ProfilePicPath.Replace("~", "") + DriverData.DriverImage;
AutoMapper.Mapper.CreateMap <eFleetMaintenanceModel, eFleetMaintenance>();
var objfleetDriverMapper = AutoMapper.Mapper.Map(objeFleetMaintenanceModel, MaintenanceData);
//objeFleetDriverModel.Passwordforedit = DriverData.Password;
objeFleetMaintenanceRepository.SaveChanges();
objeFleetMaintenanceModel.Result = Result.UpdatedSuccessfully;
if (objeFleetMaintenanceModel.Result == Result.UpdatedSuccessfully)
{
#region Save DAR
DARModel objDAR = new DARModel();
objDAR.ActivityDetails = DarMessage.RegisterNeweFleetMaintenance(objeFleetMaintenanceModel.LocationName);
objDAR.LocationId = objeFleetMaintenanceModel.LocationID;
objDAR.UserId = objeFleetMaintenanceModel.UserID;
objDAR.ModifiedBy = objeFleetMaintenanceModel.UserID;
objDAR.ModifiedOn = DateTime.UtcNow;
objDAR.TaskType = (long)TaskTypeCategory.UpdateeFleetMaintenance;
Result result = _ICommonMethod.SaveDAR(objDAR);
#endregion Save DAR
}
}
return(objeFleetMaintenanceModel);
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public eFleetMaintenanceModel SaveEfleetMaintenance(eFleetMaintenanceModel objeFleetMaintenanceModel)", "Exception While saving Maintenance request.", objeFleetMaintenanceModel);
throw;
}
}
