public ActionResult Checkavailablity() { List <Addasset> assetlist = db.addasset.ToList(); ViewBag.list = new SelectList(assetlist, "asset", "asset"); BookinView bv = new BookinView(); return(View(bv)); }
public ActionResult Book(string str = "") { BookinView bv = new BookinView(); List <Addasset> assetlist = db.addasset.ToList(); ViewBag.list = new SelectList(assetlist, "asset", "asset"); return(View(bv)); }
public ActionResult Checkavailablity(BookModel model) { List <Addasset> assetlist = db.addasset.ToList(); ViewBag.list = new SelectList(assetlist, "asset", "asset"); if (ModelState.IsValid) { string dept = Request["department"]; string date = Request["date"]; string members = Request["members"]; string asset = model.asset; TimeSpan itime = TimeSpan.Parse(Request["intime"]); TimeSpan otime = TimeSpan.Parse(Request["outtime"]); var list = db.bookm.Where(x => x.date == date && x.intime >= itime && x.outtime <= otime && x.asset.Equals(model.asset)).ToList(); if (list.Count == 0) { TempData["avaiable"] = asset + " are available for booking for the date " + date + " and " + itime + " and " + otime + ""; Session["dept"] = dept; Session["asset"] = asset; Session["date"] = date; Session["itime"] = itime; Session["otime"] = otime; Session["asset"] = model.asset; Session["members"] = Request["members"]; return(RedirectToAction("Book")); } else { BookinView bv = new BookinView { book = db.bookm.Where(x => x.date == date && x.intime >= itime && x.outtime <= otime).ToList() }; return(View(bv)); } } return(View()); }
public ActionResult Book(BookModel model, register reg) { List <Addasset> assetlist = db.addasset.ToList(); ViewBag.list = new SelectList(assetlist, "asset", "asset"); string date = Request["date"]; string asset = Request["asset"]; TimeSpan itime = TimeSpan.Parse(Request["intime"]); TimeSpan otime = TimeSpan.Parse(Request["outtime"]); var items = db.bookm.Where(x => x.date == date && x.intime >= itime && x.outtime <= otime && x.asset == asset).SingleOrDefault(); if (items == null) { var regs = db.regmodel.Where(x => x.phone.Equals(reg.check) && x.pin.Equals(reg.pin) || x.email.Equals(reg.check) && x.pin.Equals(reg.pin)).SingleOrDefault(); if (regs != null) { var email = (from a in db.regmodel where a.phone.Equals(reg.check) || a.email.Equals(reg.check) select new { a.email, a.name, a.phone }).SingleOrDefault(); string Email = email.email; model.name = email.name; model.phone = email.phone; model.email = email.email; db.bookm.Add(model); model.status = "pending"; db.bookm.Add(model); db.SaveChanges(); try { var sendmail = new MailAddress("enter your valid email address", "Akhil"); var receiver = new MailAddress(Email, "Buddy"); var password = ""; //enter your email password var subject = "Request for Asset!!"; var body = "This is regarding the request by " + model.name + " for the " + model.asset + "on " + date + "from" + itime + "to" + otime; var smptp = new SmtpClient { Host = "smtp.gmail.com", Port = 587, EnableSsl = true, DeliveryMethod = SmtpDeliveryMethod.Network, UseDefaultCredentials = false, Credentials = new NetworkCredential(sendmail.Address, password) }; using (var mess = new MailMessage(sendmail, receiver) { Subject = subject, Body = body, }) { smptp.Send(mess); } TempData["status"] = "Please keep on checking your mail.Booking is Confirmed for " + date + " and " + itime + " and " + otime + ""; return(RedirectToAction("Index")); } catch { TempData["probblem"] = "Problem while sending email, Please check details."; } } else { ViewBag.notauser = "******"; RedirectToAction("Book"); } } else { BookinView bv = new BookinView { book = db.bookm.Where(x => x.date == date && x.intime >= itime && x.outtime <= otime).ToList() }; return(View(bv)); } return(View()); }