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