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