//Add a record to guest details table
public static int AddRecord(eBiddingSearch eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
GuestUserDetails objDetail = new GuestUserDetails();
objDetail.Title = eobj.sUserTitle;
objDetail.FirstName = eobj.sUserFirstName;
objDetail.LastName = eobj.sUserLastName;
objDetail.Email = eobj.sUserEmail;
objDetail.PhoneNumber = eobj.sUserMobileNo;
OneFineRate.tblWebsiteGuestUserMaster dbuser = (OneFineRate.tblWebsiteGuestUserMaster)OneFineRateAppUtil.clsUtils.ConvertToObject(objDetail, new OneFineRate.tblWebsiteGuestUserMaster());
db.tblWebsiteGuestUserMasters.Add(dbuser);
db.SaveChanges();
retval = Convert.ToInt32(dbuser.Id);
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//Get Single Record
public static GuestUserDetails GetSingleRecordById(int id)
{
GuestUserDetails eobj = new GuestUserDetails();
using (OneFineRateEntities db = new OneFineRateEntities())
{
var dbobj = db.tblWebsiteGuestUserMasters.SingleOrDefault(u => u.Id == id);
if (dbobj != null)
{
eobj = (GuestUserDetails)OneFineRateAppUtil.clsUtils.ConvertToObject(dbobj, eobj);
}
}
return(eobj);
}
//Add Guest Details
public static int AddGuestDetailsRecord(GuestUserDetails objDetail)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblWebsiteGuestUserMaster dbuser = (OneFineRate.tblWebsiteGuestUserMaster)OneFineRateAppUtil.clsUtils.ConvertToObject(objDetail, new OneFineRate.tblWebsiteGuestUserMaster());
db.tblWebsiteGuestUserMasters.Add(dbuser);
db.SaveChanges();
retval = Convert.ToInt32(dbuser.Id);
}
catch (Exception)
{
throw;
}
}
return(retval);
}
public static int AddRecord(PropDetailsM eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
GuestUserDetails objDetail = new GuestUserDetails();
objDetail.Title = eobj.sUserTitle;
objDetail.FirstName = eobj.sUserFirstName;
objDetail.LastName = eobj.sUserLastName;
objDetail.Email = eobj.sUserEmail;
objDetail.PhoneNumber = eobj.sUserMobileNo;
objDetail.sCountryPhoneCode = eobj.sCountryPhoneCode;
objDetail.iStateId = eobj.iStateId;
OneFineRate.tblWebsiteGuestUserMaster dbuser = (OneFineRate.tblWebsiteGuestUserMaster)OneFineRateAppUtil.clsUtils.ConvertToObject(objDetail, new OneFineRate.tblWebsiteGuestUserMaster());
if (eobj.objBooking.iBookingId > 0)
{
var guestId = db.tblBookingTxes.Where(x => x.iBookingId == eobj.objBooking.iBookingId).Select(x => x.iGuestId).SingleOrDefault();
dbuser.Id = guestId == null ? 0 : guestId.Value;
db.tblWebsiteGuestUserMasters.Attach(dbuser);
db.Entry(dbuser).State = System.Data.Entity.EntityState.Modified;
}
else
{
db.tblWebsiteGuestUserMasters.Add(dbuser);
}
db.SaveChanges();
retval = Convert.ToInt32(dbuser.Id);
}
catch (Exception)
{
throw;
}
}
return(retval);
}
public ActionResult PayNow(eBiddingSearch obj)
{
try
{
Decimal? ExchangeRate = 1;
etblBookingTx bookobj = new etblBookingTx();
if (User.Identity.IsAuthenticated)
{
var user = BL_WebsiteUser.GetSingleRecordById(User.Identity.GetUserId <long>());
bookobj.iCustomerId = user.Id;
bookobj.iGuestId = 0;
}
else
{
var stronglObject = Session[obj.BidSearchData] as eBiddingSearch;
GuestUserDetails objDetail = new GuestUserDetails();
objDetail.Title = obj.sUserTitle == "1" ? "Mr." : obj.sUserTitle == "2" ? "Ms." : "";
objDetail.FirstName = obj.sUserFirstName;
objDetail.LastName = obj.sUserLastName;
objDetail.Email = obj.sUserEmail;
objDetail.PhoneNumber = obj.sUserMobileNo;
objDetail.iStateId = stronglObject.iStateId;
int i = BL_Bidding.AddGuestDetailsRecord(objDetail);
if (i > 0)
{
bookobj.iGuestId = i;
}
else
{
return(View("BiddingInfo", obj));
}
}
string CurrencyCode = Session["CurrencyCode"] != null ? Session["CurrencyCode"].ToString() : "INR";
if (CurrencyCode != "INR")
{
etblExchangeRatesM objExchange = BL_ExchangeRate.GetSingleRecordById("INR", CurrencyCode);
if (objExchange.dRate != 0)
{
ExchangeRate = 1 / objExchange.dRate;
}
}
bookobj.dtCheckIn = Convert.ToDateTime(obj.sCheckIn);;
bookobj.dtChekOut = Convert.ToDateTime(obj.sCheckOut);
bookobj.dtReservationDate = DateTime.Now;
bookobj.cBookingType = "B";
bookobj.sTitleOFR = obj.sUserTitle;
bookobj.sFirstNameOFR = obj.sUserFirstName;
bookobj.sLastNameOFR = obj.sUserLastName;
bookobj.sEmailOFR = obj.sUserEmail;
bookobj.sMobileOFR = obj.sUserMobileNo;
bookobj.dtActionDate = DateTime.Now;
bookobj.BookingStatus = "PP";
bookobj.PaymentStatus = "P";
bookobj.dBidAmount = obj.dBidPrice * ExchangeRate;
bookobj.dTotalAmount = obj.dTotalPrice * ExchangeRate;
bookobj.dTaxes = obj.dTaxes * ExchangeRate;
bookobj.dTaxesForHotel = obj.dTaxes * ExchangeRate;
bookobj.sCurrencyCode = Session["CurrencyCode"] != null ? Session["CurrencyCode"].ToString() : "INR";
bookobj.iBidStarCategory = Convert.ToInt16(obj.sStarRating);
bookobj.sBidType = obj.sLocalityType;
bookobj.sIDs = obj.sLocalityData.TrimEnd(',');
bookobj.dServiceCharge = Convert.ToDecimal(obj.sOFRServiceCharge);
bookobj.dGSTOnServiceCharge = Convert.ToDecimal(obj.sTaxOnServiceCharge_Val);
bookobj.dGSTServiceType = obj.cGstValueType;
bookobj.dGSTValue = Convert.ToString(obj.dGSTValue);
string TimeZone = Session["TimeZone"] != null ? Session["TimeZone"].ToString() : "+5:30";
decimal zone = Convert.ToDecimal(TimeZone.Replace(":", ".").Replace("+", ""));
bookobj.iCountryOffset = zone;
#region FetchRoomData and bind in datatables
var roomDataResult = new List <RoomData>();
if (obj.sJsonRoomData != null)
{
roomDataResult = new JavaScriptSerializer().Deserialize <List <RoomData> >(obj.sJsonRoomData);
}
List <etblBIDRoomAdultsTx> lstBid = new List <etblBIDRoomAdultsTx>();
foreach (var room in roomDataResult)
{
etblBIDRoomAdultsTx RoomObj = new etblBIDRoomAdultsTx();
RoomObj.iRoomNo = Convert.ToInt16(room.room);
RoomObj.iAdults = Convert.ToInt16(room.adult);
RoomObj.iChildren = Convert.ToInt16(room.child);
System.Text.StringBuilder str = new System.Text.StringBuilder();
foreach (var child in room.ChildAge)
{
str.Append(child.Age);
str.Append(",");
}
string ChildAges = str.ToString().TrimEnd(',');
RoomObj.sChildAge = ChildAges;
lstBid.Add(RoomObj);
}
#endregion
etblBookingTrakerTx trkobj = new etblBookingTrakerTx();
trkobj.BookingStatus = "PP";
trkobj.dtActionDate = DateTime.Now;
int j = BL_Booking.AddBookingForBid(bookobj, trkobj, lstBid);
if (j > 0)
{
obj.iBookingId = j;
Session[obj.BidSearchData] = obj;
// TempData.Keep();
return(RedirectToAction("PayNow", "Payment", new { bookingId = j }));
}
else
{
}
}
catch (Exception)
{
}
Session[obj.BidSearchData] = obj;
// TempData.Keep();
return(View("BiddingInfo", obj));
}
