/// <summary> /// Method to Save the Entry /// </summary> /// <param name="obj"></param> /// <returns></returns> public int SaveData(OnlineBooking obj) { int Id = 0; List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@ID", obj.Id)); parameters.Add(new SqlParameter("@SESSION_ID", obj.SessionId)); parameters.Add(new SqlParameter("@ENTRY_DATE", obj.EntryDate)); parameters.Add(new SqlParameter("@SARAI_MASTER_ID", obj.SaraiMasterId)); parameters.Add(new SqlParameter("@CUSTOMER_MASTER_ID", obj.CustomerMasterId)); parameters.Add(new SqlParameter("@FROM_DATE", obj.FromDate)); parameters.Add(new SqlParameter("@TO_DATE", obj.ToDate)); parameters.Add(new SqlParameter("@NO_OF_ROOMS", obj.NumberOfRooms)); parameters.Add(new SqlParameter("@ADULT_COUNT", obj.AdultCount)); parameters.Add(new SqlParameter("@CHILDREN_COUNT", obj.ChildrenCount)); parameters.Add(new SqlParameter("@ARRIVAL_TIME", obj.ArrivalTime)); parameters.Add(new SqlParameter("@PROOF_MASTER_ID", obj.ProofMasterId)); parameters.Add(new SqlParameter("@PROOF_DOCUMENT_MASTER_ID", obj.ProofDocumentMasterId)); parameters.Add(new SqlParameter("@PROOF_DOCUMENT_NUMBER", obj.ProofDocumentNumber)); parameters.Add(new SqlParameter("@AMOUNT", obj.Amount)); parameters.Add(new SqlParameter("@REMARKS", obj.Remarks)); parameters.Add(new SqlParameter("@IP_ADDRESS", obj.IPAddress)); parameters.Add(new SqlParameter("@BOOKING_STATUS", obj.BookingStatus)); DataTable dt = Db.GetDataTable("SAVE_UPDATE_ONLINE_BOOKING", parameters); if (dt.Rows.Count > 0) { Id = Convert.ToInt32(dt.Rows[0][0]); } return(Id); }
/// <summary> /// Method to Get the Particular Record from Database /// </summary> /// <param name="Id"></param> /// <returns></returns> public OnlineBooking GetSingleRecordDetail(int Id, DateTime?holidayDate, int instituteId) { OnlineBooking obj = new OnlineBooking(); string strQuery = ""; strQuery = strQuery + System.Environment.NewLine + "SELECT M.ID AS Id,"; strQuery = strQuery + System.Environment.NewLine + " M.SESSION_ID AS SessionId,"; strQuery = strQuery + System.Environment.NewLine + " M.ENTRY_DATE AS EntryDate,"; strQuery = strQuery + System.Environment.NewLine + " M.SARAI_MASTER_ID AS SaraiMasterId,"; strQuery = strQuery + System.Environment.NewLine + " M.CUSTOMER_MASTER_ID AS CustomerMasterId,"; strQuery = strQuery + System.Environment.NewLine + " M.FROM_DATE AS FromDate,"; strQuery = strQuery + System.Environment.NewLine + " M.TO_DATE AS ToDate,"; strQuery = strQuery + System.Environment.NewLine + " M.NO_OF_ROOMS AS NumberOfRooms,"; strQuery = strQuery + System.Environment.NewLine + " M.ADULT_COUNT AS AdultCount,"; strQuery = strQuery + System.Environment.NewLine + " M.CHILDREN_COUNT AS ChildrenCount,"; strQuery = strQuery + System.Environment.NewLine + " M.ARRIVAL_TIME AS ArrivalTime,"; strQuery = strQuery + System.Environment.NewLine + " M.PROOF_MASTER_ID AS ProofMasterId,"; strQuery = strQuery + System.Environment.NewLine + " M.PROOF_DOCUMENT_MASTER_ID AS ProofDocumentMasterId,"; strQuery = strQuery + System.Environment.NewLine + " M.PROOF_DOCUMENT_NUMBER AS ProofDocumentNumber,"; strQuery = strQuery + System.Environment.NewLine + " M.AMOUNT AS Amount,"; strQuery = strQuery + System.Environment.NewLine + " M.REMARKS AS Remarks,"; strQuery = strQuery + System.Environment.NewLine + " M.IP_ADDRESS AS IPAddress,"; strQuery = strQuery + System.Environment.NewLine + " M.BOOKING_STATUS AS BookingStatus"; strQuery = strQuery + System.Environment.NewLine + "FROM ONLINE_BOOKING M"; strQuery = strQuery + System.Environment.NewLine + "WHERE M.ID = "+ Id.ToString(); obj = Db.DapperGet <OnlineBooking>(strQuery); return(obj); }
public ActionResult OnlineBooking(OnlineBooking onlineBooking) { var fromAddress = new MailAddress("*****@*****.**", "New_Booking" + DateTime.Now); var toAddress = new MailAddress("*****@*****.**", "Abirami_Arrangements"); const string fromPassword = "******"; const string subject = "New_Booking:"; string body = (" MrName:" + onlineBooking.MrName + "\n" + " MrsName:" + onlineBooking.MrsName + "\n" + " MrRasiandNakshatra:" + onlineBooking.MrRasiandNakshatra + "\n" + " MrsRasiandNakshatra :" + onlineBooking.MrsRasiandNakshatra + "\n" + " MobileNumber: " + onlineBooking.MobileNumber + "\n" + " AlterneteMobile: " + onlineBooking.AlterneteMobile + "\n" + " FunctionDate :" + onlineBooking.FunctionDate + "\n" + " Location :" + onlineBooking.Location + "\n" + " TypeofAbishegam : " + onlineBooking.TypeofAbishegam + "\n" + " AbishegamDays :" + onlineBooking.AbishegamDays + "\n" + " Bhramin : " + onlineBooking.Bhramin + "\n" + " Food :" + onlineBooking.Food + "\n" + " Hotel :" + onlineBooking.Hotel + "\n" + " Photography :" + onlineBooking.Photography + "\n" + " VideoCoverage: " + onlineBooking.VideoCoverage); Session["Customer"] = onlineBooking.MrName; if (ConfigurationManager.AppSettings["IsLive"] == "true") { var smtp = new SmtpClient { Host = "smtp.gmail.com", Port = 587, EnableSsl = true, DeliveryMethod = SmtpDeliveryMethod.Network, UseDefaultCredentials = false, Credentials = new NetworkCredential(fromAddress.Address, fromPassword) }; using (var message = new MailMessage(fromAddress, toAddress) { Subject = subject, Body = body }) { smtp.Send(message); } string apiKey = ConfigurationManager.AppSettings["SMSApiKey"]; string mobileNumber = "+91" + onlineBooking.MobileNumber; string SenderID = ConfigurationManager.AppSettings["SenderID"]; string Message = "Thank you for using Thirukadaiyur weddings. Your booking is confirmed.For hotels and foods please visit https://www.thirukadaiyurweddings.com/Home/About/#ourservices. Contacts: 9585831457"; Message = HttpUtility.UrlEncode(Message); string URL = "https://smsapi.24x7sms.com/api_2.0/SendSMS.aspx?APIKEY=3IaTpqArkNl&MobileNo=9585831457&SenderID=ABRAMI&Message=" + Message + "&ServiceName=TEMPLATE_BASED"; WebRequest webRequest = WebRequest.Create(URL); WebResponse webResponse = webRequest.GetResponse(); StreamReader streamReader = new StreamReader(webResponse.GetResponseStream()); string result = streamReader.ReadToEnd(); webResponse.Dispose(); streamReader.Dispose(); } return(RedirectToAction("OnlineBookingconfirmation")); }
public int UpdateRoutePosCall(string fromId, List <Classes.TRoutePos> list, string username, string password) { OnlineBooking onlineBooking = new OnlineBooking(); return(onlineBooking.UpdateRoutePositions(list)); }