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