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