public ActionResult UnfinishedBalanceToBePaidSendLink(etblUnfinishedTransactionsToBePaid objData)
{
string adminEmail = objData.sCustomerEmailID;
string adminsCcEmail = "";// "*****@*****.**";
string adminsBCcEmail = "";
string adminsSubject = "Unfinished Transaction - Balance To Be Paid";
string adminsBody = "<table border='1'>";
adminsBody += "<tr><td>Hotel Name: </td><td>" + objData.sHotelName + "</td>";
adminsBody += "<tr><td>Star Category: </td><td>" + objData.iStarCategory + "</td>";
adminsBody += "<tr><td>Address: </td><td>" + objData.sHotelAddress + "</td>";
adminsBody += "<tr><td>Your Negotiation Amount: </td><td>" + objData.dNegotiationAmount + "</td>";
adminsBody += "<tr><td>Advanced Paid: </td><td>" + objData.dAdvancePaid + "</td>";
adminsBody += "<tr><td>Balance Payment: </td><td>" + objData.dBalancePayment + "</td>";
adminsBody += "<tr><td colspna='2'><a href='onefinerate.azurewebsites.net'>Click To Pay Balance Amount</a> </td>";
adminsBody += "</table>";
MailComponent.SendEmail(adminEmail, adminsCcEmail, adminsBCcEmail, adminsSubject, adminsBody, null, null, true, null, null);
TempData["msg"] = "Link sent to customer successfully";
return(RedirectToAction("UnfinishedBalanceToBePaid", objData));
}
public static etblUnfinishedTransactionsToBePaid GetUnfinishedBalanceToBePaidData(long?BookingId)
{
etblUnfinishedTransactionsToBePaid objMapping = new etblUnfinishedTransactionsToBePaid();
List <etblHotelFacilities> objresultHotelFacilities = new List <etblHotelFacilities>();
using (OneFineRateEntities db = new OneFineRateEntities())
{
#region General Details
SqlParameter[] MyParam = new SqlParameter[1];
MyParam[0] = new SqlParameter("@BookingId", BookingId);
var objresult = db.Database.SqlQuery <etblUnfinishedTransactionsToBePaid>("uspGetUnfinishedBalanceToBePaidData @BookingId", MyParam).ToList();
objMapping = (etblUnfinishedTransactionsToBePaid)OneFineRateAppUtil.clsUtils.ConvertToObject(objresult[0], objMapping);
int propId = objMapping.iPropId;
SqlParameter[] MyParamHotelFacilities = new SqlParameter[1];
MyParamHotelFacilities[0] = new SqlParameter("@PropId", propId);
objresultHotelFacilities = db.Database.SqlQuery <etblHotelFacilities>("uspGetOfferReviewHotelAmenties @PropId", MyParamHotelFacilities).ToList();
objMapping.lstetblHotelFacilities = objresultHotelFacilities;
#endregion
return(objMapping);
}
}
public ActionResult UnfinishedBalanceToBePaid(etblUnfinishedTransactionsToBePaid objprop)
{
etblUnfinishedTransactionsToBePaid objData = new etblUnfinishedTransactionsToBePaid();
if (objprop.iBookingID != null)
{
objData = BL_UnfinishedTransactions.GetUnfinishedBalanceToBePaidData(objprop.iBookingID);
}
else
{
long BookingId = 0;
if (HttpContext.Request.Params["Id"] != null)
{
BookingId = Convert.ToInt32(HttpContext.Request.Params["Id"]);
}
//objData = BL_UnfinishedTransactions.GetUnfinishedBalanceToBePaidData(BookingId);
var obj = BL_Booking.GetUnfinishedTransactionToSendRevenueManager(BookingId);
obj.sBookType = "N";
return(View("NegotiationAccepted", obj));
}
return(View("UnfinishedBalanceToBePaid", objData));
}
