/// <summary> /// travel house details /// </summary> /// <param name="name"></param> /// <returns></returns> public Dictionary <string, object> ithfilldropdown(string name) { var _context = new SodEntities(); Dictionary <string, object> dicInfo = new Dictionary <string, object>(); var ithdetails = new List <IthVendorListDataModels>(); ithdetails = _context.IthVendorListDataModel.Where(a => a.IthName == name).ToList(); dicInfo.Add("ithList", ithdetails); return(dicInfo); }
/// <summary> /// save hod status /// </summary> /// <param name="TravelRequestId"></param> /// <param name="status"></param> /// <returns></returns> public int saveHODStatus(long TravelRequestId, string status) { var _context = new SodEntities(); var updateItem = _context.OALTravelRequestMasterModel.Where(b => b.TravelRequestId == TravelRequestId).ToList(); foreach (var p in updateItem) { p.FinancialApproval = status; } var i = _context.SaveChanges(); return(i); }
/// <summary> /// save hod response /// </summary> /// <param name="IdList"></param> /// <param name="criteria"></param> /// <returns></returns> public int saveHODResponseData(string IdList, int criteria) { List <ITHResponseDetailModels> ithdetails = new List <ITHResponseDetailModels>(); ithdetails = ADO.SodCommonServices.saveHODResponseData(IdList, criteria); List <ITHFinancialApprovalHODModels> hlist = new List <ITHFinancialApprovalHODModels>(); var _context = new SodEntities(); foreach (var item in ithdetails) { var lst = new ITHFinancialApprovalHODModels(); lst.TravelRequestId = item.TravelRequestId; lst.ResponseDate = item.ResponseDate; lst.OriginPlace = item.OriginPlace; lst.DestinationPlace = item.DestinationPlace; lst.TravelDate = item.TravelDate; lst.FlightNo = item.FlightNo; lst.FlightName = item.FlightName; lst.DepartureTime = item.DepartureTime; lst.ArrivalTime = item.ArrivalTime; lst.Amount = item.Amount; lst.FlightType = item.FlightType; hlist.Add(lst); } _context.ITHFinancialApprovalHODModel.AddRange(hlist); //save approval status in ith details table for (var j = 0; j < IdList.Split(',').Length - 1; j++) { var id = Convert.ToInt64(IdList.Split(',')[j]); var updateith = _context.ITHResponseDetailModel.Where(b => b.ID == id).ToList(); foreach (var p in updateith) { p.HodApproval = "Approved"; } } //save approval status in master table var trid = ithdetails[0].TravelRequestId; var updateItem = _context.OALTravelRequestMasterModel.Where(b => b.TravelRequestId == trid).ToList(); foreach (var p in updateItem) { p.FinancialApproval = "Approved"; } var i = _context.SaveChanges(); return(i); }
/// <summary> /// save ith response data /// </summary> /// <param name=""></param> /// <returns></returns> public int SaveITHResponseData(List <ITHResponseDetailModels> ithList) { var _context = new SodEntities(); _context.ITHResponseDetailModel.AddRange(ithList); var trid = ithList[0].TravelRequestId; var updateItem = _context.OALTravelRequestMasterModel.Where(b => b.TravelRequestId == trid).ToList(); foreach (var p in updateItem) { p.ITHResponseStatus = "Response Received"; } var i = _context.SaveChanges(); return(i); }
/// <summary> /// save ITH request /// </summary> /// <param name="oatList"></param> /// <returns></returns> public int SaveITHRequestData(List <ITHRequestApprovalModels> hlist) { var _context = new SodEntities(); _context.ITHRequestApprovalModel.AddRange(hlist); var trid = hlist[0].TravelRequestId; var updateItem = _context.OALTravelRequestMasterModel.Where(b => b.TravelRequestId == trid).ToList(); foreach (var p in updateItem) { p.ITHResponseStatus = "Response Pending from ITH"; } var i = _context.SaveChanges(); return(i); }
public JsonResult DropDownCityCodeData() { List <SelectListItem> hotelItems = new List <SelectListItem>(); SodEntities entities = new SodEntities(); var count = entities.SodHotelListDataModels.Count(); for (int i = 0; i < count; i++) { hotelItems.Add(new SelectListItem { Value = entities.SodHotelListDataModels.ToList()[i].City, Text = entities.SodHotelListDataModels.ToList()[i].StationCode }); } return(Json(hotelItems)); }
/// <summary> /// Send SMS and Save data in DB /// </summary> public static void getSmsData() { SodEntities _context = new SodEntities(); DateTime currentDate = DateTime.Now; //DateTime currentDate = new DateTime(2018, 07, 04, 11, 8, 0); var time1 = currentDate.AddMinutes(30).ToShortTimeString(); var time = currentDate.AddMinutes(35).ToShortTimeString(); try { var data = SodCommonServices.GetSMSData(currentDate.Date, time1, time).ToList(); if (data != null && data.Count > 0) { foreach (var item in data) { //modify link for cancellation in sms string rqstQueryString = ConfigurationManager.AppSettings["smsLink"].ToString() + "?trid=" + item.TravelRequestId.ToString() + "," + item.HotelRequestId.ToString() + ",sms"; string msgContent = ConfigurationManager.AppSettings["smsMsg"].ToString(); msgContent = msgContent.Replace("[rqstQueryString]", rqstQueryString); //save sms sent status in database var flightData = _context.FlightDetailModel.SingleOrDefault(s => s.Id == item.Id); if (flightData != null) { if (!flightData.IsHotelSendSms) { bool status = SendSmsViaApi(msgContent, item.Phone); if (status) { flightData.IsHotelSendSms = true; } _context.SaveChanges(); } } } } } catch (Exception ex) { AddDBLogging(ex, "getSmsData", "SmsNotifications.cs"); } }
/// <summary> /// Get SOD Hotel Info /// </summary> /// <param name="travelReqId"></param> /// <returns></returns> public Dictionary <string, object> GetSodHotelInfo(long travelReqId) { var _context = new SodEntities(); Dictionary <string, object> dicInfo = new Dictionary <string, object>(); var sodflightList = new List <FlightDetailModels>(); var passengerList = new List <PassengerDetailModels>(); var hotelList = new List <TravelRequestHotelDetailModels>(); var bookingInfoList = new List <TravelRequestMasterModels>(); sodflightList = _context.FlightDetailModel.Where(b => b.TravelRequestId == travelReqId).ToList(); passengerList = _context.PassengerDetailModel.Where(b => b.TravelRequestId == travelReqId).ToList(); hotelList = _context.TravelRequestHotelDetailModel.Where(b => b.TravelRequestId == travelReqId).ToList(); bookingInfoList = _context.TravelRequestMasterModel.Where(b => b.TravelRequestId == travelReqId).ToList(); dicInfo.Add("hotelinfolist", hotelList); dicInfo.Add("flightInfolist", sodflightList); dicInfo.Add("passInfolist", passengerList); dicInfo.Add("bookingInfolist", bookingInfoList); return(dicInfo); }
/// <summary> /// Add DB Logging for SMS /// </summary> /// <param name="ex"></param> /// <param name="methosName"></param> /// <param name="filePath"></param> public static void AddDBLogging(Exception ex, string methosName, string filePath) { SodEntities _context = new SodEntities(); SmsLoggingModels obj = new SmsLoggingModels(); try { obj.LogDate = System.DateTime.Now; obj.LogMessage = ex.Message.ToString(); obj.LogData = ex.Data.ToString(); obj.LogSource = ex.Source; obj.HelpLink = ex.HelpLink == null ? "" : ex.HelpLink; obj.HResult = ex.HResult == null ? "" : ex.HResult.ToString(); obj.InnerException = ex.InnerException == null ? "" : ex.InnerException.Message; obj.MethodName = methosName; obj.FilePath = filePath; _context.SmsLoggingModel.Add(obj); _context.SaveChanges(); } catch (Exception) { } }
public TravelRequestTypeRepository(SodEntities sodEntities) { this._context = sodEntities; }
public BlanketApprovalRepository(SodEntities sodEntities) { this._context = sodEntities; }
public HdRepository(SodEntities sodEntities) { this._context = sodEntities; }
public RevenueRepository(SodEntities sodEntities) { this._context = sodEntities; }
public InclusionRepository(SodEntities sodEntities) { this._context = sodEntities; }
public UserAccountRepository(SodEntities sodEntities) { this._context = sodEntities; }
public VendorRepository(SodEntities sodEntities) { this._context = sodEntities; }
public SodBookingTypeRepository(SodEntities sodEntities) { this._context = sodEntities; }
public SodApproverRepositorty(SodEntities sodEntities) { this._context = sodEntities; }
public UserChangeRequestHRRepository(SodEntities sodEntities) { _context = sodEntities; }
public SjSisConcernRepository(SodEntities sodEntities) { this._context = sodEntities; }
public HotelApproverRepository(SodEntities sodEntities) { this._context = sodEntities; }
public DepartmentRepository(SodEntities sodEntities) { this._context = sodEntities; }
public BillingRepository(SodEntities sodEntities) { this._context = sodEntities; }
public cityMasterRepository(SodEntities sodEntities) { this._context = sodEntities; }