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