public ActionResult Search_Book() { HallVM hvm = new HallVM(); hvm.halls = hbl.Get_HallNames(); hvm.d_halls = hbl.Get_d_HallNames(); hvm.d_slots = hbl.get_dining_slot(); hvm.resTypeOptions = hbl.Get_reservationType(); hvm.dd_deps = hbl.Get_faculty_departments(); hvm.dd_cfac_deps = hbl.Get_faculty_departments(); return(View(hvm)); }
public ActionResult Search_Book(HallVM hallVM) { try { hallVM.halls = hbl.Get_HallNames(); hallVM.d_halls = hbl.Get_d_HallNames(); hallVM.d_slots = hbl.get_dining_slot(); hallVM.resTypeOptions = hbl.Get_reservationType(); hallVM.dd_deps = hbl.Get_faculty_departments(); hallVM.dd_cfac_deps = hbl.Get_faculty_departments(); TryUpdateModel(hallVM); hallVM.hallId = Convert.ToInt32(Session["fixed_hallId"] as String); hallVM.hallName = Session["fixed_hallName"] as String; hallVM.start_date = Convert.ToDateTime(Session["fixed_startDate"] as String); hallVM.end_date = Convert.ToDateTime(Session["fixed_endDate"] as String); hallVM.start_time = Session["fixed_startTime"] as String; hallVM.end_time = Session["fixed_endTime"] as String; hallVM.reservation_amount = Convert.ToInt32(Session["fixed_reservationAmount"]); // hallVM.StartDate_trim =(Session["fixed_startDate"] as String).Substring(0,10); if (ModelState.IsValid) { DataTable dtBooking_result = hbl.AddReservation(hallVM); if (dtBooking_result.Rows.Count == 1) { //send email notification try { using (MailMessage message = new MailMessage("*****@*****.**", hallVM.fac_emailId)) //hallVM.fac_emailId)) { message.Subject = "ICSR - Hall booking Notification"; message.Body = dtBooking_result.Rows[0]["facultyName"].ToString(); string sAttachment_name = string.Empty; if (Convert.ToInt32(dtBooking_result.Rows[0]["res_typeId"]) == 1) { sAttachment_name = "/Files_to_be_downloaded/Internal_Form.pdf"; } else if (Convert.ToInt32(dtBooking_result.Rows[0]["res_typeId"]) == 2) { sAttachment_name = "/Files_to_be_downloaded/External_Form.pdf"; } else if (Convert.ToInt32(dtBooking_result.Rows[0]["res_typeId"]) == 3) { sAttachment_name = "/Files_to_be_downloaded/Without_Charges_Form.pdf"; } Attachment attach = new Attachment(Server.MapPath(sAttachment_name)); message.Attachments.Add(attach); message.CC.Add(hallVM.EM_emailId); if (hallVM.CFac_emailId != null) { if (IsEmailValid(hallVM.CFac_emailId) == true) { message.CC.Add(hallVM.CFac_emailId); } } message.IsBodyHtml = false; SmtpClient smtp = new SmtpClient(); smtp.UseDefaultCredentials = false; smtp.Host = "smtp.gmail.com"; //"smtp2.iitm.ac.in"; smtp.EnableSsl = true; NetworkCredential NetworkCred = new NetworkCredential("*****@*****.**", "truediamonds"); smtp.Credentials = NetworkCred; smtp.Port = 587; //465 smtp.Send(message); ViewBag.Message = "Booking Initiated .. Kindly check your email for the form to be filled and submitted for approval"; ViewBag.alert = "success"; int iSend_email_log = hbl.email_log(Convert.ToInt32(dtBooking_result.Rows[0]["reservationId"]), message.From.ToString(), message.To.ToString(), "cc1", "cc2", "cc3", message.Subject, message.Body, sAttachment_name, 0); } } catch (Exception ex) { ViewBag.Message = "Technical Error ! Kindly contact the concerned official of ICSR"; ViewBag.alert = "warning"; } } else { ViewBag.Message = "Sorry ! Booking failed . Check back for hall availability"; ViewBag.alert = "error"; } } else { ViewData["iReserved_hall"] = 0; } return(View(hallVM)); //return Json(new { success = true, data = ViewBag.Message }); } catch (Exception ex) { return(View(hallVM)); } }
public DataTable AddReservation(HallVM hallVM) { using (SqlConnection con = new SqlConnection(sConn)) { SqlCommand cmd = new SqlCommand("sp_add_reservation", con); cmd.CommandType = CommandType.StoredProcedure; #region sqlparam SqlParameter paramHallId = new SqlParameter(); paramHallId.ParameterName = "@hallId"; paramHallId.Value = hallVM.hallId; cmd.Parameters.Add(paramHallId); SqlParameter paramResTypeId = new SqlParameter(); paramResTypeId.ParameterName = "@res_typeId"; paramResTypeId.Value = hallVM.res_typeId; cmd.Parameters.Add(paramResTypeId); SqlParameter paramStartDate = new SqlParameter(); paramStartDate.ParameterName = "@start_date"; paramStartDate.Value = hallVM.start_date; cmd.Parameters.Add(paramStartDate); SqlParameter paramStartTime = new SqlParameter(); paramStartTime.ParameterName = "@start_time"; paramStartTime.Value = hallVM.start_time; cmd.Parameters.Add(paramStartTime); SqlParameter paramEndDate = new SqlParameter(); paramEndDate.ParameterName = "@end_date"; paramEndDate.Value = hallVM.end_date; cmd.Parameters.Add(paramEndDate); SqlParameter paramEndTime = new SqlParameter(); paramEndTime.ParameterName = "@end_time"; paramEndTime.Value = hallVM.end_time; cmd.Parameters.Add(paramEndTime); SqlParameter paramPrg_title = new SqlParameter(); paramPrg_title.ParameterName = "@programme_title"; paramPrg_title.Value = hallVM.programme_title; cmd.Parameters.Add(paramPrg_title); SqlParameter paramIscollaborative = new SqlParameter(); paramIscollaborative.ParameterName = "@is_collaborative"; paramIscollaborative.Value = hallVM.is_collaborative; cmd.Parameters.Add(paramIscollaborative); SqlParameter paramFac_name = new SqlParameter(); paramFac_name.ParameterName = "@facultyName"; paramFac_name.Value = hallVM.facultyName; cmd.Parameters.Add(paramFac_name); SqlParameter paramFac_depId = new SqlParameter(); paramFac_depId.ParameterName = "@deptId"; paramFac_depId.Value = hallVM.dd_fac_deptId; cmd.Parameters.Add(paramFac_depId); SqlParameter paramFac_tele = new SqlParameter(); paramFac_tele.ParameterName = "@tele_no"; paramFac_tele.Value = hallVM.fac_tele_no; cmd.Parameters.Add(paramFac_tele); SqlParameter paramFac_mobile = new SqlParameter(); paramFac_mobile.ParameterName = "@mobile_no"; paramFac_mobile.Value = hallVM.fac_mobile_no; cmd.Parameters.Add(paramFac_mobile); SqlParameter paramFac_email = new SqlParameter(); paramFac_email.ParameterName = "@emailId"; paramFac_email.Value = hallVM.fac_emailId; cmd.Parameters.Add(paramFac_email); SqlParameter param_em_name = new SqlParameter(); param_em_name.ParameterName = "@event_manager_name"; param_em_name.Value = hallVM.event_manager_name; cmd.Parameters.Add(param_em_name); SqlParameter param_em_mobile = new SqlParameter(); param_em_mobile.ParameterName = "@em_mobile_no"; param_em_mobile.Value = hallVM.EM_mobile_no; cmd.Parameters.Add(param_em_mobile); SqlParameter paramEm_email = new SqlParameter(); paramEm_email.ParameterName = "@em_emailId"; paramEm_email.Value = hallVM.EM_emailId; cmd.Parameters.Add(paramEm_email); SqlParameter paramCfac_name = new SqlParameter(); paramCfac_name.ParameterName = "@collaborative_faculty"; if (hallVM.collaborative_faculty == null) { paramCfac_name.Value = DBNull.Value; } else { paramCfac_name.Value = hallVM.collaborative_faculty; } cmd.Parameters.Add(paramCfac_name); SqlParameter paramCfac_depId = new SqlParameter(); paramCfac_depId.ParameterName = "@cfac_deptId"; if (hallVM.dd_cfac_deptId == null) { paramCfac_depId.Value = DBNull.Value; } else { paramCfac_depId.Value = hallVM.dd_cfac_deptId; } cmd.Parameters.Add(paramCfac_depId); SqlParameter paramCfac_tele = new SqlParameter(); paramCfac_tele.ParameterName = "@cfac_tele_no"; if (hallVM.CFac_tele_no == null) { paramCfac_tele.Value = DBNull.Value; } else { paramCfac_tele.Value = hallVM.CFac_tele_no; } cmd.Parameters.Add(paramCfac_tele); SqlParameter paramCfac_mobile = new SqlParameter(); paramCfac_mobile.ParameterName = "@cfac_mobile_no"; if (hallVM.CFac_mobile_no == null) { paramCfac_mobile.Value = DBNull.Value; } else { paramCfac_mobile.Value = hallVM.CFac_mobile_no; } cmd.Parameters.Add(paramCfac_mobile); SqlParameter paramCfac_email = new SqlParameter(); paramCfac_email.ParameterName = "@cfac_emailId"; if (hallVM.CFac_emailId == null) { paramCfac_email.Value = DBNull.Value; } else { paramCfac_email.Value = hallVM.CFac_emailId; } cmd.Parameters.Add(paramCfac_email); #endregion con.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dtBooking_result = new DataTable(); da.Fill(dtBooking_result); da.Dispose(); return(dtBooking_result); } }