public ActionResult Summery()
{
//try
//{
ReservationModel objModel = TempData["ReservationModel"] as ReservationModel;
int roomID = Convert.ToInt32(objModel._roomType);
objModel._room = _context.JW_Rooms.Where(w => w.RoomID == roomID).FirstOrDefault();
int _packageId = Convert.ToInt32(objModel._packageType);
if (objModel._packageType == "1")
{
objModel._packageType = "7 Night Accomadation";
}
else if (objModel._packageType == "2")
{
objModel._packageType = "8 Night Accomadation";
}
else if (objModel._packageType == "3")
{
objModel._packageType = "9 Night Accomadation";
}
else if (objModel._packageType == "4")
{
objModel._packageType = "10 Night Accomadation";
}
double additionalAC = 0;
if (objModel._additionalList != null || objModel._additionalList.Count !=0)
{
foreach (var item in objModel._additionalList)
{
int ID = Convert.ToInt32(item._addtionalRoom);
var ac = _context.JW_AdditionalRoomRates.Where(w => w.RoomID == ID).FirstOrDefault();
double _tempCost = ac.RoomRate.GetValueOrDefault(0) * item._addtionalNoOfNights * item._addtionalNoOfRooms;
additionalAC += _tempCost;
}
}
var cost = _context.JW_RoomRate.Where(w => w.RoomID == roomID && w.Occupancy == objModel._Occupancy && w.PackageId == _packageId).FirstOrDefault();
objModel.PackageCost = (float)cost.RoomRate;
objModel.AdditionalACCost = (float)additionalAC;
float TotalCost = (float)cost.RoomRate + (float)additionalAC;
objModel.TotalCost = TotalCost;
JW_Delegates _delegate = new JW_Delegates();
_delegate.BookingID = objModel.BookingID;
_delegate.ContactNo = objModel._delegate.ContactNo;
_delegate.Country = objModel._delegate.Country;
_delegate.DelegeteName = objModel._delegate.Name;
_delegate.Email = objModel._delegate.EmailAddress;
_delegate.Nationality = objModel._delegate.Nationality;
_delegate.PassportNo = objModel._delegate.PassportNo;
_delegate.Title = objModel._delegate.Title;
_delegate.Address = objModel._delegate.DelegateAddress;
_context.JW_Delegates.Add(_delegate);
_context.SaveChanges();
JW_Reservation _reservation = new JW_Reservation();
_reservation.HotelName = objModel._hotel.HotelName;
_reservation.BookingID = objModel.BookingID;
_reservation.ArrivalFlightNo = objModel._ArrivalFlightNumber;
_reservation.DepartureFlightNo = objModel._DepartureFlightNumber;
//_reservation.CheckInDate = objModel._ArrivalDate;
//_reservation.CheckInTime = objModel._ArrivalTime;
//_reservation.CheckOutDate = objModel._DepartureDate;
//_reservation.CheckOutTime = objModel._DepartureTime;
_reservation.IsArrivalTransportRequired = objModel._isArrival;
_reservation.IsDepartureTransportRequired = objModel._isDeparture;
_reservation.Roomtype = Convert.ToInt32(objModel._roomType);
_reservation.Occupancy = objModel._Occupancy;
_reservation.BedPreference = objModel._BedPerferance;
_reservation.TotalCost = TotalCost;
_reservation.IsAdvancePayment = objModel.isAdvancedPayment;
_context.JW_Reservation.Add(_reservation);
_context.SaveChanges();
return View(objModel);
//}
//catch(Exception ex)
//{
// return RedirectToAction("Registration", "Reservation", new { HotelCode = "CGC" });
//}
}
public ActionResult SaveReservation(ReservationModel ObjModel, string rdPaymentMethod)
{
TempData["ReservationModel"] = ObjModel;
ObjModel._hotel = _context.JW_Hotels.Where(w => w.HotelCode == ObjModel._hotelCode).FirstOrDefault();
string BookingID = ObjModel.BookingID;
string userName = "******";
string Password = "******";
string customerName = ObjModel._delegate.Name;
string email = ObjModel._delegate.EmailAddress;
string ConventionCode = "JWCON";
string Language = "en";
string Currency = "USD";
DateTime _fromDate = DateTime.ParseExact(ObjModel._fromDate, "dd/MM/yyyy", null);
DateTime _toDate = DateTime.ParseExact(ObjModel._toDate, "dd/MM/yyyy", null);
double _beforeDays = 0;
int _packageDays = 0;
double _afterDays = 0;
double TotalCost = 0;
DateTime _StartingDate = DateTime.ParseExact("04/07/2018", "dd/MM/yyyy", null);
TimeSpan t = _StartingDate - _fromDate;
//_beforeDays = t.TotalDays;
DateTime _7dayPackage = DateTime.ParseExact("09/07/2018", "dd/MM/yyyy", null);
DateTime _8dayPackage = DateTime.ParseExact("10/07/2018", "dd/MM/yyyy", null);
DateTime _9dayPackage = DateTime.ParseExact("11/07/2018", "dd/MM/yyyy", null);
DateTime _10dayPackage = DateTime.ParseExact("12/07/2018", "dd/MM/yyyy", null);
int PackageId = 0;
int roomType = Convert.ToInt32(ObjModel._roomType);
_packageDays = (int)(_toDate - _fromDate).TotalDays;
JW_RoomRate roomDetails = _context.JW_RoomRate.Where(w => w.RoomID == roomType && w.PackageId == 1 && w.Occupancy == ObjModel._Occupancy).FirstOrDefault();
if (roomDetails != null)
{
TotalCost = (double)(roomDetails.RoomRate / 7) * _packageDays;
//Allotment = (int)roomDetails.RemainingAllotment;
}
else
{
TotalCost = 0;
//Allotment = 0;
}
//if (_toDate == _7dayPackage)
//{
// _packageDays += 7;
// _afterDays = (_toDate - _7dayPackage).TotalDays;
// _packageDays += (int)_afterDays;
// _packageDays += (int)_beforeDays;
// TotalCost = (double)_context.JW_RoomRate.Where(w => w.PackageId == 1 && w.RoomID == roomType && w.Occupancy == ObjModel._Occupancy).FirstOrDefault().RoomRate;
// PackageId = 1;
//}
//else if (_toDate > _7dayPackage && _toDate <= _8dayPackage)
//{
// _packageDays += 8;
// _afterDays = (_toDate - _8dayPackage).TotalDays;
// _packageDays += (int)_afterDays;
// _packageDays += (int)_beforeDays;
// TotalCost = (double)_context.JW_RoomRate.Where(w => w.PackageId == 2 && w.RoomID == roomType && w.Occupancy == ObjModel._Occupancy).FirstOrDefault().RoomRate;
// PackageId = 2;
//}
//else if (_toDate > _8dayPackage && _toDate <= _9dayPackage)
//{
// _packageDays += 9;
// _afterDays = (_toDate - _9dayPackage).TotalDays;
// _packageDays += (int)_afterDays;
// _packageDays += (int)_beforeDays;
// TotalCost = (double)_context.JW_RoomRate.Where(w => w.PackageId == 3 && w.RoomID == roomType && w.Occupancy == ObjModel._Occupancy).FirstOrDefault().RoomRate;
// PackageId = 3;
//}
//else if (_toDate > _9dayPackage && _toDate <= _10dayPackage)
//{
// _packageDays += 10;
// _afterDays = (_toDate - _10dayPackage).TotalDays;
// _packageDays += (int)_afterDays;
// _packageDays += (int)_beforeDays;
// TotalCost = (double)_context.JW_RoomRate.Where(w => w.PackageId == 4 && w.RoomID == roomType && w.Occupancy == ObjModel._Occupancy).FirstOrDefault().RoomRate;
// PackageId = 4;
//}
//else if (_toDate > _10dayPackage)
//{
// _packageDays += 10;
// _afterDays = (_toDate - _10dayPackage).TotalDays;
// _packageDays += (int)_afterDays;
// _packageDays += (int)_beforeDays;
// TotalCost = (double)_context.JW_RoomRate.Where(w => w.PackageId == 4 && w.RoomID == roomType && w.Occupancy == ObjModel._Occupancy).FirstOrDefault().RoomRate;
// PackageId = 4;
//}
//if(_beforeDays > 0)
//{
// double cost = (double)_context.JW_AdditionalRoomRates.Where(w=>w.RoomID == roomType && w.Occupancy == ObjModel._Occupancy).FirstOrDefault().RoomRate;
// TotalCost = TotalCost + (cost * _beforeDays);
//}
//if(_afterDays > 0)
//{
// double cost = (double)_context.JW_AdditionalRoomRates.Where(w=> w.RoomID == roomType && w.Occupancy == ObjModel._Occupancy).FirstOrDefault().RoomRate;
// TotalCost = TotalCost + (cost * _afterDays);
//}
JW_Delegates _delegate = new JW_Delegates();
_delegate.BookingID = ObjModel.BookingID;
_delegate.ContactNo = ObjModel._delegate.ContactNo;
_delegate.Country = ObjModel._delegate.Country;
_delegate.DelegeteName = ObjModel._delegate.Name;
_delegate.Email = ObjModel._delegate.EmailAddress;
_delegate.Nationality = ObjModel._delegate.Nationality;
_delegate.PassportNo = ObjModel._delegate.PassportNo;
_delegate.Title = ObjModel._delegate.Title;
_delegate.Address = ObjModel._delegate.DelegateAddress;
_context.JW_Delegates.Add(_delegate);
_context.SaveChanges();
DateTime CheckInDate = DateTime.ParseExact(ObjModel._fromDate, "dd/MM/yyyy", null);
DateTime CheckOutDate = DateTime.ParseExact(ObjModel._toDate, "dd/MM/yyyy", null);
DateTime ArrivalDate = DateTime.ParseExact(ObjModel._ArrivalDate, "dd/MM/yyyy", null);
DateTime DepartureDate = DateTime.ParseExact(ObjModel._DepartureDate, "dd/MM/yyyy", null);
JW_Reservation _reservation = new JW_Reservation();
_reservation.HotelName = ObjModel._hotel.HotelName;
_reservation.BookingID = ObjModel.BookingID;
_reservation.ArrivalFlightNo = ObjModel._ArrivalFlightNumber;
_reservation.DepartureFlightNo = ObjModel._DepartureFlightNumber;
_reservation.CheckInDate = CheckInDate;
_reservation.CheckInTime = ObjModel._ArrivalTime;
_reservation.CheckOutDate = CheckOutDate;
_reservation.ArrivalDate = ArrivalDate;
_reservation.DepartureDate = DepartureDate;
_reservation.CheckOutTime = ObjModel._DepartureTime;
_reservation.IsArrivalTransportRequired = ObjModel._isArrival;
_reservation.IsDepartureTransportRequired = ObjModel._isDeparture;
_reservation.Roomtype = Convert.ToInt32(ObjModel._roomType);
_reservation.Occupancy = ObjModel._Occupancy;
_reservation.BedPreference = ObjModel._BedPerferance;
_reservation.TotalCost = TotalCost;
_reservation.NightBefore = Convert.ToInt32(_beforeDays);
_reservation.Package = Convert.ToInt32(_packageDays);
_reservation.NightAfter = Convert.ToInt32(_afterDays);
if (rdPaymentMethod == "Half")
{
_reservation.IsAdvancePayment = true;
}
else
{
_reservation.IsAdvancePayment = false;
}
_context.JW_Reservation.Add(_reservation);
_context.SaveChanges();
if (rdPaymentMethod == "Half")
{
TotalCost = TotalCost / 2;
}
Encryption encry = new Encryption();
string _amount = encry.EncryptString(TotalCost.ToString(), "Amount");
_reservation.PreHashKey = _amount;
_context.Entry(_reservation).State = System.Data.Entity.EntityState.Modified;
_context.SaveChanges();
//string url = "http://payment.walkerstours.net/Payment/WebPortal";
string url = "https://webportal.walkerstours.com/Events/Payment/WebPortal";
Response.Clear();
var sb = new System.Text.StringBuilder();
sb.Append("<html>");
sb.AppendFormat("<body onload='document.forms[0].submit()'>");
sb.AppendFormat("<form action='{0}' method='post'>", url);
sb.AppendFormat("<input type='hidden' id='CustomerRef' name='CustomerRef' value='" + BookingID + "'>", BookingID);
sb.AppendFormat("<input type='hidden' id='Amount' name='Amount' value='" + TotalCost + "'>", TotalCost);
sb.AppendFormat("<input type='hidden' id='UserName' name='UserName' value='" + userName + "'>", userName);
sb.AppendFormat("<input type='hidden' id='Password' name='Password' value='" + Password + "'>", Password);
sb.AppendFormat("<input type='hidden' id='customername' name='customername' value='" + customerName + "'>", customerName);
sb.AppendFormat("<input type='hidden' id='email' name='email' value='" + email + "'>", email);
sb.AppendFormat("<input type='hidden' id='conventioncode' name='conventioncode' value='" + ConventionCode + "'>", ConventionCode);
sb.AppendFormat("<input type='hidden' id='language' name='language' value='" + Language + "'>", Language);
sb.AppendFormat("<input type='hidden' id='_currency' name='_currency' value='" + Currency + "'>", Currency);
sb.Append("</form>");
sb.Append("</body>");
sb.Append("</html>");
//Response.Write(sb.ToString());
//Response.End();
return Content(sb.ToString());
// }
// return null;
// return RedirectToAction("AddtionalAccomerdation", "Reservation");
}
public ActionResult Confirmation()
{
try
{
//string _result = (Request.Form["_result"]).ToString();
//string _orderID = (Request.Form["_orderID"]).ToString();
//string _response = (Request.Form["_response"]).ToString();
//string _currency = (Request.Form["_currency"]).ToString();
//string _conventionCode = (Request.Form["_conventionCode"]).ToString();
//string _amount = (Request.Form["_amount"]).ToString();
//Encryption _decrypt = new Encryption();
//_result = _decrypt.DecryptString(_result, "Result");
//_orderID = _decrypt.DecryptString(_orderID, "CustomerRef");
//_response = _decrypt.DecryptString(_response, "ResponseString");
//_conventionCode = _decrypt.DecryptString(_conventionCode, "ConventionCode");
//_amount = _decrypt.DecryptString(_amount, "Amount");
string _result = "1";
string _orderID = "JW18722";
string _response = "";
string _currency = "USD";
string _conventionCode = "JWCON";
string _amount = "1705";
if (_result == "1")
{
string BookingId = _orderID;
EmailModel em = new EmailModel();
em.BookingRef = _orderID;
IPGConfig _ipgConfig = _context.IPGConfigs.Where(w => w.ConventionCode == _conventionCode).FirstOrDefault();
JW_Delegates del = _context.JW_Delegates.Where(w => w.BookingID == BookingId).FirstOrDefault();
JW_Reservation reservation = _context.JW_Reservation.Where(w => w.BookingID == BookingId).FirstOrDefault();
reservation.BankRespond = true;
reservation.BankRespondValue = Convert.ToDouble(_amount);
Encryption encry = new Encryption();
string hashKey = encry.EncryptString(_amount, "Amount");
reservation.PostHashKey = hashKey;
//if (reservation.IsAdvancePayment == true)
//{
// em.Amount = Convert.ToDouble(reservation.TotalCost / 2);
//}
//else
//{
// em.Amount = Convert.ToDouble(reservation.TotalCost);
//}
em.Amount = Convert.ToDouble(_amount);
em.InvoiceAmount = Convert.ToDouble(reservation.TotalCost);
em.ClientEmail = del.Email;
em.ClientName = del.DelegeteName;
em.InvoiceNo = _orderID;
em.DateofPayment = DateTime.ParseExact("04/12/2017", "dd/MM/yyyy", null);//DateTime.Today;
em.CheckIn = reservation.CheckInDate.GetValueOrDefault().ToString("dd/MMMM/yyyy");
em.CheckOut = reservation.CheckOutDate.GetValueOrDefault().ToString("dd/MMMM/yyyy");
em.EmailCC = _ipgConfig.EmailCC;
em.EmailBCC = _ipgConfig.EmailBCC;
em.From = _ipgConfig.EmailFrom;
em.HotelName = reservation.HotelName;
em.RoomCategory = reservation.JW_Rooms.RoomType;
string Package = "";
int totalNights = 0;
if(reservation.NightBefore > 0)
{
// Package += reservation.Package + " Night Before + ";
totalNights += (int)reservation.NightBefore;
}
// Package += reservation.Package + " Night Package + ";
totalNights += (int)reservation.Package;
if(reservation.NightAfter > 0)
{
// Package += reservation.NightAfter + " Night After ";
totalNights += (int)reservation.NightAfter;
}
//em.PackageType = Package;
em.PackageType = totalNights.ToString() + " Night Package";
em.SendEmail(em, "CustomerInvoice");
IQueryable<JW_RoomRate> roomRate = _context.JW_RoomRate.Where(w => w.RoomID == reservation.JW_Rooms.RoomID);
foreach(JW_RoomRate item in roomRate)
{
int newAllotment = (int)item.RemainingAllotment;
newAllotment = newAllotment - 1;
item.RemainingAllotment = newAllotment;
}
//_context.Entry(stud).State = System.Data.Entity.EntityState.Modified;
_context.SaveChanges();
return View("PaymentComplete");
}
else
{
return View("PaymentIssue");
}
}
catch (Exception ex)
{
return RedirectToAction("Test", "Reservation", new { id = ex.Message });
}
}