/// <summary>
/// To Verify the User
/// </summary>
/// <CreatedBy>Bhushan Dod</CreatedBy>
/// <CreatedDate>2016-10-08</CreatedDate>
/// <param name="UserId"></param>
/// <param name="DeletedBy"></param>
public Result UpdateVerifyUser(long UserId, long ModifiedBy, DARModel objDAR)
{
Result result;
try
{
ObjUserRepository = new UserRepository();
objCommonMethodManager = new CommonMethodManager();
UserRegistration obj_UserRegistration = ObjUserRepository.GetAll(x => x.UserId == UserId).FirstOrDefault();
if (obj_UserRegistration != null)
{
obj_UserRegistration.IsLoginActive = true;
obj_UserRegistration.IsEmailVerify = true;
obj_UserRegistration.ModifiedDate = DateTime.UtcNow;
obj_UserRegistration.ModifiedBy = ModifiedBy;
ObjUserRepository.SaveChanges();
objDAR.TaskType = (long)TaskTypeCategory.UserUpdate;
objDAR.ActivityDetails = DarMessage.UserVerifiedDar(obj_UserRegistration.FirstName + ' ' + obj_UserRegistration.LastName);
#region Save DAR
result = objCommonMethodManager.SaveDAR(objDAR);
#endregion Save DAR
return(Result.UpdatedSuccessfully);
}
else
{
return(Result.DoesNotExist);
}
}
catch (Exception ex)
{
throw ex;
}
}
////public JsonResult GetListDAR(long UserId, DateTime fromDate, DateTime toDate, long taskType, int? NumberOfRows = 20, int? PageIndex = 1, int? TotalRecords = 10, string SortOrderBy = null, string SearchText = null, string SortColumnName = null, long? UserType = null)
//[HttpGet]
//public JsonResult GetListDAR(long UserId, DateTime? fromDate, DateTime? toDate, long? taskType, int? NumberOfRows = 20, int? PageIndex = 1, int? TotalRecords = 10, string SortOrderBy = null, string SearchText = null, string SortColumnName = null, long? UserType = null)
//{
// JQGridResults result = new JQGridResults();
// //List<JQGridRow> rows = new List<JQGridRow>();
// //SortOrderBy = string.IsNullOrEmpty(SortOrderBy) ? "asc" : SortOrderBy;
// //SortColumnName = string.IsNullOrEmpty(SortColumnName) ? "UserEmail" : SortColumnName;
// //SearchText = string.IsNullOrEmpty(SearchText) ? "" : SearchText; //UserType = Convert.ToInt64(Helper.UserType.ITAdministrator);
// //long TotalRows = 0;
// //if (!fromDate.HasValue) { fromDate = DateTime.Now; }
// //if (!toDate.HasValue) { toDate = DateTime.Now; }
// //if (!taskType.HasValue) { taskType = 1; }
// //try
// //{
// // List<DARModel> listDAR = _IDARManager.GetDARDetails(UserId, fromDate.Value, toDate.Value, taskType.Value, UserType, PageIndex, NumberOfRows, SortColumnName, SortOrderBy, SearchText, out TotalRows);
// // foreach (var itemDAR in listDAR)
// // {
// // JQGridRow row = new JQGridRow();
// // row.id = itemDAR.DARId;
// // row.cell = new string[1];
// // row.cell[0] = itemDAR.ActivityDetails;
// // //row.cell[1] = Convert.ToString(itemDAR.CreatedOn);
// // rows.Add(row);
// // }
// // result.rows = rows.ToArray();
// // result.page = (PageIndex.HasValue) ? PageIndex.Value : 1;
// // result.total = Convert.ToInt32(TotalRows / (NumberOfRows.HasValue ? NumberOfRows.Value : 20));
// // result.records = Convert.ToInt32(TotalRows);
// //}
// //catch (Exception ex)
// //{ return Json(ex.Message, JsonRequestBehavior.AllowGet); }
// ////{ViewBag.Message = ex.Message;ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;}
// return Json(result, JsonRequestBehavior.AllowGet);
//}
public ActionResult EditDARDetail(string id)
{
long darId;
eTracLoginModel ObjLoginModel = null;
DARModel objDARModel = new DARModel();
try
{
if (!string.IsNullOrEmpty(id))
{
id = Cryptography.GetDecryptedData(id, true);
}
darId = Convert.ToInt64(id);
if (Session["eTrac"] != null)
{
ObjLoginModel = (eTracLoginModel)(Session["eTrac"]);
objDARModel = _IDARManager.GetDARById(darId);
}
return(PartialView("_EditDARDetails", objDARModel));
}
catch (Exception ex)
{
{ ViewBag.Message = ex.Message; ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger; return(View("Error")); }
}
}
public Result UpdateDAR(DARModel objDARModel)
{
DARDetail objDARDetail;
try
{
objDARRepository = new DARRepository();
objDARDetail = new DARDetail();
if (objDARModel.DARId > 0)
{
objDARDetail = objDARRepository.GetAll(x => x.IsDeleted == false &&
x.DARId == objDARModel.DARId).FirstOrDefault();
if (objDARDetail != null)
{
objDARDetail.ActivityDetails = objDARModel.ActivityDetails;
objDARRepository.Update(objDARDetail);
return(Result.Completed);
}
else
{
return(Result.Failed);
}
}
return(Result.Failed);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Created By Ashwajit Bansod Dated : Sept-22-2017
/// </summary>
/// <param name="VehicleId"></param>
/// <param name="loggedInUserId"></param>
/// <returns></returns>
public Result DeleteeFleetMaintenance(long maintenanceId, long loggedInUserId, string location)
{
var objDAR = new DARModel();
try
{
Result result;
if (maintenanceId > 0)
{
if (true)
{
var objeFleetMaintenanceRepository = new eFleetMaintenanceRepository();
var data = objeFleetMaintenanceRepository.GetSingleOrDefault(v => v.MaintenanceID == maintenanceId && v.IsDeleted == false);
if (data != null)
{
data.IsDeleted = true;
data.DeletedBy = loggedInUserId;
data.DeletedDate = DateTime.UtcNow;
objeFleetMaintenanceRepository.Update(data);
objeFleetMaintenanceRepository.SaveChanges();
objDAR.ActivityDetails = DarMessage.DeleteFleetMaintenance(location);
objDAR.TaskType = (long)TaskTypeCategory.DeleteeFleetMaintenance;
#region Save DAR
objDAR.LocationId = data.LocationID;
objDAR.UserId = loggedInUserId;
objDAR.DeletedBy = data.DeletedBy;
objDAR.DeletedOn = DateTime.UtcNow;
result = _ICommonMethod.SaveDAR(objDAR);
#endregion Save DAR
return(Result.Delete);
}
}
else
{
return(Result.Failed);
}
}
else
{
return(Result.DoesNotExist);
}
return(Result.Delete);
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public Result DeleteeFleetMaintenance(long maintenanceId, long loggedInUserId)", "Exception While Deleting Preventative Maintenence.", null);
throw;
}
}
public JsonResult DeleteEmail(string logId)
{
try
{
eTracLoginModel ObjLoginModel = null; long LoggedInUser = 0, emailLogId = 0;
string Id;
DARModel objDAR;
if (Session["eTrac"] != null)
{
ObjLoginModel = (eTracLoginModel)(Session["eTrac"]);
LoggedInUser = (ObjLoginModel != null && ObjLoginModel.UserId > 0) ? (ObjLoginModel.UserId) : 0;
if (!string.IsNullOrEmpty(logId))
{
Id = Cryptography.GetDecryptedData(logId, true);
emailLogId = Convert.ToInt32(Id);
objDAR = new DARModel();
objDAR.LocationId = ObjLoginModel.LocationID;
objDAR.UserId = ObjLoginModel.UserId;
objDAR.CreatedBy = ObjLoginModel.UserId;
objDAR.CreatedOn = DateTime.UtcNow;
objDAR.TaskType = (long)TaskTypeCategory.DeleteEmail;
Result result = _IEmailDetail.DeleteEmail(emailLogId, LoggedInUser);
if (result == Result.Delete)
{
ViewBag.Message = CommonMessage.DeleteSuccessMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Success;
}
else if (result == Result.Failed)
{
ViewBag.Message = "Can't Delete Email";
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;
}
else
{
ViewBag.Message = CommonMessage.FailureMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;// store the failure message in tempdata to display in view.
}
}
}
}
catch (Exception ex)
{ throw ex; }
return(Json(new { Message = ViewBag.Message, AlertMessageClass = ViewBag.AlertMessageClass }, JsonRequestBehavior.AllowGet));
}
public JsonResult DamageFixedWeb(string qr)
{
DARModel objDAR;
try
{
eTracLoginModel ObjLoginModel = null; long LoggedInUser = 0, QRCID = 0;
if (Session["eTrac"] != null)
{
ObjLoginModel = (eTracLoginModel)(Session["eTrac"]);
}
LoggedInUser = (ObjLoginModel != null && ObjLoginModel.UserId > 0) ? (ObjLoginModel.UserId) : 0;
if (!string.IsNullOrEmpty(qr))
{
qr = Cryptography.GetDecryptedData(qr, true);
}
QRCID = Convert.ToInt64(qr);
objDAR = new DARModel();
objDAR.LocationId = ObjLoginModel.LocationID;
objDAR.UserId = ObjLoginModel.UserId;
objDAR.CreatedBy = ObjLoginModel.UserId;
objDAR.CreatedOn = DateTime.UtcNow;
objDAR.TaskType = (long)TaskTypeCategory.QRCDelete;
Result result = _IQRCSetup.DamageFixed(QRCID, LoggedInUser, objDAR, ObjLoginModel.Location);
if (result == Result.Completed)
{
ViewBag.Message = CommonMessage.UpdateSuccessMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Success;
}
else if (result == Result.Failed)
{
ViewBag.Message = "Something went wrong.";
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;
}
else
{
ViewBag.Message = CommonMessage.FailureMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;// store the failure message in tempdata to display in view.
}
}
catch (Exception ex)
{ throw ex; }
return(Json(new { Message = ViewBag.Message, AlertMessageClass = ViewBag.AlertMessageClass }, JsonRequestBehavior.AllowGet));
}
public bool SaveCostCodeIds(List <long> CostCodeIds, long LocationId, long UserId)
{
bool IsSaved = false;
string action = "I";
string result = "";
var objDAR = new DARModel();
var CommonManager = new CommonMethodManager();
List <string> CostCodedata = new List <string>();
try
{
if (CostCodeIds.Count > 0)
{
foreach (var item in CostCodeIds)
{
var ChildCostCode = _workorderems.CostCodes.Where(x => x.CCD_CostCode == item).FirstOrDefault();
if (ChildCostCode == null)
{
}
else
{
var saveCostCodeId = _workorderems.spSetCostCodeLocationMapping(action, LocationId, ChildCostCode.CCD_CCM_CostCode, item);
IsSaved = true;
CostCodedata.Add(ChildCostCode.CCD_Description);
}
}
}
var locationName = _workorderems.LocationMasters.Where(x => x.LocationId == LocationId && x.IsDeleted == false).FirstOrDefault();
result = string.Join(",", CostCodedata.ToArray());
#region Save DAR
objDAR.ActivityDetails = DarMessage.AllocateCostCodeForLocation(locationName.LocationName, result);
objDAR.TaskType = (long)TaskTypeCategory.AllocateCostcode;
objDAR.UserId = UserId;
objDAR.CreatedBy = UserId;
objDAR.LocationId = LocationId;
objDAR.DeletedOn = DateTime.UtcNow;
CommonManager.SaveDAR(objDAR);
#endregion DAR
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public bool SaveCostCodeIds(List<long> CostCodeIds, long LocationId)", "Exception While Saving Cost Code to database", LocationId);
throw;
}
return(IsSaved);
}
/// <summary>
/// Created By Ashwajit Bansod
/// for Deleting the Driver and set IsDeleted Field to 1
/// </summary>
/// <param name="driverId"></param>
/// <param name="loggedInUserId"></param>
/// <returns></returns>
public Result DeleteeFleetDriver(long driverId, long loggedInUserId, string location)
{
var objDAR = new DARModel();
try
{
Result result;
if (driverId > 0)
{
eFleetDriverRepository objeFleetDriverRepository = new eFleetDriverRepository();
var data = objeFleetDriverRepository.GetSingleOrDefault(v => v.DriverID == driverId && v.IsDeleted == false);
if (data != null)
{
data.IsDeleted = true;
data.DeletedBy = Convert.ToInt32(loggedInUserId);
data.DeletedDate = DateTime.UtcNow;
objeFleetDriverRepository.Update(data);
objeFleetDriverRepository.SaveChanges();
//var objDAR = new DARModel();
objDAR.ActivityDetails = DarMessage.DeleteFleetDriver(location);
objDAR.TaskType = (long)TaskTypeCategory.DeleteeFleetDriver;
#region Save DAR
objDAR.LocationId = data.LocationID.Value;
objDAR.UserId = loggedInUserId;
objDAR.DeletedBy = data.DeletedBy;
objDAR.DeletedOn = DateTime.UtcNow;
result = _ICommonMethod.SaveDAR(objDAR);
#endregion Save DAR
return(Result.Delete);
}
}
else
{
return(Result.DoesNotExist);
}
return(Result.Delete);
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, " public Result DeleteeFleetDriver(long driverId, long loggedInUserId)", "Exception While Deleting Driver.", null);
throw;
}
}
/// <summary>
/// Created By Ashwajit Bansod
/// Dated : Oct/13/2017
/// For deleting the Passenger Tracking Route
/// </summary>
/// <param name="passengerId"></param>
/// <param name="loggedInUserId"></param>
/// <param name="location"></param>
/// <returns></returns>
public Result DeleteeFleetPassengerTracking(long passengerId, long loggedInUserId, string location)
{
var objDAR = new DARModel();
try
{
if (passengerId > 0)
{
var objeFleetPassengerTrackingRepository = new eFleetPassengerTrackingRepository();
var data = objeFleetPassengerTrackingRepository.GetSingleOrDefault(v => v.RouteID == passengerId && v.IsDeleted == false); // PmID in Ashwajit Created Table
if (data != null)
{
data.IsDeleted = true;
data.DeletedBy = loggedInUserId;
data.DeletedDate = DateTime.UtcNow;
objeFleetPassengerTrackingRepository.Update(data);
objeFleetPassengerTrackingRepository.SaveChanges();
//objDAR.ActivityDetails = DarMessage.DeleteFleetPM(location);
//objDAR.TaskType = (long)TaskTypeCategory.DeletePreventativeMaintenance;
//#region Save DAR
//objDAR.LocationId = data.LocationID;
//objDAR.UserId = loggedInUserId;
//objDAR.DeletedBy = data.DeletedBy;
//objDAR.DeletedOn = DateTime.UtcNow;
//result = _ICommonMethod.SaveDAR(objDAR);
//#endregion Save DAR
return(Result.Delete);
}
}
else
{
return(Result.DoesNotExist);
}
return(Result.Delete);
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public Result DeleteeFleetPassengerTracking(long passengerId, long loggedInUserId, string location)", "Exception While Deleting eFleet Passenger Tracking.", null);
throw;
}
}
public ActionResult UpdateDARDetails(DARModel objDARModel)
{
eTracLoginModel ObjLoginModel = null;
try
{
if (Session["eTrac"] != null)
{
ObjLoginModel = (eTracLoginModel)(Session["eTrac"]);
if (objDARModel.DARId > 0)
{
objDARModel.ModifiedBy = ObjLoginModel.UserId;
objDARModel.ModifiedOn = DateTime.UtcNow;
_IDARManager.UpdateDAR(objDARModel);
}
}
return(RedirectToAction("ListDAR"));
}
catch (Exception ex)
{ ViewBag.Message = ex.Message; ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger; return(View("Error")); }
}
public DARModel GetDARById(long?darId)
{
DARDetail objDARModel = new DARDetail();
DARModel objDARModelList = new DARModel();
objDARRepository = new DARRepository();
try
{
objDARModel = objDARRepository.GetSingleOrDefault(x => x.DARId == darId && x.IsDeleted == false);
if (objDARModel != null)
{
objDARModelList.DARId = objDARModel.DARId;
objDARModelList.ActivityDetails = objDARModel.ActivityDetails;
objDARModelList.CreatedOn = objDARModel.CreatedOn.ToClientTimeZoneinDateTime();
}
return(objDARModelList);
}
catch (Exception)
{
throw;
}
}
public ActionResult Index(QRCModel ObjQRCModel)
{
DARModel objDAR;
long Totalrecords = 0;
eTracLoginModel ObjLoginModel = new eTracLoginModel();
LocationMasterModel objLocationMasterModel = null;
try
{
//if (ModelState.IsValid)
if (true)
{
#region login model
////
if (Session["eTrac"] != null)
{
ObjLoginModel = (eTracLoginModel)(Session["eTrac"]);
// ObjQRCModel.UserModel.ProjectID = (ObjLoginModel != null && ObjLoginModel.LocationID > 0) ? (ObjLoginModel.LocationID) : 0;
}
else
{
return(RedirectToAction("Index", "Login"));
}
///
#endregion login model
long _qRCId = 0;
Result _fnResult, result;
PrintQRCModel ObjPrintQRCModel;
CommonHelper ObjCommonHelper = new CommonHelper();
string QRCImageName = string.Empty;
//string msg;
if (Session["ImageName"] != null)
{
ObjQRCModel.UserModel.myProfileImage = Convert.ToString(Session["ImageName"]);
}
if (ObjQRCModel.WarrantyDocument != null)
{
ObjQRCModel.WarrantyDoc = DateTime.Now.Ticks + "_" + ObjQRCModel.WarrantyDocument.FileName.Replace(" ", "");
}
if (ObjQRCModel.LOCPicture != null)
{
ObjQRCModel.LocationPicture = DateTime.Now.Ticks + "_" + ObjQRCModel.LOCPicture.FileName.Replace(" ", "");
}
if (ObjQRCModel.AssetPictureUrl != null)
{
ObjQRCModel.AssetPicture = DateTime.Now.Ticks + "_" + ObjQRCModel.AssetPictureUrl.FileName.Replace(" ", "");
}
ObjQRCModel.CreatedBy = ObjLoginModel.UserId;
ObjQRCModel.LocationId = ObjLoginModel.LocationID;
objDAR = new DARModel();
objDAR.LocationId = ObjLoginModel.LocationID;
objDAR.UserId = ObjLoginModel.UserId;
objDAR.CreatedBy = ObjLoginModel.UserId;
objDAR.CreatedOn = DateTime.UtcNow;
//Added by Bhushan on 26/Oct/2016 for client has changed request for If QRC is vehicle then directly set vehicle type is Motor Vehicle and for Shuttle Bus set vehicle type is Shuttle Bus
if (ObjQRCModel.QRCTYPE == Convert.ToInt64(QrcType.Vehicle))
{
ObjQRCModel.VehicleType = Convert.ToInt64(VEHICLETYPE.MotorVehicle);
}
if (ObjQRCModel.QRCTYPE == Convert.ToInt64(QrcType.ShuttleBus))
{
ObjQRCModel.VehicleType = Convert.ToInt64(VEHICLETYPE.ShuttleBus);
}
if (_IQRCSetup.ProcessQRCSetup(ObjQRCModel, out _qRCId, out _fnResult, out ObjPrintQRCModel))
{
path = Server.MapPath(path);
if (ObjQRCModel.WarrantyDocument != null)
{
ObjCommonHelper.UploadImage(ObjQRCModel.WarrantyDocument, path, ObjQRCModel.WarrantyDoc);
}
if (ObjQRCModel.LOCPicture != null)
{
ObjCommonHelper.UploadImage(ObjQRCModel.LOCPicture, path, ObjQRCModel.LocationPicture);
}
if (ObjQRCModel.AssetPictureUrl != null)
{
ObjCommonHelper.UploadImage(ObjQRCModel.AssetPictureUrl, path, ObjQRCModel.AssetPicture);
}
if (_fnResult == Result.Completed)
{
// Code for to get path of root directory and attach path of directory to store image
string RootDirectory = ConfigurationManager.AppSettings["QRCImage"];
RootDirectory = Server.MapPath(RootDirectory);
if (ObjQRCModel.QRCImageBase64 != null)
{
ObjQRCModel.QRCImageBase64 = ObjQRCModel.QRCImageBase64.Split(',')[1];
ObjCommonHelper.UploadQRCImage(ObjQRCModel.QRCImageBase64, RootDirectory, ObjQRCModel.QRCImage);
}
objDAR.ActivityDetails = DarMessage.SaveQRC(ObjPrintQRCModel.QRCName, ObjLoginModel.Location);
objDAR.TaskType = (long)TaskTypeCategory.QRCCreation;
ViewBag.Message = CommonMessage.SaveSuccessMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Success;
ModelState.Clear();
ObjQRCModel = QRCInIt();
}
else if (_fnResult == Result.UpdatedSuccessfully)
{
objDAR.ActivityDetails = DarMessage.UpdateQRC(ObjPrintQRCModel.QRCName, ObjLoginModel.Location);
objDAR.TaskType = (long)TaskTypeCategory.QRCUpdate;
ViewBag.Message = CommonMessage.UpdateSuccessMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Success;
ModelState.Clear();
ObjQRCModel = QRCInIt();
}
else if (_fnResult == Result.Failed)
{
ViewBag.Message = CommonMessage.FailureMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;
// store the failure message in tempdata to display in view.
}
#region Save DAR
result = _ICommonMethod.SaveDAR(objDAR);
#endregion Save DAR
}
else
{
ViewBag.Message = CommonMessage.DuplicateRecordMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Info;
// store the failure message in tempdata to display in view.
}
//ViewBag.EncryptQRC = Cryptography.GetEncryptedData(QRCDetail.QRCId.ToString(), true);
//ViewBag.EncryptQRC = Cryptography.GetEncryptedData(_qRCId.ToString(), true);
ViewBag.QRCName = ObjQRCModel.QRCName;
ViewBag.SpecialNote = ObjQRCModel.SpecialNotes;
//ViewBag.QRCSize = QRCDetail.DefaultSize;
/*
* ObjPrintQRCModel = new PrintQRCModel();
*
*
* /// pull details from ObjQRCModel and plug into ObjPrintQRCModel
* ObjPrintQRCModel.QRCId = ObjQRCModel.QRCId;
*
* ObjPrintQRCModel.QRCName = ObjQRCModel.QRCName;
* ObjPrintQRCModel.SpecialNotes = ObjQRCModel.SpecialNotes;
* ObjPrintQRCModel.QRCTYPE = ObjQRCModel.QRCTYPECaption;
* ObjPrintQRCModel.VehicleType = ObjQRCModel.VehicleTypeCaption;
* ObjPrintQRCModel.MotorType = ObjQRCModel.MotorTypeCaption;
*/
/// pull details from ObjQRCModel and plug into ObjPrintQRCModel End
ObjPrintQRCModel.QRCSize = _ICommonMethod.GetGlobalCodeData("QRCSIZE");
ObjPrintQRCModel.EncryptQRC = Cryptography.GetEncryptedData(ObjPrintQRCModel.QRCId.ToString(), true);
ObjPrintQRCModel.CompanyLogo = (ObjLoginModel != null && !string.IsNullOrEmpty(ObjLoginModel.LocationLogo)) ? (ObjLoginModel.LocationLogo) : "/";
ObjPrintQRCModel.CompanyImage = (ObjLoginModel != null && !string.IsNullOrEmpty(ObjLoginModel.LocationImage)) ? (ObjLoginModel.LocationImage) : "/";
ObjPrintQRCModel.CompanyName = (ObjLoginModel != null && !string.IsNullOrEmpty(ObjLoginModel.Location)) ? (ObjLoginModel.Location) : "/";
objLocationMasterModel = _IGlobalAdmin.GetLocationById(ObjPrintQRCModel.LocationId);
ObjPrintQRCModel.Location = objLocationMasterModel.LocationName;
//ViewBag.EncryptQRC = ObjPrintQRCModel.EncryptQRC;
ViewBag.EncryptQRC = ObjPrintQRCModel.QRCIDCode;
ViewBag.LastEncryptQRC = ObjPrintQRCModel.QRCIDCode;// + ',' + ObjPrintQRCModel.QRCTYPEID;//This field added by Bhushan Dod //After comma we don't need type of QRC.We need to comment .
ViewBag.QRCSize = ObjPrintQRCModel.QRCSize;
//PrintQRCModel ObjPrintQRCModel;
ViewBag.QRCModel = ObjPrintQRCModel;
}
else
{
var errors = ModelState.Values.SelectMany(v => v.Errors);
string _message = "";
foreach (var items in errors)
{
_message = _message + items.ErrorMessage;
}
ViewBag.Message = _message;
ObjQRCModel = _IQRCSetup.GetGlobalCodeForCategories();
}
}
catch (Exception ex)
{
WorkOrderEMS.BusinessLogic.Exception_B.Exception_B.exceptionHandel_Runtime(ex, "Exception For File Upload", path.ToString(), null);
ViewBag.Message = ex.Message;
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;
ObjQRCModel = _IQRCSetup.GetGlobalCodeForCategories();
ViewBag.Country = _ICommonMethod.GetAllcountries();
ViewBag.PurchType = _ICommonMethod.GetGlobalCodeDataList("PURCHASETYPE");
return(View(ObjQRCModel));
}
ObjQRCModel = _IQRCSetup.GetGlobalCodeForCategories();
ViewBag.Country = _ICommonMethod.GetAllcountries();
// ViewBag.PurchType = _ICommonMethod.GetGlobalCodeDataList("PURCHASETYPE");
ViewBag.PurchType = _ICommonMethod.GetGlobalCodeDataList("PURCHASETYPE");
ViewBag.RefreshMode = true;
//ViewBag.EncryptLastQRC = data.EncryptLastQRC;
//ViewBag.EncryptLastQRC = ObjQRCModel.EncryptLastQRC + "," + (string.IsNullOrEmpty(objLocationMasterModel.Address2) ? ObjLoginModel.Location.ToString().Substring(0, 3).ToUpper() : objLocationMasterModel.Address2.ToString().Substring(0, 3).ToUpper());
//ViewBag.ItemAbberivationList = Convert.ToString(ConfigurationManager.AppSettings["ItemAbberivationList"]);
//if (ObjLoginModel != null && (ObjLoginModel.UserRoleId == Convert.ToInt64(UserType.GlobalAdmin) || ObjLoginModel.UserRoleId == Convert.ToInt64(UserType.ITAdministrator)))
//{
// //ViewBag.ManagerList = _IGlobalAdmin.GetAllITAdministratorList(0, 1, 1000, "UserEmail", "asc", "", Convert.ToInt64(UserType.Manager), out Totalrecords);
// ViewBag.LocationList = _IGlobalAdmin.GetAllLocationNew();
// ViewBag.AdministratorList = _IGlobalAdmin.GetAllITAdministratorList(0, 0, 1, 1000, "UserEmail", "asc", "", Convert.ToInt64(UserType.Administrator), out Totalrecords);
//}
//else if (ObjLoginModel != null && (ObjLoginModel.UserRoleId == Convert.ToInt64(UserType.Administrator)))
//{
// ViewBag.LocationList = _IGlobalAdmin.GetAllLocationNew();
// //ViewBag.AdministratorList = _IGlobalAdmin.GetAllITAdministratorList(0, 1, 1000, "UserEmail", "asc", "", Convert.ToInt64(UserType.Manager), out Totalrecords);
// ViewBag.AdministratorList = _ICommonMethod.GetManagersBYLocationId(ObjLoginModel.LocationID);
//}
return(View(ObjQRCModel));
// return RedirectToAction("Index","QRCSetup");
}
public eFleetVehicleIncidentModel SaveEfleetVehicleIncident(eFleetVehicleIncidentModel objeFleetVehicleIncidentModel)
{
try
{
LocationMaster objLocationMaster = new LocationMaster();
var objeFleetVehicleIncident = new eFleetVehicleIncident();
var objeFleetVehicleIncidentRepository = new eFleetVehicleIncidentRepository();
var objeTracLoginModel = new eTracLoginModel();
if (objeFleetVehicleIncidentModel.IncidentID == 0)
{
objeFleetVehicleIncidentModel.IsDeleted = false;
AutoMapper.Mapper.CreateMap <eFleetVehicleIncidentModel, eFleetVehicleIncident>();
var objfleetVehicleIncidentMapper = AutoMapper.Mapper.Map(objeFleetVehicleIncidentModel, objeFleetVehicleIncident);
objeFleetVehicleIncidentRepository.Add(objfleetVehicleIncidentMapper);
// objeFleetVehicle.QRCodeID = objeFleetVehicleModel.QRCodeID + "EFV" + (objeFleetVehicle.VehicleID + 100).ToString();
objeFleetVehicleIncidentRepository.SaveChanges();
objeFleetVehicleIncidentModel.Result = Result.Completed;
if (objeFleetVehicleIncidentModel.Result == Result.Completed)
{
#region Save DAR
DARModel objDAR = new DARModel();
objDAR.ActivityDetails = DarMessage.RegisterNeweFleetIncidentVehicle(objeFleetVehicleIncidentModel.LocationName);
objDAR.LocationId = objeFleetVehicleIncidentModel.LocationID;
objDAR.UserId = objeFleetVehicleIncidentModel.UserID;
objDAR.CreatedBy = objeFleetVehicleIncidentModel.UserID;
objDAR.CreatedOn = DateTime.UtcNow;
objDAR.TaskType = (long)TaskTypeCategory.eFleetVehicleIncidentSubmission;
Result result = _ICommonMethod.SaveDAR(objDAR);
#endregion Save DAR
//Created By Ashwajit Bansod for Sending the Mail of Vehicle Incident 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(objeFleetVehicleIncidentModel.LocationID, objeFleetVehicleIncidentModel.UserID).Result;
//Code added by Bhu on 14 Dec 2017 for sending email to [email protected]. This is common MRA for risk manager.
var objEmailToManagerModel = new EmailToManagerModel();
objEmailToManagerModel.LocationID = objeFleetVehicleIncidentModel.LocationID;
objEmailToManagerModel.LocationName = objeFleetVehicleIncidentModel.LocationName;
objEmailToManagerModel.ManagerEmail = "*****@*****.**";
objEmailToManagerModel.ManagerName = "Team";
objEmailToManagerModel.ManagerUserId = 3; //admin user id for need to track email log
objEmailToManagerModel.RequestBy = 3; //admin user id for need to track email log
objEmailToManagerModel.UserName = "******";
objEmailReturn.Add(objEmailToManagerModel);
}
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;
objEmailHelper.VehicleNumber = objeFleetVehicleIncidentModel.VehicleNumber;
objEmailHelper.LocationName = objeFleetVehicleIncidentModel.LocationName;
objEmailHelper.UserName = item.UserName;
objEmailHelper.QrCodeId = objeFleetVehicleIncidentModel.QRCodeID;
objEmailHelper.AccidentDate = objeFleetVehicleIncidentModel.AccidentDate.ToString();
objEmailHelper.City = objeFleetVehicleIncidentModel.City;
objEmailHelper.NumberOfInjuries = objeFleetVehicleIncidentModel.NumberOfInjuries;
objEmailHelper.DriverNameForVehicleIncident = objeFleetVehicleIncidentModel.DriverName;
objEmailHelper.IncidentDescription = objeFleetVehicleIncidentModel.Description;
if (objeFleetVehicleIncidentModel.Preventability == true)
{
objEmailHelper.Prevenatability = "Yes";
}
else
{
objEmailHelper.Prevenatability = "No";
}
//objEmailHelper.InfractionStatus = obj.Status;
objEmailHelper.MailType = "VehicleIncident";
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.eFleetIncidentForServiceReported(objeFleetVehicleIncidentModel.LocationName, objeFleetVehicleIncidentModel.QRCodeID, objeFleetVehicleIncidentModel.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
}
}
}
else
{
var vehicleIncidentData = objeFleetVehicleIncidentRepository.GetAll(v => v.IsDeleted == false && v.LocationID == objeFleetVehicleIncidentModel.LocationID && v.IncidentID == objeFleetVehicleIncidentModel.IncidentID).SingleOrDefault();
objeFleetVehicleIncidentModel.IncidentImage = vehicleIncidentData.IncidentImage;
AutoMapper.Mapper.CreateMap <eFleetVehicleIncidentModel, eFleetVehicleIncident>();
// objeFleetVehicleIncident.FuelType = Convert.ToInt32(objeFleetVehicleIncidentModel.FuelType);
var objfleetVehicleMapper = AutoMapper.Mapper.Map(objeFleetVehicleIncidentModel, vehicleIncidentData);
objeFleetVehicleIncidentRepository.SaveChanges();
objeFleetVehicleIncidentModel.Result = Result.UpdatedSuccessfully;
if (objeFleetVehicleIncidentModel.Result == Result.UpdatedSuccessfully)
{
#region Save DAR
DARModel objDAR = new DARModel();
objDAR.ActivityDetails = DarMessage.UpdateeFleetVehicleIncident(objeFleetVehicleIncidentModel.LocationName);
objDAR.LocationId = objeFleetVehicleIncidentModel.LocationID;
objDAR.UserId = objeFleetVehicleIncidentModel.UserID;
objDAR.ModifiedBy = objeFleetVehicleIncidentModel.UserID;
objDAR.ModifiedOn = DateTime.UtcNow;
objDAR.TaskType = (long)TaskTypeCategory.UpdateeFleetIncidentVehicle;
Result result = _ICommonMethod.SaveDAR(objDAR);
#endregion Save DAR
}
}
return(objeFleetVehicleIncidentModel);
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public eFleetVehicleIncidentModel SaveEfleetVehicleIncident(eFleetVehicleIncidentModel objeFleetVehicleIncidentModel)", "Exception While saving vehicle Incident request.", objeFleetVehicleIncidentModel);
throw;
}
}
/// <summary>
/// Created By : Ashwajit Bansod
/// Created Date : 17-OCT-2018
/// Created For : To save Miscellaneous data
/// </summary>
/// <param name="Obj"></param>
/// <returns></returns>
public ServiceResponseModel <MiscellaneousDetails> SaveMiscellaneous(MiscellaneousDetails Obj)
{
bool IsSaved = false;
string Action = "";
var objDAR = new DARModel();
List <string> LocationData = new List <string>();
var CommonManager = new CommonMethodManager();
string MISID = "";
string LocationName = "";
long UserId = 0;
long Mis_Id = 0;
decimal TotalAmount = 0;
try
{
var data = new MiscellaneousDetails();
var ObjServiceResponseModel = new ServiceResponseModel <MiscellaneousDetails>();
if (Obj.MiscellaneousDetailsmodel.Count > 0)
{
Action = "I";
foreach (var item in Obj.MiscellaneousDetailsmodel)
{
var SaveMiscData = _workorderems.spSetMiscellaneous(Action, item.MISId, item.CostCode, item.LocationId,
item.VendorId, item.Discription, item.InvoiceAmount,
item.InvoiceDate, item.InvoiceDocument, item.UserId,
null, "Y");
var locData = _workorderems.LocationMasters.Where(x => x.LocationId == item.LocationId && x.IsDeleted == false).FirstOrDefault();
LocationData.Add(locData.LocationName);
MISID = "MIS" + item.MISId.ToString();
Mis_Id = item.MISId;
UserId = item.UserId;
TotalAmount += Convert.ToDecimal(item.InvoiceAmount);
IsSaved = true;
}
if (IsSaved == true)
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.SuccessResponse, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Message = CommonMessage.SaveSuccessMessage();
ObjServiceResponseModel.Data = null;
}
else
{
ObjServiceResponseModel.Response = Convert.ToInt32(ServiceResponse.NoRecord, CultureInfo.CurrentCulture);
ObjServiceResponseModel.Message = CommonMessage.NoRecordMessage();
ObjServiceResponseModel.Data = null;
}
#region Save DAR
LocationName = string.Join(",", LocationData.ToArray());
objDAR.ActivityDetails = DarMessage.MiscellaneousCreated(LocationName, MISID);
objDAR.TaskType = (long)TaskTypeCategory.MiscellaneousCreated;
objDAR.UserId = UserId;
objDAR.CreatedBy = UserId;
objDAR.CreatedOn = DateTime.UtcNow;
CommonManager.SaveDAR(objDAR);
#endregion DAR
#region Notification
var objNotify = new NotificationDetailModel();
var _ICommonMethod = new CommonMethodManager();
var objModel = new CommonApproval <ApprovalInput>();
var approvalInput = new ApprovalInput();
approvalInput.Amount = TotalAmount;
approvalInput.UserId = UserId;
approvalInput.ModuleName = "eCounting";
var getRuleData = objModel.GetApprovalRuleData(approvalInput);
if (getRuleData != null)
{
objNotify.CreatedBy = UserId;
objNotify.CreatedDate = DateTime.UtcNow;
objNotify.AssignTo = getRuleData.UserId;
if (MISID != null)
{
//var id = Convert.ToInt64(MISID);
objNotify.MiscellaneousID = Mis_Id;
}
var saveDataForNotification = _ICommonMethod.SaveNotificationDetail(objNotify);
}
if (getRuleData.DeviceId != null)
{
var objEmailHelper = new EmailHelper();
var objTemplateModel = new TemplateModel();
var userData = _workorderems.UserRegistrations.Where(x => x.UserId == UserId &&
x.IsDeleted == false && x.IsEmailVerify == true).FirstOrDefault();
objEmailHelper.emailid = getRuleData.Email;
objEmailHelper.ManagerName = getRuleData.ManagerName;
objEmailHelper.LocationName = LocationName;
if (userData != null)
{
objEmailHelper.UserName = userData.FirstName + " " + userData.LastName;
}
objEmailHelper.MISId = MISID;
//objEmailHelper.InfractionStatus = obj.Status;
objEmailHelper.MailType = "APPROVEMISCELLANEOUS";
objEmailHelper.SentBy = UserId;
objEmailHelper.LocationID = objDAR.LocationId;
objEmailHelper.TimeAttempted = DateTime.UtcNow.ToMobileClientTimeZone(objTemplateModel.TimeZoneName, objTemplateModel.TimeZoneOffset, objTemplateModel.IsTimeZoneinDaylight, false).ToString();
objEmailHelper.IsWorkable = true;
if (getRuleData.DeviceId != null)
{
string message = PushNotificationMessages.MiscellaneousCreate(objNotify.BillID.ToString(), objEmailHelper.UserName, objEmailHelper.LocationName);
PushNotificationFCM.FCMAndroid(message, getRuleData.DeviceId, objEmailHelper);
}
}
#endregion Notification
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;
}
}
/// <summary>
/// Created By : Ashwajit Bansod
/// Created Date : 18-OCT-2018
/// Created for : To approve miscellaneous data.
/// </summary>
/// <param name="Obj"></param>
/// <returns></returns>
public bool ApproveMiscellaneous(List <MiscellaneousListModel> Obj, string UserName, long UserId, long LocationId, long MiscQbkId, long VendorDetailsId)
{
bool IsApproved = false;
long MISNumber = 0;
decimal? calculatedAmt = 0;
string MISID = "";
var objDAR = new DARModel();
var CommonManager = new CommonMethodManager();
DateTime date = new DateTime();
long CreatedBy = 0;
long Location = 0;
bool GetOnceData = false;
var UserDetail = new UserModel();
var LocationDetail = new LocationMaster();
string Status = "Approved";
try
{
if (Obj.Count > 0)
{
foreach (var item in Obj)
{
MISID = item.MISId;
string id = item.MISId.Split('S')[1];
MISNumber = Convert.ToInt64(id);
calculatedAmt += item.InvoiceAmount;
Location = item.LocationId;
date = Convert.ToDateTime(item.MISDate);
CreatedBy = item.Vendor;
objDAR.TaskType = (long)TaskTypeCategory.MiscellaneousReject;
if (item.Status == "N")
{
Status = "Reject";
calculatedAmt -= item.InvoiceAmount;
objDAR.TaskType = (long)TaskTypeCategory.MiscellaneousReject;
}
var saveApprove = _workorderems.spSetApprovalForMiscellaneous(item.MId, item.Comment, item.Status, UserId);
if (GetOnceData == false)
{
GetOnceData = true;
UserDetail = _workorderems.UserRegistrations.Join(_workorderems.LogMiscellaneous, u => u.UserId, m => m.LMIS_ModifiedBy, (u, m) => new { u, m }).
Where(x => x.m.LMIS_MIS_Id == MISNumber).
Select(x => new UserModel()
{
UserName = x.u.FirstName + " " + x.u.LastName,
Email = x.u.UserEmail,
Location = x.m.LMIS_LocationId
}).FirstOrDefault();
LocationDetail = _workorderems.LocationMasters.Where(x => x.LocationId == UserDetail.Location &&
x.IsDeleted == false).FirstOrDefault();
}
#region Save DAR
objDAR.ActivityDetails = DarMessage.MiscellaneousApproveReject(LocationDetail.LocationName, MISID, Status);
objDAR.UserId = UserId;
objDAR.CreatedBy = UserId;
objDAR.LocationId = UserDetail.Location;
objDAR.CreatedOn = DateTime.UtcNow;
CommonManager.SaveDAR(objDAR);
#endregion DAR
}
string Action = "I";
var saveBill = _workorderems.spSetBill(Action, MiscQbkId, null, MISNumber, null, VendorDetailsId, Location, "MIS", calculatedAmt,
calculatedAmt, date, null, CreatedBy, null, "Y");
IsApproved = true;
}
else
{
IsApproved = true;
}
if (IsApproved == true)
{
#region Email
var objEmailLogRepository = new EmailLogRepository();
var objEmailReturn = new List <EmailToManagerModel>();
var objListEmailog = new List <EmailLog>();
var objTemplateModel = new TemplateModel();
if (IsApproved == true)
{
var userData = _workorderems.UserRegistrations.Join(_workorderems.LogMiscellaneous, u => u.UserId, m => m.LMIS_ModifiedBy, (u, m) => new { u, m }).
Where(x => x.m.LMIS_MIS_Id == MISNumber).FirstOrDefault();
//Select(x => new UserModel()
//{
// UserName = x.u.FirstName + " " + x.u.LastName,
// Email = x.u.UserEmail,
// Location = x.m.LMIS_LocationId,
//}).FirstOrDefault();
var locationName = _workorderems.LocationMasters.Where(x => x.LocationId == userData.m.LMIS_LocationId &&
x.IsDeleted == false).FirstOrDefault();
if (userData != null)
{
bool IsSent = false;
var objEmailHelper = new EmailHelper();
objEmailHelper.emailid = userData.u.SubscriptionEmail;
objEmailHelper.LocationName = locationName.LocationName;
objEmailHelper.UserName = userData.u.FirstName + " " + userData.u.LastName;
objEmailHelper.MISId = MISID;
objEmailHelper.MailType = "APPROVEMISCELLANEOUS";
objEmailHelper.SentBy = UserId;
objEmailHelper.LocationID = userData.m.LMIS_LocationId;
objEmailHelper.TimeAttempted = DateTime.UtcNow.ToMobileClientTimeZone(objTemplateModel.TimeZoneName, objTemplateModel.TimeZoneOffset, objTemplateModel.IsTimeZoneinDaylight, false).ToString();
IsSent = objEmailHelper.SendEmailWithTemplate();
//Push Notification
if (userData.u.DeviceId != null)
{
string message = PushNotificationMessages.MiscellaneousApprovedReject(objEmailHelper.LocationName, MISID, Status, objEmailHelper.UserName);
PushNotification.GCMAndroid(message, userData.u.DeviceId, objEmailHelper);
}
if (IsSent == true)
{
var objEmailog = new EmailLog();
try
{
objEmailog.CreatedBy = UserId;
objEmailog.CreatedDate = DateTime.UtcNow;
objEmailog.DeletedBy = null;
objEmailog.DeletedOn = null;
objEmailog.LocationId = userData.m.LMIS_LocationId;
objEmailog.ModifiedBy = null;
objEmailog.ModifiedOn = null;
objEmailog.SentBy = UserId;
objEmailog.SentEmail = userData.u.SubscriptionEmail;
objEmailog.Subject = objEmailHelper.Subject;
objEmailog.SentTo = userData.u.UserId;
objListEmailog.Add(objEmailog);
}
catch (Exception)
{
throw;
}
}
using (var context = new workorderEMSEntities())
{
context.EmailLogs.AddRange(objListEmailog);
context.SaveChanges();
}
#endregion Email
}
}
else
{
IsApproved = true;
}
}
return(IsApproved);
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public MiscellaneousListDetails GetListMiscellaneous(long? UserId,long? Location, int? pageIndex, int? numberOfRows, string sortColumnName, string sortOrderBy, long? locationId, string textSearch, string statusType)", "Exception While Getting List of Miscellaneous details.", null);
throw;
}
}
/// <summary>Save eFleet Preventative Maintenance
/// <CreatedBy>Bhushan Dod</CreatedBy>
/// <CreatedFor>SaveeFleetPreventativeMaintenance</CreatedFor>
/// <CreatedOn>August-29-2017</CreatedOn>
/// </summary>
/// <param name="eFleetDamageTireModel"></param>
/// <returns></returns>
public ServiceResponseModel <string> InsertPreventativeMaintenance(eFleetPreventaticeMaintenanceModel objModel)
{
var objReturnModel = new ServiceResponseModel <string>();
try
{
var objeFleetPreventativeMaintenanceRepository = new eFleetPreventativeMaintenanceRepository();
eFleetPreventativeMaintenance Obj = new eFleetPreventativeMaintenance();
AutoMapper.Mapper.CreateMap <eFleetPreventaticeMaintenanceModel, eFleetPreventativeMaintenance>();
Obj = AutoMapper.Mapper.Map(objModel, Obj);
Obj.CreatedBy = objModel.UserId;
Obj.CreatedDate = DateTime.UtcNow;
objeFleetPreventativeMaintenanceRepository.Add(Obj);
if (Obj.ID > 0)
{
#region Save DAR
DARModel objDAR = new DARModel();
objDAR.ActivityDetails = DarMessage.NeweFleetPMCreated(objModel.LocationName);
objDAR.LocationId = objModel.LocationID;
objDAR.UserId = objModel.UserId;
objDAR.CreatedBy = objModel.UserId;
objDAR.CreatedOn = DateTime.UtcNow;
objDAR.TaskType = (long)TaskTypeCategory.PreventativeMaintenanceSubmission;
Result result = _ICommonMethod.SaveDAR(objDAR);
#endregion Save DAR
#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(objModel.LocationID, objModel.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;
objEmailHelper.RemiderMetric = Convert.ToString(objModel.ReminderMetric);
objEmailHelper.Meter = Convert.ToString(objModel.Meter);
objEmailHelper.VehicleNumber = objModel.VehicleNumber;
objEmailHelper.LocationName = objModel.LocationName;
objEmailHelper.UserName = item.UserName;
objEmailHelper.QrCodeId = objModel.QrCodeId;
objEmailHelper.ServiceDueDate = objModel.ServiceDueDate.ToString();
//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(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
objReturnModel.Response = Convert.ToInt32(ServiceResponse.SuccessResponse, CultureInfo.InvariantCulture);
objReturnModel.Message = CommonMessage.Successful();
}
}
}
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);
}
/// <summary>
/// Created By : Ashwajit Bansod
/// Created Date : 26-OCT-2018
/// Created for : To save Payment data to database.
/// </summary>
/// <param name="objPaymentModel"></param>
/// <param name="ObjData"></param>
/// <returns></returns>
public string MakePayment(PaymentModel objPaymentModel, PaymentModel ObjData)
{
string result = "";
string Action = "";
string Status = "Y";
string PaidStatus = "";
var objDAR = new DARModel();
var CommonManager = new CommonMethodManager();
try
{
if (objPaymentModel != null && ObjData != null)
{
var ChequeNo = Convert.ToInt32(objPaymentModel.ChequeNo);
PaidStatus = "Paid";
if (objPaymentModel.ChequeNo != null)
{
objPaymentModel.Comment = ChequeNo.ToString();
}
else if (objPaymentModel.AccNo != null && objPaymentModel.IsCancel == false)
{
ObjData.VendorId = 0;
objPaymentModel.Comment = objPaymentModel.AccNo;
}
else if (objPaymentModel.CARDNo != null && objPaymentModel.IsCancel == false)
{
objPaymentModel.Comment = objPaymentModel.CARDNo;
}
else if (objPaymentModel.AccountNo != null && objPaymentModel.IsCancel == false)
{
objPaymentModel.Comment = objPaymentModel.AccountNo;
}
else if (objPaymentModel.Comment != null && objPaymentModel.IsCancel == true)
{
objPaymentModel.Comment = objPaymentModel.Comment;
Status = "X";
PaidStatus = "Canceled";
}
Action = "I";
if (objPaymentModel.IsCancel == false)
{
var savePayment = _workorderems.spSetCompanyAccountTransaction(Action, null, ObjData.VendorId, objPaymentModel.OpeartorCAD_Id, objPaymentModel.CompanyAccountId,
ObjData.BillNo, ObjData.BillAmount, ChequeNo,
objPaymentModel.Comment, objPaymentModel.UserId, ObjData.LocationId,
ObjData.BillType, Status);
}
if (Status == "Y")
{
Status = "P";
}
var changeStatus = _workorderems.spSetPaymentStatusForBill(ObjData.LLBL_ID, objPaymentModel.Comment, Status,
objPaymentModel.UserId);
result = CommonMessage.PaymentSave();
}
else
{
result = CommonMessage.PaymentError();
}
#region Save DAR
var userData = _workorderems.UserRegistrations.Where(x => x.UserId == objPaymentModel.UserId &&
x.IsDeleted == false && x.IsEmailVerify == true).FirstOrDefault();
var locationData = _workorderems.LocationMasters.Where(x => x.LocationId == ObjData.LocationId &&
x.IsDeleted == false).FirstOrDefault();
objDAR.ActivityDetails = DarMessage.PaymentPaidCancel(userData.FirstName + "" + userData.LastName, locationData.LocationName, PaidStatus, ObjData.BillNo);
long userId = Convert.ToInt64(objPaymentModel.UserId);
objDAR.TaskType = (long)TaskTypeCategory.PaymentApporveCancel;
objDAR.UserId = userId;
objDAR.CreatedBy = userId;
objDAR.LocationId = Convert.ToInt64(objPaymentModel.LocationId);
objDAR.CreatedOn = DateTime.UtcNow;
CommonManager.SaveDAR(objDAR);
#endregion DAR
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public string MakePayment(PaymentModel objPaymentModel)", "Exception While Saving Payment.", objPaymentModel);
throw;
}
return(result);
}
/// <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;
}
}
public ActionResult Index(QRCModel ObjUserModel)
{
DARModel objDAR = null; long LocId = 0;
string ImageURL = "";
string ImageUniqueName = "";
try
{
eTracLoginModel ObjLoginModel = null;
if (Session["eTrac"] != null)
{
ObjLoginModel = (eTracLoginModel)(Session["eTrac"]);
}
if (Session["eTrac_SelectedDasboardLocationID"] != null)
{
LocId = (long)Session["eTrac_SelectedDasboardLocationID"];
}
//if (ModelState.IsValid)
//{
CommonHelper ObjCommonHelper = new CommonHelper();
HttpPostedFileBase ProfileImage = null;
string msg = string.Empty;
if (ObjUserModel != null && ObjUserModel.UserModel != null) //&& ObjUserModel.UserModel.UserId == 0
{
objDAR = new DARModel();
objDAR.LocationId = ObjLoginModel.LocationID;
objDAR.UserId = ObjLoginModel.UserId;
objDAR.CreatedBy = ObjLoginModel.UserId;
objDAR.CreatedOn = DateTime.UtcNow;
objDAR.TaskType = (long)TaskTypeCategory.UserCreation;
if (ObjUserModel.UserModel.ProfileImage != null)
{
ProfileImage = ObjUserModel.UserModel.ProfileImage;
}
if (ObjUserModel.UserModel.UserId == 0)
{
#region password
//ObjUserModel.UserModel.Password = _ICommonMethod.CreateRandomPassword();
/*
* ObjUserModel.UserModel.Password = Guid.NewGuid().ToString();
* ObjUserModel.UserModel.Password = ObjUserModel.UserModel.Password.Length > pwdmaxlendth ? ObjUserModel.UserModel.Password.Substring(0, pwdmaxlendth) : ObjUserModel.UserModel.Password;
* ObjUserModel.UserModel.Password = Cryptography.GetEncryptedData(ObjUserModel.UserModel.Password, true);
* //ObjUserModel.UserModel.Password = (!string.IsNullOrEmpty(ObjUserModel.UserModel.Password)) ? Cryptography.GetEncryptedData(ObjUserModel.UserModel.Password, true) : ObjUserModel.UserModel.Password;
*/
if (!String.IsNullOrEmpty(ObjUserModel.UserModel.Password))
{
ObjUserModel.UserModel.Password = Cryptography.GetEncryptedData(ObjUserModel.UserModel.Password, true);
}
#endregion password
ObjUserModel.UserModel.CreatedBy = ObjLoginModel.UserId;
ObjUserModel.UserModel.CreatedDate = DateTime.UtcNow;
ObjUserModel.UserModel.IsDeleted = false;
objDAR.TaskType = (long)TaskTypeCategory.UserCreation;
objDAR.ActivityDetails = DarMessage.NewAdministratorCreatedDar(ObjLoginModel.Location);
}
else
{
ObjUserModel.UserModel.ModifiedBy = ObjLoginModel.UserId;
ObjUserModel.UserModel.ModifiedDate = DateTime.UtcNow;
ObjUserModel.UserModel.IsDeleted = false;
if (!String.IsNullOrEmpty(ObjUserModel.UserModel.Password))
{
ObjUserModel.UserModel.Password = Cryptography.GetEncryptedData(ObjUserModel.UserModel.Password, true);
}
objDAR.TaskType = (long)TaskTypeCategory.UserUpdate;
objDAR.ActivityDetails = DarMessage.AdministratorUpdatedDar(ObjLoginModel.Location);
}
if (ObjUserModel.UserModel.ProfileImage != null)
{
string ImageName = ObjLoginModel.UserId + "_" + DateTime.Now.Ticks.ToString() + "_" + ObjUserModel.UserModel.ProfileImage.FileName.ToString();
CommonHelper obj_CommonHelper = new CommonHelper();
obj_CommonHelper.UploadImage(ObjUserModel.UserModel.ProfileImage, Server.MapPath(ConfigurationManager.AppSettings["ProfilePicPath"]), ImageName);
ObjUserModel.UserModel.ProfileImageFile = ImageName;
}
if (ObjUserModel.SignatureImageBase != null)
{
string ImagePath = HttpContext.Server.MapPath(ConfigurationManager.AppSettings["UserSignature"].ToString());
ImageUniqueName = DateTime.Now.ToString("yyyyMMddHHmmsstt") + "UserSignature";
string url = HostingPrefix + ImagePath.Replace("~", "") + ImageUniqueName + ".jpg";
ImageURL = ImageUniqueName + ".jpg";
if (!Directory.Exists(ImagePath))
{
Directory.CreateDirectory(ImagePath);
}
var ImageLocation = ImagePath + ImageURL;
string convert = ObjUserModel.SignatureImageBase.Replace("data:image/png;base64,", String.Empty);
string RemoveSpace = convert.Replace(" ", "+");
byte[] image64 = Convert.FromBase64String(RemoveSpace);
using (MemoryStream ms = new MemoryStream(image64))
{
using (Bitmap bm2 = new Bitmap(ms))
{
bm2.Save(ImageLocation);
}
}
}
ObjUserModel.UserModel.SignatureImageBase = ImageURL;
long QRCID = 0;
//Result result = _IClientManager.SaveClient(ObjUserModel.UserModel, out QRCID, true, objDAR);
Result result = Result.LoginFailed; // if LocId is null then we will consider that the session is expired.
if (LocId > 0)
{
result = _IClientManager.SaveClient(ObjUserModel.UserModel, out QRCID, true, objDAR, LocId, ObjLoginModel.UserId, "");
}
if (result == Result.Completed)
{
ViewBag.Message = CommonMessage.SaveSuccessMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Success;
var abc = _ICommonMethod.GetLocationDetailsById(LocId);
EmailHelper objEmailHelper = new EmailHelper();
objEmailHelper.emailid = ObjUserModel.UserModel.UserEmail;
objEmailHelper.UserName = ObjUserModel.UserModel.AlternateEmail;
objEmailHelper.UserType = ObjUserModel.UserModel.UserType;
objEmailHelper.FirstName = ObjUserModel.UserModel.FirstName;
objEmailHelper.LastName = ObjUserModel.UserModel.LastName;
objEmailHelper.Password = Cryptography.GetDecryptedData(ObjUserModel.UserModel.Password, true);
objEmailHelper.LocationName = abc.LocationName;
objEmailHelper.LocAddress = ObjUserModel.UserModel.Address.Address1; // here locAddress means user Address
objEmailHelper.MailType = "CreateNewUser";
HostingPrefix = HostingPrefix + "Manager/Employee?usr="******"?usr="******"index", "GlobalAdmin");
ObjUserModel = _ICommonMethod.LoadInvitedUser(string.Empty);
}
else
{
ViewBag.Message = CommonMessage.FailureMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;// store the failure message in tempdata to display in view.
}
}
else
{
ViewBag.Message = CommonMessage.InvalidEntry();
}
}
catch (Exception ex)
{
ViewBag.Message = ex.Message;
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;
}
finally
{
ViewBag.Country = _ICommonMethod.GetAllcountries();
ViewBag.JobTitleList = _ICommonMethod.GetGlobalCodeData("UserJobTitle");
ViewBag.LocationList = _IGlobalAdmin.GetAllLocationNew();
/*
* System.Data.Entity.Core.Objects.ObjectParameter paramTotalRecords = new System.Data.Entity.Core.Objects.ObjectParameter("TotalRecords", typeof(int));
* ObjUserModel.JobTitleList = _ICommonMethod.GetGlobalCodeData("JOBTITLE");
* ObjUserModel.LocationList = _IGlobalAdmin.GetAllLocationList(0, "GetAllLocation", 1, 10000, "LocationName", "desc", "", paramTotalRecords);
* paramTotalRecords = null;
*/
}
ViewBag.UpdateMode = false;
//ObjUserModel.UserModel = _IClientManager.GetClientByID(ObjUserModel.UserModel.UserId, "GetUserByID", null, null, null, null, null);
return(View("Administrator", ObjUserModel));
}
/// <summary>
/// Created By : Ashwajit Bansod
/// Created Date : 20-OCT-2018
/// Created For : To approve and reject bill
/// </summary>
/// <param name="Obj"></param>
/// <param name="UserName"></param>
/// <param name="UserId"></param>
/// <param name="LocationId"></param>
/// <returns></returns>
public string ApproveBill(BillListApproveModel Obj, string UserName, long UserId, long LocationId)
{
bool IsApproved = false;
string result = "";
var objDAR = new DARModel();
var CommonManager = new CommonMethodManager();
string ApproveStatus = "";
try
{
var userDataItem = _workorderems.UserRegistrations.Where(x => x.UserId == UserId &&
x.IsDeleted == false && x.IsEmailVerify == true).FirstOrDefault();
if (Obj != null)
{
string Action = "I";
if (Obj.Comment == null)
{
Obj.Status = "Y";
ApproveStatus = "Approved";
}
else
{
Obj.Status = "N";
ApproveStatus = "Rejected";
}
var saveBillApprove = _workorderems.spSetApprovalForPreBill(Obj.LBLL_Id, Obj.Comment, Obj.Status, UserId);
//var saveApprove = _workorderems.spSetApprovalForBill(Obj.LBLL_Id, Obj.Comment,Obj.Status,UserId);
Obj.InvoiceDate = Convert.ToDateTime(Obj.BillDate);
var saveSetBill = _workorderems.spSetBill(Action, Obj.QuickBookBillId, null, null, Obj.BillId, Obj.VendorId, LocationId,
"Manual Bill", null, Obj.BillAmount, Obj.InvoiceDate,
Obj.BillImage, UserId, UserId, "Y");
IsApproved = true;
if (Obj.Comment == null)
{
result = CommonMessage.BillApprove();
}
else
{
result = CommonMessage.BillReject();
}
#region Save DAR
var locationData = _workorderems.LocationMasters.Where(x => x.LocationId == LocationId &&
x.IsDeleted == false).FirstOrDefault();
objDAR.ActivityDetails = DarMessage.BillApprovedReject(userDataItem.FirstName + "" + userDataItem.LastName, locationData.LocationName, ApproveStatus);
objDAR.TaskType = (long)TaskTypeCategory.BillApprovedReject;
objDAR.UserId = UserId;
objDAR.CreatedBy = UserId;
objDAR.LocationId = LocationId;
objDAR.CreatedOn = DateTime.UtcNow;
CommonManager.SaveDAR(objDAR);
#endregion DAR
}
else
{
IsApproved = true;
}
if (IsApproved == true)
{
#region Email
var objEmailLogRepository = new EmailLogRepository();
var objEmailReturn = new List <EmailToManagerModel>();
var objListEmailog = new List <EmailLog>();
var objTemplateModel = new TemplateModel();
if (IsApproved == true)
{
var userData = _workorderems.spGetVendorAllDetail(Obj.VendorId).
Select(x => new BillListApproveModel()
{
Email = x.COD_Email,
}).FirstOrDefault();
if (userData != null)
{
bool IsSent = false;
var objEmailHelper = new EmailHelper();
objEmailHelper.emailid = userData.Email;
objEmailHelper.LocationName = Obj.LocationName;
objEmailHelper.VendorName = Obj.VendorName;
objEmailHelper.UserName = userDataItem.FirstName + " " + userDataItem.LastName;
objEmailHelper.MailType = "APPROVEBILL";
objEmailHelper.SentBy = UserId;
objEmailHelper.LocationID = LocationId;
objEmailHelper.TimeAttempted = DateTime.UtcNow.ToMobileClientTimeZone(objTemplateModel.TimeZoneName, objTemplateModel.TimeZoneOffset, objTemplateModel.IsTimeZoneinDaylight, false).ToString();
IsSent = objEmailHelper.SendEmailWithTemplate();
var userDataApprove = _workorderems.LogBills.Join(_workorderems.UserRegistrations, q => q.LBLL_ModifiedBy, u => u.UserId, (q, u) => new { q, u }).
Where(x => x.q.LBLL_Id == Obj.LBLL_Id).FirstOrDefault();
//Push Notification
if (userDataApprove != null)
{
if (userDataApprove.u.DeviceId != null)
{
string message = PushNotificationMessages.BillApprovedReject(objEmailHelper.LocationName, Obj.LBLL_Id, ApproveStatus, objEmailHelper.UserName);
PushNotification.GCMAndroid(message, userDataApprove.u.DeviceId, objEmailHelper);
}
}
if (IsSent == true)
{
var objEmailog = new EmailLog();
try
{
objEmailog.CreatedBy = UserId;
objEmailog.CreatedDate = DateTime.UtcNow;
objEmailog.DeletedBy = null;
objEmailog.DeletedOn = null;
objEmailog.LocationId = LocationId;
objEmailog.ModifiedBy = null;
objEmailog.ModifiedOn = null;
objEmailog.SentBy = UserId;
objEmailog.SentEmail = userData.Email;
objEmailog.Subject = objEmailHelper.Subject;
objEmailog.SentTo = Obj.VendorId;
objListEmailog.Add(objEmailog);
}
catch (Exception)
{
throw;
}
}
using (var context = new workorderEMSEntities())
{
context.EmailLogs.AddRange(objListEmailog);
context.SaveChanges();
}
#endregion Email
}
}
else
{
result = "Somethinsg goes wrong.";
}
}
return(result);
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public MiscellaneousListDetails GetListMiscellaneous(long? UserId,long? Location, int? pageIndex, int? numberOfRows, string sortColumnName, string sortOrderBy, long? locationId, string textSearch, string statusType)", "Exception While Getting List of Miscellaneous details.", null);
throw;
}
}
/// <summary>
/// Created by Ashwait Bansod for Saving data to database and also update data to database
/// </summary>
/// <param name="objeFleetDriverModel"></param>
/// <returns></returns>
public eFleetDriverModel SaveEfleetDriver(eFleetDriverModel objeFleetDriverModel)
{
try
{
var objLocationMaster = new LocationMaster();
var objeFleetDriver = new eFleetDriver();
var objeFleetDriverRepository = new eFleetDriverRepository();
var objeTracLoginModel = new eTracLoginModel();
if (objeFleetDriverModel.DriverID == 0)
{
AutoMapper.Mapper.CreateMap <eFleetDriverModel, eFleetDriver>();
var objfleetDriverMapper = AutoMapper.Mapper.Map(objeFleetDriverModel, objeFleetDriver);
objeFleetDriverRepository.Add(objfleetDriverMapper);
//objeFleetDriver.QRCCodeID = objeFleetDriverModel.QRCCodeID + "EFD" + (objeFleetDriver.DriverID + 100).ToString();
objeFleetDriverRepository.SaveChanges();
objeFleetDriverModel.Result = Result.Completed;
if (objeFleetDriverModel.Result == Result.Completed)
{
#region Save DAR
DARModel objDAR = new DARModel();
objDAR.ActivityDetails = DarMessage.RegisterNeweFleetDriver(objeFleetDriverModel.LocationName);
objDAR.LocationId = objeFleetDriverModel.LocationID;
objDAR.UserId = objeFleetDriverModel.UserID;
objDAR.CreatedBy = objeFleetDriverModel.UserID;
objDAR.CreatedOn = DateTime.UtcNow;
objDAR.TaskType = (long)TaskTypeCategory.eFleetDriverSubmission;
Result result = _ICommonMethod.SaveDAR(objDAR);
#endregion Save DAR
}
}
//edit Data
else
{
var DriverData = objeFleetDriverRepository.GetAll(v => v.IsDeleted == false && v.DriverID == objeFleetDriverModel.DriverID).FirstOrDefault();
if (objeFleetDriverModel.DriverImageFile != null)
{
}
else
{
objeFleetDriverModel.DriverImage = DriverData.DriverImage;
}
//== null ? "" : HostingPrefix + ProfilePicPath.Replace("~", "") + DriverData.DriverImage;
AutoMapper.Mapper.CreateMap <eFleetDriverModel, eFleetDriver>();
var objfleetDriverMapper = AutoMapper.Mapper.Map(objeFleetDriverModel, DriverData);
objeFleetDriverRepository.SaveChanges();
objeFleetDriverModel.Result = Result.UpdatedSuccessfully;
if (objeFleetDriverModel.Result == Result.UpdatedSuccessfully)
{
#region Save DAR
DARModel objDAR = new DARModel();
objDAR.ActivityDetails = DarMessage.UpdateeFleetDriver(objeFleetDriverModel.LocationName);
objDAR.LocationId = objeFleetDriverModel.LocationID;
objDAR.UserId = objeFleetDriverModel.UserID;
objDAR.ModifiedBy = objeFleetDriverModel.UserID;
objDAR.ModifiedOn = DateTime.UtcNow;
objDAR.TaskType = (long)TaskTypeCategory.UpdateeFleetDriver;
Result result = _ICommonMethod.SaveDAR(objDAR);
#endregion Save DAR
}
}
return(objeFleetDriverModel);
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public eFleetDriverModel SaveEfleetDriver(eFleetDriverModel objeFleetDriverModel)", "Exception While saving Driver request.", objeFleetDriverModel);
throw;
}
}
public ActionResult SaveAssignLocationandRolesPermissions(PermissionDetailsModel objPermissionDetails)
{
DARModel objDAR = null;
eTracLoginModel ObjLoginModel = null;
try
{
AlertMessageClass ObjAlertMessageClass = new AlertMessageClass();
if (objPermissionDetails != null && objPermissionDetails.LocationId > 0 && objPermissionDetails.UserIds != null)
{
if (Session["eTrac"] != null)
{
ObjLoginModel = (eTracLoginModel)(Session["eTrac"]);
if (ObjLoginModel != null)
{
objPermissionDetails.CreatedBy = ObjLoginModel.UserId;
objPermissionDetails.CreatedOn = DateTime.UtcNow;
objDAR = new DARModel();
objDAR.LocationId = objPermissionDetails.LocationId;
objDAR.UserId = ObjLoginModel.UserId;
objDAR.CreatedBy = ObjLoginModel.UserId;
objDAR.CreatedOn = DateTime.UtcNow;
objDAR.TaskType = (long)TaskTypeCategory.AssignLocationPermission;
objPermissionDetails.FullName = objPermissionDetails.FullName.ToTitleCase();
switch (objPermissionDetails.UserType)
{
case 2:
{
objDAR.ActivityDetails = DarMessage.LocationAssignedManager(objPermissionDetails.FullName, objPermissionDetails.LocationName);
break;
}
case 3:
{
objDAR.ActivityDetails = DarMessage.LocationAssignedEmployee(objPermissionDetails.FullName, objPermissionDetails.LocationName);
break;
}
case 4:
{
objDAR.ActivityDetails = DarMessage.LocationAssigned(objPermissionDetails.FullName, objPermissionDetails.LocationName);
break;
}
case 5:
{
objDAR.ActivityDetails = DarMessage.LocationAssigned(objPermissionDetails.FullName, objPermissionDetails.LocationName);
break;
}
case 6:
{
objDAR.ActivityDetails = DarMessage.LocationAssignedAdmin(objPermissionDetails.FullName, objPermissionDetails.LocationName);
break;
}
default:
{
objDAR.ActivityDetails = "Something went wrong";
break;
}
}
var result = _ICommonMethod.AssignLocationRoles(objPermissionDetails, objDAR, ObjLoginModel.UserId);
if (result == Result.Completed)
{
ViewBag.Message = CommonMessage.SaveSuccessMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Success;
ModelState.Clear();
}
else
{
ViewBag.Message = CommonMessage.FailureMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;// store the failure message in tempdata to display in view.
}
return(Json(new { Message = ViewBag.Message, AlertMessageClass = ViewBag.AlertMessageClass }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("NotRegistered"));
}
}
else
{
return(Json("Session Expired !"));
}
}
else
{
ViewBag.Message = CommonMessage.FillAllRequired();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;// store the failure message in tempdata to display in view.
}
return(Json(new { Message = ViewBag.Message, AlertMessageClass = ViewBag.AlertMessageClass }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
ViewBag.Message = CommonMessage.FailureMessage();
ViewBag.AlertMessageClass = "text-danger";// store the failure message in tempdata to display in view.
return(Json(new { Message = ViewBag.Message, AlertMessageClass = ViewBag.AlertMessageClass }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Index(QRCModel ObjUserModel)
{
DARModel objDAR = null; long LocId = 0;
eTracLoginModel ObjLoginModel = null;
if (Session["eTrac"] != null)
{
ObjLoginModel = (eTracLoginModel)(Session["eTrac"]);
}
if (Session["eTrac_SelectedDasboardLocationID"] != null)
{
LocId = (long)Session["eTrac_SelectedDasboardLocationID"];
}
try
{
//if (ModelState.IsValid)
//{
if (ObjUserModel != null && ObjUserModel.UserModel != null) //&& ObjUserModel.UserModel.UserId == 0
{
objDAR = new DARModel();
objDAR.LocationId = ObjLoginModel.LocationID;
objDAR.UserId = ObjLoginModel.UserId;
objDAR.CreatedBy = ObjLoginModel.UserId;
objDAR.CreatedOn = DateTime.UtcNow;
if (ObjUserModel.UserModel.UserId == 0)
{
#region password
if (!String.IsNullOrEmpty(ObjUserModel.UserModel.Password))
{
ObjUserModel.UserModel.Password = Cryptography.GetEncryptedData(ObjUserModel.UserModel.Password, true);
}
#endregion password
ObjUserModel.UserModel.CreatedBy = ObjLoginModel.UserId;
ObjUserModel.UserModel.CreatedDate = DateTime.UtcNow;
ObjUserModel.UserModel.IsDeleted = false;
ObjUserModel.UserModel.IdleTimeLimit = DateTime.UtcNow.SetTime(0, 30, 0, 0);//Added By Bhushan on 07/06/2015 for by deafult IDLE Time set
objDAR.TaskType = (long)TaskTypeCategory.UserCreation;
objDAR.ActivityDetails = DarMessage.NewEmployeeCreatedDar(ObjLoginModel.Location);
}
else
{
ObjUserModel.UserModel.ModifiedBy = ObjLoginModel.UserId;
ObjUserModel.UserModel.ModifiedDate = DateTime.UtcNow;
ObjUserModel.UserModel.IsDeleted = false;
if (!String.IsNullOrEmpty(ObjUserModel.UserModel.Password))
{
ObjUserModel.UserModel.Password = Cryptography.GetEncryptedData(ObjUserModel.UserModel.Password, true);
}
objDAR.TaskType = (long)TaskTypeCategory.UserUpdate;
objDAR.ActivityDetails = DarMessage.EmployeeUpdatedDar(ObjLoginModel.Location);
}
if (ObjUserModel.UserModel.ProfileImage != null)
{
string ImageName = ObjLoginModel.UserId + "_" + DateTime.Now.Ticks.ToString() + "_" + ObjUserModel.UserModel.ProfileImage.FileName.ToString();
CommonHelper obj_CommonHelper = new CommonHelper();
obj_CommonHelper.UploadImage(ObjUserModel.UserModel.ProfileImage, Server.MapPath(ConfigurationManager.AppSettings["ProfilePicPath"]), ImageName);
ObjUserModel.UserModel.ProfileImageFile = ImageName;
}
long QRCID = 0;
Result result = _IClientManager.SaveClient(ObjUserModel.UserModel, out QRCID, true, objDAR, LocId, ObjLoginModel.UserId, "");
if (result == Result.Completed)
{
var abc = _ICommonMethod.GetLocationDetailsById(ObjLoginModel.LocationID);
EmailHelper objEmailHelper = new EmailHelper();
objEmailHelper.emailid = ObjUserModel.UserModel.UserEmail;
objEmailHelper.LocationName = abc.LocationName;
objEmailHelper.LocAddress = ObjUserModel.UserModel.Address.Address1; // here locAddress means user Address
objEmailHelper.UserName = ObjUserModel.UserModel.AlternateEmail;
objEmailHelper.UserType = ObjUserModel.UserModel.UserType;
objEmailHelper.FirstName = ObjUserModel.UserModel.FirstName;
objEmailHelper.LastName = ObjUserModel.UserModel.LastName;
objEmailHelper.Password = Cryptography.GetDecryptedData(ObjUserModel.UserModel.Password, true);
objEmailHelper.MailType = "CreateNewUser";
HostingPrefix = HostingPrefix + "Manager/Employee?usr="******"ITAdministrator");//return RedirectToAction("Create ", "GlobalAdmin");
ObjUserModel = _ICommonMethod.LoadInvitedUser(string.Empty);
}
else if (result == Result.DuplicateRecord)
{
ViewBag.Message = CommonMessage.DuplicateRecordEmailIdMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Info; // store the message for successful in tempdata to display in view.
}
else if (result == Result.UpdatedSuccessfully)
{
ViewBag.Message = CommonMessage.UpdateSuccessMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Success;// store the message for successful in tempdata to display in view.
ModelState.Clear();
//return RedirectToAction("index", "GlobalAdmin");
ObjUserModel = _ICommonMethod.LoadInvitedUser(string.Empty);
}
else
{
ViewBag.Message = CommonMessage.FailureMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;// store the failure message in tempdata to display in view.
}
}
else
{
ViewBag.Message = CommonMessage.InvalidEntry();
}
}
catch (Exception ex)
{
ViewBag.Message = ex.Message;
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;
}
finally
{
ViewBag.Country = _ICommonMethod.GetAllcountries();
ViewBag.JobTitleList = _ICommonMethod.GetGlobalCodeData("UserJobTitle");
ViewBag.LocationList = _IGlobalAdmin.GetAllLocationNew();
//System.Data.Entity.Core.Objects.ObjectParameter paramTotalRecords = new System.Data.Entity.Core.Objects.ObjectParameter("TotalRecords", typeof(int));
//ObjUserModel.JobTitleList = _ICommonMethod.GetGlobalCodeData("JOBTITLE");
//ObjUserModel.LocationList = _IGlobalAdmin.GetAllLocationList(0, "GetAllLocation", 1, 10000, "LocationName", "desc", "", paramTotalRecords);
//paramTotalRecords = null;
}
ViewBag.UpdateMode = false;
//ObjUserModel.UserModel = _IClientManager.GetClientByID(ObjUserModel.UserModel.UserId, "GetUserByID", null, null, null, null, null);
//1 USERTYPE Global Admin
//2 USERTYPE Manager
//3 USERTYPE Employee
//4 USERTYPE Client
//5 USERTYPE IT Administrator
//6 USERTYPE Administrator
//137 USERTYPE Vendor User
//138 USERTYPE Guest User
//switch (ObjLoginModel.UserRoleId)
//{
// case 1:
// {
// //return View("", ObjUserModel);
// return RedirectToAction("Index", "GlobalAdmin");
// } break;
// case 2:
// { } break;
// case 3:
// { } break;
// case 4:
// { } break;
// case 5:
// { } break;
// case 6:
// { } break;
//}
return(View("Employee", ObjUserModel));
}
//CommonMethodAdmin ObjCommonMethodAdmin = new CommonMethodAdmin();
//Result result;
//nagendra nov 13 2014
public Result SaveClient(UserModel objUserModel, out long qrcId, bool IsManagerRegistration, DARModel objDARModel)
{
try
{
qrcId = 0;
//QRCName = "Manager"; SpecialNotes = "Manager added successfully";
ObjUserRepository = new UserRepository();
ObjManagerUser = new UserRegistration();
objGlobalCodesRepository = new GlobalCodesRepository();
if (CheckDuplicateUser(objUserModel.UserEmail.Trim(), objUserModel.UserId, out qrcId, objUserModel.AlternateEmail, objUserModel.EmployeeID))
{
objUserModel.IsEmailVerify = true;
objUserModel.IsLoginActive = true;
objUserModel.SubscriptionEmail = objUserModel.UserEmail;
if (objUserModel.Gender != null)
{
objUserModel.Gender = objUserModel.Gender == 1 ? objGlobalCodesRepository.GetSingleOrDefault(g => g.CodeName == "Male").GlobalCodeId : objGlobalCodesRepository.GetSingleOrDefault(g => g.CodeName == "Female").GlobalCodeId;
}
using (TransactionScope TransScope = new TransactionScope())
{
if (objUserModel.UserId == 0)
{
ObjManagerUser.ProfileImage = objUserModel.ProfileImageFile;
AutoMapper.Mapper.CreateMap <UserModel, UserRegistration>();
ObjManagerUser = AutoMapper.Mapper.Map(objUserModel, ObjManagerUser);
ObjManagerUser.ProfileImage = objUserModel.ProfileImageFile;
//if (ObjManagerUser.ProfileImage != null)
// ObjManagerUser.ProfileImage = (!string.IsNullOrEmpty(objUserModel.ProfileImage.FileName) ? objUserModel.ProfileImage.FileName : "no-profile-pic.jpg");
ObjUserRepository.Add(ObjManagerUser);
//ObjUserRepository.SaveChanges();
//if (ObjManagerUser != null)
//{
// //ObjManagerUser.Password = (string.IsNullOrEmpty(ObjManagerUser.Password)) ? Cryptography.GetDecryptedData(0.ToString(), true) : ObjManagerUser.Password;
// if (_ICommonMethod.GenerateQRCode(QRCName, ManageManagerMODULE, null, null, QRCDefaultSizeID, QRCTYPEID, SpecialNotes, objUserModel.CreatedBy, out QRCID))
// { ObjUserRepository.Add(ObjManagerUser); }
//}
if (ObjManagerUser.UserId > 0)
{
objUserModel.Address.UserId = ObjManagerUser.UserId;
objAddressManager.SaveAddress(objUserModel.Address);
if (objUserModel.UserType == Convert.ToInt64(UserType.GlobalAdmin, CultureInfo.InvariantCulture) ||
objUserModel.UserType == Convert.ToInt64(UserType.ITAdministrator, CultureInfo.InvariantCulture) ||
objUserModel.UserType == Convert.ToInt64(UserType.Administrator, CultureInfo.InvariantCulture)
//Commented by Bhushan on 30/05/2016 for no need to check manager bcoz in below method(objBB.AssignRoleAndPermission) code is doing same
// || objUserModel.UserType == Convert.ToInt64(UserType.Manager, CultureInfo.InvariantCulture)
)
{
_ICommonMethodAdmin.AssignLocationToAdminUser(objUserModel.Location, ObjManagerUser.UserId);
}
Result objResult = _ICommonMethod.SaveDAR(objDARModel);
TransScope.Complete();
return(Result.Completed);
}
else
{
return(Result.Failed);
}
}
else
{
UpdateUser(objUserModel, out qrcId, IsManagerRegistration);
objUserModel.Address.UserId = objUserModel.UserId;
objAddressManager.SaveAddress(objUserModel.Address);
Result objResult = _ICommonMethod.SaveDAR(objDARModel);
TransScope.Complete();
return(Result.UpdatedSuccessfully);
}
}
}
else
{
return(Result.DuplicateRecord);
}
}
catch (Exception)
{ throw; }
}
public Result SaveClientNewUserRegistrationforAll(UserModel objUserModel, out long qrcId, bool IsManagerRegistration, DARModel objDARModel, long locationId, long createdBy, string action)
{
try
{
qrcId = 0;
ObjUserRepository = new UserRepository();
ObjManagerUser = new UserRegistration();
objGlobalCodesRepository = new GlobalCodesRepository();
if (CheckDuplicateUser(objUserModel.UserEmail.Trim(), objUserModel.UserId, out qrcId, objUserModel.AlternateEmail, objUserModel.EmployeeID))
{
objUserModel.IsEmailVerify = true;
objUserModel.IsLoginActive = true;
objUserModel.SubscriptionEmail = objUserModel.UserEmail;
using (TransactionScope TransScope = new TransactionScope())
{
if (objUserModel.UserId == 0)
{
objUserModel.FirstName = objUserModel.FirstName.ToTitleCase();
objUserModel.LastName = objUserModel.LastName.ToTitleCase();
AutoMapper.Mapper.CreateMap <UserModel, UserRegistration>();
string DOB = objUserModel.DOB;
objUserModel.DOB = null;
ObjManagerUser = AutoMapper.Mapper.Map(objUserModel, ObjManagerUser);
ObjManagerUser.ProfileImage = (objUserModel.ProfileImage != null) ? objUserModel.ProfileImageFile : "no-profile-pic.jpg";
if (!string.IsNullOrEmpty(DOB))
{
ObjManagerUser.DOB = Convert.ToDateTime(DOB, CultureInfo.InvariantCulture);
}
ObjManagerUser.IsEmailVerify = false; //added by vijay sahu 12 june 2015 , by default it should not be true
ObjManagerUser.IsLoginActive = false;
//Added By Bhushan Dod on 04/Sep/2016 for User type of user.
ObjManagerUser.UserType = objUserModel.SelectedUserType;
ObjUserRepository.Add(ObjManagerUser);
if (ObjManagerUser.UserId > 0)
{
objUserModel.Address.UserId = ObjManagerUser.UserId;
objAddressManager.SaveAddress(objUserModel.Address);
if (objUserModel.SelectedUserType == Convert.ToInt64(UserType.GlobalAdmin, CultureInfo.InvariantCulture) ||
objUserModel.SelectedUserType == Convert.ToInt64(UserType.ITAdministrator, CultureInfo.InvariantCulture) ||
objUserModel.SelectedUserType == Convert.ToInt64(UserType.Administrator, CultureInfo.InvariantCulture)
//Commented by Bhushan on 30/05/2016 for no need to check manager bcoz objBB.AssignRoleAndPermission code is doing same
// || objUserModel.UserType == Convert.ToInt64(UserType.Manager, CultureInfo.InvariantCulture)
)
{
_ICommonMethodAdmin.AssignLocationToAdminUser(locationId, ObjManagerUser.UserId);
}
else if (objUserModel.SelectedUserType == Convert.ToInt64(UserType.Manager, CultureInfo.InvariantCulture))
{
_ICommonMethodAdmin.AssignLocationToManagerUser(locationId, ObjManagerUser.UserId);
}
else if (objUserModel.SelectedUserType == Convert.ToInt64(UserType.Employee, CultureInfo.InvariantCulture))
{
_ICommonMethodAdmin.AssignLocationToEmployeeUser(locationId, ObjManagerUser.UserId);
}
Result objResult = _ICommonMethod.SaveDAR(objDARModel);
////this block is used for assigning roles to the users..
{
WorkOrderEMS.BusinessLogic.Managers.Common_B objBB = new WorkOrderEMS.BusinessLogic.Managers.Common_B();
byte a = objBB.AssignRoleAndPermission(ObjManagerUser.UserId, objUserModel.UserType, locationId, createdBy, "");
}
if (objUserModel.SelectedServicesID != "" && objUserModel.SelectedServicesID != null && objUserModel.SelectedServicesID.Trim() != "")
{
GlobalAdminManager ObjGlobalAdminManager = new GlobalAdminManager();
var userServicesID = objUserModel.SelectedServicesID.Split(',');
if (userServicesID != null && userServicesID.Length > 0)
{
foreach (var service in userServicesID)
{
if (service != null && !string.IsNullOrEmpty(service) && Convert.ToInt64(service, CultureInfo.InvariantCulture) > 0)
{
long WidgetId = Convert.ToInt64(service, CultureInfo.InvariantCulture);
var IsInserted = CommonMethodManager.AddPermissionDetail(WidgetId, ObjManagerUser.UserId, objUserModel.SelectedLocationId.Value);
}
}
//Added By Bhushan Dod on 07/06/2016 for bydefault setting when location created according to loc services.
ObjGlobalAdminManager.SaveByDefaultWidgetSetting(locationId, objUserModel.SelectedServicesID, ObjManagerUser.UserId);
}
}
//COMMENTED BY BHUSHAN DOD FOR MULTIPLE ENTRIES INSERTED IN ADMINLOCATIONMAPPING
//if (objUserModel.UserType == 6) // only for admin user mapping with location.
//{
// _ICommonMethodAdmin.AssignLocationToAdminUser(locationId, ObjManagerUser.UserId);
//}
//////////////////if (objUserModel.UserType == 3) // only for admin user mapping with location.
//////////////////{
////////////////// using (workorderEMSEntities Context = new workorderEMSEntities())
////////////////// {
////////////////// EmployeeLocationMappingRepository objmapping = new EmployeeLocationMappingRepository();
////////////////// objmapping.DeleteAll(x => x.EmployeeUserId == objUserModel.UserId && x.LocationId == locationId);
////////////////// EmployeeLocationMapping MapEntity = new EmployeeLocationMapping();
////////////////// MapEntity.LocationId = locationId;
////////////////// MapEntity.EmployeeUserId = objUserModel.UserId;
////////////////// MapEntity.ModifiedBy = createdBy;
////////////////// MapEntity.CreatedBy = createdBy;
////////////////// MapEntity.CreatedOn = DateTime.Now;
////////////////// objmapping.Add(MapEntity);
////////////////// objmapping.SaveChanges();
////////////////// }
//////////////////}
//_ICommonMethod.GetAdminByIdCode
objUserModel.UserId = ObjManagerUser.UserId;
TransScope.Complete();
return(Result.Completed);
}
else
{
return(Result.Failed);
}
}
else
{
UpdateUser(objUserModel, out qrcId, IsManagerRegistration);
objUserModel.Address.UserId = objUserModel.UserId;
objAddressManager.SaveAddress(objUserModel.Address);
Result objResult = _ICommonMethod.SaveDAR(objDARModel);
TransScope.Complete();
return(Result.UpdatedSuccessfully);
}
}
}
else
{
return(Result.DuplicateRecord);
}
}
catch (Exception)
{ throw; }
}
public ActionResult Create(QRCModel ObjUserModel)
{
DARModel objDAR = null;
try
{
eTracLoginModel ObjLoginModel = null;
long LocId = 0;
if (Session["eTrac"] != null)
{
ObjLoginModel = (eTracLoginModel)(Session["eTrac"]);
}
if (Session["eTrac_SelectedDasboardLocationID"] != null)
{
LocId = (long)Session["eTrac_SelectedDasboardLocationID"];
}
//if (ModelState.IsValid)
//{
if (ObjUserModel != null && ObjUserModel.UserModel != null) //&& ObjUserModel.UserModel.UserId == 0
{
if (ObjUserModel.UserModel.UserId == 0)
{
#region password
//ObjUserModel.UserModel.Password = _ICommonMethod.CreateRandomPassword();
/*
* ObjUserModel.UserModel.Password = Guid.NewGuid().ToString();
* ObjUserModel.UserModel.Password = ObjUserModel.UserModel.Password.Length > pwdmaxlendth ? ObjUserModel.UserModel.Password.Substring(0, pwdmaxlendth) : ObjUserModel.UserModel.Password;
* ObjUserModel.UserModel.Password = Cryptography.GetEncryptedData(ObjUserModel.UserModel.Password, true);
* //ObjUserModel.UserModel.Password = (!string.IsNullOrEmpty(ObjUserModel.UserModel.Password)) ? Cryptography.GetEncryptedData(ObjUserModel.UserModel.Password, true) : ObjUserModel.UserModel.Password;
*/
if (!String.IsNullOrEmpty(ObjUserModel.UserModel.Password))
{
ObjUserModel.UserModel.Password = Cryptography.GetEncryptedData(ObjUserModel.UserModel.Password, true);
}
#endregion password
ObjUserModel.UserModel.CreatedBy = ObjLoginModel.UserId;
ObjUserModel.UserModel.CreatedDate = DateTime.UtcNow;
ObjUserModel.UserModel.IsDeleted = false;
objDAR = new DARModel();
objDAR.LocationId = ObjLoginModel.LocationID;
objDAR.UserId = ObjLoginModel.UserId;
objDAR.CreatedBy = ObjLoginModel.UserId;
objDAR.CreatedOn = DateTime.UtcNow;
objDAR.TaskType = (long)TaskTypeCategory.UserCreation;
objDAR.ActivityDetails = DarMessage.NewITAdministratorCreatedDar(ObjLoginModel.Location);
}
else
{
ObjUserModel.UserModel.ModifiedBy = ObjLoginModel.UserId;
ObjUserModel.UserModel.ModifiedDate = DateTime.UtcNow;
ObjUserModel.UserModel.IsDeleted = false;
if (!String.IsNullOrEmpty(ObjUserModel.UserModel.Password))
{
ObjUserModel.UserModel.Password = Cryptography.GetEncryptedData(ObjUserModel.UserModel.Password, true);
}
objDAR = new DARModel();
objDAR.LocationId = ObjLoginModel.LocationID;
objDAR.UserId = ObjLoginModel.UserId;
objDAR.ModifiedBy = ObjLoginModel.UserId;
objDAR.ModifiedOn = DateTime.UtcNow;
objDAR.TaskType = (long)TaskTypeCategory.UserUpdate;
objDAR.ActivityDetails = DarMessage.ITAdministratorUpdatedDar(ObjLoginModel.Location);
}
if (ObjUserModel.UserModel.ProfileImage != null)
{
string ImageName = ObjLoginModel.UserId + "_" + DateTime.Now.Ticks.ToString() + "_" + ObjUserModel.UserModel.ProfileImage.FileName.ToString();
CommonHelper obj_CommonHelper = new CommonHelper();
obj_CommonHelper.UploadImage(ObjUserModel.UserModel.ProfileImage, Server.MapPath(ConfigurationManager.AppSettings["ProfilePicPath"]), ImageName);
ObjUserModel.UserModel.ProfileImageFile = ImageName;
}
long QRCID = 0;
//Result result = _IClientManager.SaveClient(ObjUserModel.UserModel, out QRCID, true, objDAR); // commented by vijay sahu on 18 feb 2015
//Updated By Bhushan Dod on 30/05/2016 for location id parameter not send properly send 0 so need to update location id.
//Result result = _IClientManager.SaveClient(ObjUserModel.UserModel, out QRCID, true, objDAR, 0, ObjLoginModel.UserId, "");//added by vijay sahu on15 feb 2015
Result result = _IClientManager.SaveClient(ObjUserModel.UserModel, out QRCID, true, objDAR, ObjLoginModel.LocationID, ObjLoginModel.UserId, "");
if (result == Result.Completed)
{
//var LocationDetails = _ICommonMethod.GetLocationDetailsById(LocId);
#region EmailHelper
//Common.CommonController myCommonController = new Common.CommonController(_ICommonMethod, _IGlobalAdmin, _IVehicleRegistration, _IUser, _IWorkRequestAssignment, _IClientManager);
#region Email to IT Admin User
//if (ObjUserModel.UserModel.UserId != 0)
//{
// ObjUserModel.UserModel.Location = LocId;
// myCommonController.SendEmailToUser(ObjUserModel.UserModel, LocationDetails.LocationName, LocationDetails.Address1, LocationDetails.Address2, ObjLoginModel.UserId);
//}
var abc = _ICommonMethod.GetLocationDetailsById(LocId);
EmailHelper objEmailHelper = new EmailHelper();
objEmailHelper.emailid = ObjUserModel.UserModel.UserEmail;
objEmailHelper.UserName = ObjUserModel.UserModel.AlternateEmail;
objEmailHelper.UserType = ObjUserModel.UserModel.UserType;
objEmailHelper.FirstName = ObjUserModel.UserModel.FirstName;
objEmailHelper.LastName = ObjUserModel.UserModel.LastName;
objEmailHelper.Password = Cryptography.GetDecryptedData(ObjUserModel.UserModel.Password, true);
objEmailHelper.LocationName = abc.LocationName;
objEmailHelper.LocAddress = ObjUserModel.UserModel.Address.Address1; // here locAddress means user Address
objEmailHelper.MailType = "CreateNewUser";
string HostingPrefix = Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["hostingPrefix"], System.Globalization.CultureInfo.InvariantCulture);
HostingPrefix = HostingPrefix + "Manager/Employee?usr="******"REGISTRATIONMAIL";
//// string HostingPrefix = Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["hostingPrefix"]);
//// /*
//// string UserLink = ""; //Enum.TryParse(userType, out _UserType); //long _userType = (long)_UserType;
//// long _userType = ObjUserModel.UserModel.UserType;
//// switch (_userType)
//// {
//// case (long)UserType.Manager:
//// UserLink = "GlobalAdmin/Manager";
//// break;
//// case (long)UserType.Employee:
//// UserLink = "Manager/Employee";
//// break;
//// case (long)UserType.Client:
//// UserLink = "Client/Client";
//// break;
//// default:
//// UserLink = "Error";
//// break;
//// }
//// HostingPrefix = HostingPrefix + UserLink + "?usr="******"?vrfy=" + Cryptography.GetEncryptedData(ObjUserModel.UserModel.Password.ToString(), true);
//// objEmailHelper.RegistrationLink = HostingPrefix;
//// #region comments
//// // objEmailHelper.RegistrationLink = DomainName + "/?flag=Registration&id=" + System.Web.HttpUtility.UrlPathEncode(Cryptography.GetEncryptedData(UserId.ToString(), true));
//// //objEmailHelper.RegistrationLink = DomainName + "/?flag=Registration&id=" + System.Web.HttpUtility.UrlPathEncode(Cryptography.GetEncryptedData(UserId.ToString(), true));
//// // objEmailHelper.RegistrationCode = objRegistrationModel.EmailVerifcationCode;
//// #endregion comments
//// objEmailHelper.SendEmailwithTemplate();
//// //return Result.EmailSendSuccessfully;
////}
#endregion EmailHelper
/* test mail code call*/
ViewBag.Message = CommonMessage.SaveSuccessMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Success;
ModelState.Clear();
//return View("ITAdministrator");//return RedirectToAction("Create ", "GlobalAdmin");
ObjUserModel = _ICommonMethod.LoadInvitedUser(string.Empty);
}
else if (result == Result.DuplicateRecord)
{
ViewBag.Message = CommonMessage.DuplicateRecordEmailIdUserNameEmpIdMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Info; // store the message for successful in tempdata to display in view.
}
else if (result == Result.UpdatedSuccessfully)
{
ViewBag.Message = CommonMessage.UpdateSuccessMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Success;// store the message for successful in tempdata to display in view.
ModelState.Clear();
//return RedirectToAction("index", "GlobalAdmin");
ObjUserModel = _ICommonMethod.LoadInvitedUser(string.Empty);
}
else
{
ViewBag.Message = CommonMessage.FailureMessage();
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;// store the failure message in tempdata to display in view.
}
}
else
{
ViewBag.Message = CommonMessage.InvalidEntry();
}
}
catch (Exception ex)
{
ViewBag.Message = ex.Message;
ViewBag.AlertMessageClass = ObjAlertMessageClass.Danger;
}
finally
{
ViewBag.Country = _ICommonMethod.GetAllcountries();
ViewBag.JobTitleList = _ICommonMethod.GetGlobalCodeData("UserJobTitle");
ViewBag.LocationList = _IGlobalAdmin.GetAllLocationNew();
/*
* System.Data.Entity.Core.Objects.ObjectParameter paramTotalRecords = new System.Data.Entity.Core.Objects.ObjectParameter("TotalRecords", typeof(int));
* ObjUserModel.JobTitleList = _ICommonMethod.GetGlobalCodeData("JOBTITLE");
* ObjUserModel.LocationList = _IGlobalAdmin.GetAllLocationList(0, "GetAllLocation", 1, 10000, "LocationName", "desc", "", paramTotalRecords);
* paramTotalRecords = null;
*/
}
ViewBag.UpdateMode = false;
//ObjUserModel.UserModel = _IClientManager.GetClientByID(ObjUserModel.UserModel.UserId, "GetUserByID", null, null, null, null, null);
return(View("ITAdministrator", ObjUserModel));
}
/// <summary>
/// To Delete the User
/// </summary>
/// <CreatedBy>Manoj Jaswal</CreatedBy>
/// <CreatedDate>2015-03-05</CreatedDate>
/// <param name="UserId"></param>
/// <param name="DeletedBy"></param>
public Result DeleteUser(long UserId, long DeletedBy, DARModel objDAR)
{
long UserType = 0;
Result result;
long count = 0;
try
{
ObjUserRepository = new UserRepository();
objCommonMethodManager = new CommonMethodManager();
UserRegistration obj_UserRegistration = ObjUserRepository.GetAll(x => x.UserId == UserId).FirstOrDefault();
if (obj_UserRegistration != null)
{
UserType = obj_UserRegistration.UserType;
using (workorderEMSEntities context = new workorderEMSEntities())
{
if (UserType == 6)
{
count = (from o in context.AdminLocationMappings
join ur in context.UserRegistrations
on o.AdminUserId equals ur.UserId
where
ur.IsLoginActive == true &&
ur.IsEmailVerify == true &&
ur.IsDeleted == false &&
ur.UserId == UserId &&
o.IsDeleted == false
select o.AdminUserId
).Count();
}
else if (UserType == 2)
{
count = (from o in context.ManagerLocationMappings
join ur in context.UserRegistrations
on o.ManagerUserId equals ur.UserId
where
ur.IsLoginActive == true &&
ur.IsEmailVerify == true &&
ur.IsDeleted == false &&
o.IsDeleted == false &&
ur.UserId == UserId
select o.ManagerUserId
).Count();
}
}
if (count == 0)
{
obj_UserRegistration.IsDeleted = true;
obj_UserRegistration.IsLoginActive = false;
obj_UserRegistration.DeletedDate = DateTime.UtcNow;
obj_UserRegistration.DeletedBy = DeletedBy;
ObjUserRepository.SaveChanges();
objDAR.TaskType = (long)TaskTypeCategory.UserDelete;
objDAR.ActivityDetails = DarMessage.UserDeleteDar(obj_UserRegistration.FirstName + ' ' + obj_UserRegistration.LastName);
#region Save DAR
result = objCommonMethodManager.SaveDAR(objDAR);
#endregion Save DAR
return(Result.Delete);
}
else
{
return(Result.ExistRecord);
}
}
else
{
return(Result.DoesNotExist);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>Save eFleet Incident
/// <CreatedBy>Bhushan Dod</CreatedBy>
/// <CreatedFor>InsertVehicleIncident</CreatedFor>
/// <CreatedOn>September-15-2017</CreatedOn>
/// </summary>
/// <param name="eFleetIncidentModel"></param>
/// <returns></returns>
public ServiceResponseModel <string> InsertVehicleIncident(eFleetIncidentModel objModel)
{
var objReturnModel = new ServiceResponseModel <string>();
try
{
var objeFleetVehicleIncidentRepository = new eFleetVehicleIncidentRepository();
var Obj = new eFleetVehicleIncident();
var objDAR = new DARModel();
AutoMapper.Mapper.CreateMap <eFleetIncidentModel, eFleetVehicleIncident>();
Obj = AutoMapper.Mapper.Map(objModel, Obj);
Obj.CreatedBy = objModel.UserId;
Obj.CreatedDate = DateTime.UtcNow;
Obj.IsDeleted = false;
objeFleetVehicleIncidentRepository.Add(Obj);
if (Obj.IncidentID > 0)
{
// objDAR.ActivityDetails = objModel.ActivityDetails;
objDAR.ActivityDetails = DarMessage.RegisterNeweFleetIncidentVehicle(objModel.LocationName);
objDAR.LocationId = objModel.LocationID;
// objDAR.TaskType = objModel.TaskType;
objDAR.TaskType = (long)TaskTypeCategory.EfleetIncidentSubmission;
objDAR.CreatedBy = objModel.UserId;
objDAR.CreatedOn = DateTime.UtcNow;
objDAR.DeletedBy = null;
objDAR.DeletedOn = null;
objDAR.IsDeleted = false;
objDAR.IsManual = false;
objDAR.ModifiedBy = null;
objDAR.ModifiedOn = null;
objDAR.UserId = objModel.UserId;
objDAR.StartTime = objModel.AccidentDate.ToString();
objDAR.EndTime = DateTime.UtcNow.ToString();
// objDARRepository.Add(objDAR);
Result result = _ICommonMethod.SaveDAR(objDAR);
#region Email
var objEmailLogRepository = new EmailLogRepository();
var objEmailReturn = new List <EmailToManagerModel>();
var objListEmailog = new List <EmailLog>();
var objTemplateModel = new TemplateModel();
workorderEMSEntities db = new workorderEMSEntities();
if (result == Result.Completed)
{
objEmailReturn = objEmailLogRepository.SendEmailToManagerForeFleetInspection(objModel.LocationID, objModel.UserId).Result;
//Code added by Bhu on 14 Dec 2017 for sending email to [email protected]. This is common MRA for risk manager.
var objEmailToManagerModel = new EmailToManagerModel();
objEmailToManagerModel.LocationID = objModel.LocationID;
objEmailToManagerModel.LocationName = objModel.LocationName;
objEmailToManagerModel.ManagerEmail = "*****@*****.**";
objEmailToManagerModel.ManagerName = "Team";
objEmailToManagerModel.ManagerUserId = 3; //admin user id for need to track email log
objEmailToManagerModel.RequestBy = 3; //admin user id for need to track email log
objEmailToManagerModel.UserName = "******";
objEmailReturn.Add(objEmailToManagerModel);
}
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;
//objEmailHelper.DriverNameforFueling = objModel.DriverName;
/// objEmailHelper.FuelType = (from gc in db.GlobalCodes where gc.GlobalCodeId == objModel.FuelType select gc.CodeName).FirstOrDefault();
objEmailHelper.IncidentDescription = objModel.Description;
if (objModel.Preventability == true)
{
objEmailHelper.Prevenatability = "Yes";
}
else
{
objEmailHelper.Prevenatability = "No";
}
objEmailHelper.NumberOfInjuries = objModel.NumberOfInjuries;
objEmailHelper.City = objModel.City;
objEmailHelper.VehicleNumber = objModel.VehicleNumber;
objEmailHelper.LocationName = objModel.LocationName;
objEmailHelper.UserName = item.UserName;
objEmailHelper.QrCodeId = objModel.QRCodeID;
objEmailHelper.AccidentDate = objModel.AccidentDate.ToString();
//objEmailHelper.InfractionStatus = obj.Status;
objEmailHelper.MailType = "EfleetIncidentForService";
objEmailHelper.SentBy = item.RequestBy;
objEmailHelper.LocationID = item.LocationID;
objEmailHelper.TimeAttempted = DateTime.UtcNow.ToMobileClientTimeZone(objTemplateModel.TimeZoneName, objTemplateModel.TimeZoneOffset, objTemplateModel.IsTimeZoneinDaylight, false).ToString();
IsSent = objEmailHelper.SendEmailWithTemplate();
if (item.DeviceId != null && item.DeviceId != "")
{
//Push Notification
string message = PushNotificationMessages.eFleetIncidentForServiceReported(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 (Obj.IncidentID > 0)
{
objReturnModel.Response = Convert.ToInt32(ServiceResponse.SuccessResponse, CultureInfo.InvariantCulture);
objReturnModel.Message = CommonMessage.Successful();
}
}
}
catch (Exception ex)
{
WorkOrderEMS.BusinessLogic.Exception_B.Exception_B.exceptionHandel_Runtime(ex, "ServiceResponseModel<string> InsertVehicleIncident(eFleetIncidentModel objModel)", "while insert eFleet vehicle incident", objModel);
objReturnModel.Message = ex.Message;
objReturnModel.Response = Convert.ToInt32(ServiceResponse.ExeptionResponse, CultureInfo.CurrentCulture);
objReturnModel.Data = null;
}
return(objReturnModel);
}
/// <summary>
/// Created By : Ashwajit bansod
/// Created Date : 12-OCT-2018
/// Created For : To Save Bill
/// </summary>
/// <param name="objBillDataServiceModel"></param>
/// <returns></returns>
public bool SaveBillDetails(BillDataServiceModel objBillDataServiceModel)
{
bool isBillSaved = false;
string Action = "";
string DeliverStatus = "";
var objDAR = new DARModel();
var CommonManager = new CommonMethodManager();
string LocationName = string.Empty;
string UserName = string.Empty;
try
{
if (objBillDataServiceModel != null && objBillDataServiceModel.VendorId > 0 &&
objBillDataServiceModel.LocationId > 0 && objBillDataServiceModel.UserId > 0)
{
Action = "I";
if (objBillDataServiceModel.PODId > 0)
{
DeliverStatus = "Y";
var saveBillData = _workorderems.spSetBill(Action, objBillDataServiceModel.QuickBookBillId, objBillDataServiceModel.PODId, null, null,
objBillDataServiceModel.VendorId, objBillDataServiceModel.LocationId,
objBillDataServiceModel.BillType, objBillDataServiceModel.PoMisBdaAmount,
objBillDataServiceModel.InvoiceAmount, objBillDataServiceModel.InvoiceDate, objBillDataServiceModel.InvoiceDocument,
objBillDataServiceModel.UserId, null, DeliverStatus);
string[] Quantity = { };
string[] POF = { };
string[] ActiveId = objBillDataServiceModel.IsActive.Split(',');
if (objBillDataServiceModel.Quantity != null)
{
Quantity = objBillDataServiceModel.Quantity.Split(',');
}
if (objBillDataServiceModel.POF_ID != null)
{
POF = objBillDataServiceModel.POF_ID.Split(',');
}
if (objBillDataServiceModel.IsActive != "")
{
for (int i = 0; i < ActiveId.Length; i++)
{
if (ActiveId[i] != null)
{
//ActiveId[i] = "N";
Action = "U";
long POF_ID = Convert.ToInt64(POF[i]);
long QantityData = Convert.ToInt64(Quantity[i]);
long FacilityId = Convert.ToInt64(ActiveId[i]);
DeliverStatus = "N";
var saveFacilityData = _workorderems.spSetPOFacilityItem(Action, POF_ID, objBillDataServiceModel.PODId, FacilityId,
QantityData, DeliverStatus);
}
}
}
var userData = _workorderems.UserRegistrations.Where(x => x.UserId == objBillDataServiceModel.UserId &&
x.IsDeleted == false && x.IsEmailVerify == true).FirstOrDefault();
var locationData = _workorderems.LocationMasters.Where(x => x.LocationId == objBillDataServiceModel.LocationId &&
x.IsDeleted == false).FirstOrDefault();
#region Save DAR
LocationName = locationData.LocationServices.ToString();
UserName = userData.FirstName + " " + userData.LastName;
objDAR.ActivityDetails = DarMessage.BillCreated(userData.FirstName + "" + userData.LastName, locationData.LocationName, objBillDataServiceModel.PODId);
objDAR.TaskType = (long)TaskTypeCategory.BillCreated;
objDAR.UserId = objBillDataServiceModel.UserId;
objDAR.CreatedBy = objBillDataServiceModel.UserId;
objDAR.LocationId = objBillDataServiceModel.LocationId;
objDAR.CreatedOn = DateTime.UtcNow;
CommonManager.SaveDAR(objDAR);
#endregion DAR
}
else
{
var savePreBill = _workorderems.spSetPreBill(Action, objBillDataServiceModel.BillNumber, objBillDataServiceModel.LocationId,
objBillDataServiceModel.VendorId, objBillDataServiceModel.Comment,
objBillDataServiceModel.InvoiceAmount, objBillDataServiceModel.InvoiceDate,
objBillDataServiceModel.InvoiceDocument, objBillDataServiceModel.UserId,
null, "N");
if (objBillDataServiceModel.FacilityListForManualBill != null && objBillDataServiceModel.FacilityListForManualBill.Count() > 0)
{
foreach (var item in objBillDataServiceModel.FacilityListForManualBill)
{
if (item.UnitPrice > 0)
{
var saveFacility = _workorderems.spSetBillFacilityItem(Action, null, objBillDataServiceModel.BillNumber,
item.COM_FacilityId, item.Quantity, item.UnitPrice, item.Status);
}
}
}
//var saveBillData = _workorderems.spSetBill(Action,null, null, null,
// objBillDataServiceModel.VendorId, objBillDataServiceModel.LocationId,
// objBillDataServiceModel.BillType, null,
// objBillDataServiceModel.InvoiceAmount, objBillDataServiceModel.InvoiceDate, objBillDataServiceModel.InvoiceDocument,
// objBillDataServiceModel.UserId, null, "Y");
}
var objNotify = new NotificationDetailModel();
var _ICommonMethod = new CommonMethodManager();
var objModel = new CommonApproval <ApprovalInput>();
var approvalInput = new ApprovalInput();
approvalInput.Amount = Convert.ToDecimal(objBillDataServiceModel.InvoiceAmount);
approvalInput.UserId = objBillDataServiceModel.UserId;
approvalInput.ModuleName = "eCounting";
var getRuleData = objModel.GetApprovalRuleData(approvalInput);
if (getRuleData != null)
{
objNotify.CreatedBy = objBillDataServiceModel.UserId;
objNotify.CreatedDate = DateTime.UtcNow;
objNotify.AssignTo = getRuleData.UserId;
if (objBillDataServiceModel.PODId > 0)
{
objNotify.BillID = objBillDataServiceModel.PODId;
}
else
{
objNotify.BillID = objBillDataServiceModel.BillNumber;
}
var saveDataForNotification = _ICommonMethod.SaveNotificationDetail(objNotify);
}
if (getRuleData.DeviceId != null)
{
var objEmailHelper = new EmailHelper();
var objTemplateModel = new TemplateModel();
objEmailHelper.emailid = getRuleData.Email;
objEmailHelper.ManagerName = getRuleData.ManagerName;
objEmailHelper.LocationName = LocationName;
objEmailHelper.UserName = UserName;
objEmailHelper.BillId = objNotify.BillID.ToString();
//objEmailHelper.InfractionStatus = obj.Status;
objEmailHelper.MailType = "BILLAPPROVE";
objEmailHelper.SentBy = objBillDataServiceModel.UserId;
objEmailHelper.LocationID = objDAR.LocationId;
objEmailHelper.TimeAttempted = DateTime.UtcNow.ToMobileClientTimeZone(objTemplateModel.TimeZoneName, objTemplateModel.TimeZoneOffset, objTemplateModel.IsTimeZoneinDaylight, false).ToString();
objEmailHelper.IsWorkable = true;
string message = PushNotificationMessages.BillCreate(objNotify.BillID.ToString(), objEmailHelper.UserName, objEmailHelper.LocationName);
PushNotificationFCM.FCMAndroid(message, getRuleData.DeviceId, objEmailHelper);
}
isBillSaved = true;
}
else
{
isBillSaved = false;
}
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public BillDataServiceModel SaveBillDetails(BillDataServiceModel objBillDataServiceModel)", "Exception While Saving Bill Details.", null);
throw;
}
return(isBillSaved);
}
/// <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;
}
}
