protected void b1_Click(object sender, EventArgs e)
{
DataClasses1DataContext db = new DataClasses1DataContext();
HOTEL h = new HOTEL();
h.hotel_email = hotel_email.Text;
Session["h_email"] = hotel_email.Text;
h.HOTEL_NAME = name.Text;
h.STREET = street.Text;
h.CITY = city.Text;
h.STATE = state.SelectedValue.ToString();
// if (pwd.Text == pwd2.Text)
{
h.password = pwd.Text;
}
// else {
// }
h.PHONE1 = Convert.ToInt32(no1.Text);
h.PHONE2 = Convert.ToInt32(no2.Text);
h.ROOM_COST = Convert.ToInt32(cost.Text);
HttpPostedFile postedfile = fu1.PostedFile;
postedfile.SaveAs(Server.MapPath("~/Hotel_pics/") + Path.GetFileName(postedfile.FileName));
h.pic = "~/Hotel_pics/" + postedfile.FileName;
db.HOTELs.InsertOnSubmit(h);
db.SubmitChanges();
Response.Redirect("HotelProfile.aspx");
}
public ActionResult DeleteConfirmed(int id)
{
HOTEL hOTEL = db.HOTELs.Find(id);
db.HOTELs.Remove(hOTEL);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "HotelId,HotelName,HotelDesc,HotelLocation,IdealPrice")] HOTEL hOTEL)
{
if (ModelState.IsValid)
{
db.Entry(hOTEL).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(hOTEL));
}
protected void Button1_Click(object sender, EventArgs e)
{
var db = new DataClasses1DataContext();
HOTEL h = new HOTEL();
Session["h_id"] = Request.QueryString["hotel_id"];
h = db.HOTELs.SingleOrDefault(i => i.hotel_id == Convert.ToInt32(Session["h_id"]));
Session["h_price"] = h.ROOM_COST;
Response.Redirect("HotelBooking.aspx");
}
public ActionResult EditHotel(HOTEL hotel, HttpPostedFileBase fileUpload)
{
//var temp = db.SANPHAMs.SingleOrDefault(p => p.MaSP == sanpham.MaSP);
//ViewBag.MaDM = new SelectList(db.DANHMUCs.ToList().OrderBy(n => n.TenDM), "MaDM", "TenDM", sanpham.MaDM);
//if (fileUpload == null)
//{
// TempData["msg"] = "<script>alert('Sửa thành công!');</script>";
// temp.Ngaycapnhat = DateTime.Now;
// UpdateModel(temp);
// db.SubmitChanges();
// return RedirectToAction("Sanpham");
//}
////Them vao CSDL
//else
//{
// if (ModelState.IsValid)
// {
// //Luu ten file, luu y bo sung thu vien using System.IO;
// var fileName = Path.GetFileName(fileUpload.FileName);
// //Luu duong dan cua file
// var path = Path.Combine(Server.MapPath("~/images"), fileName);
// //Kiem tra hinh anh ton tai chua
// if (System.IO.File.Exists(path))
// {
// ViewBag.Thongbao = "Hình ảnh đã tồn tại";
// }
// else
// {
// //Luu hinh anh vao duong dan
// fileUpload.SaveAs(path);
// }
// temp.Hinhanh = fileName;
// temp.Ngaycapnhat = DateTime.Now;
// //Luu vao CSDL
// UpdateModel(temp);
// db.SubmitChanges();
// TempData["msg"] = "<script>alert('Sửa thành công!');</script>";
// }
if (ModelState.IsValid)
{
try
{
HOTEL model = db.HOTELs.Single(x => x.ID_HOTEL == hotel.ID_HOTEL);
model.NAME_HOTEL = hotel.NAME_HOTEL; //ve them cac field con lai
//model = hotel;
db.SaveChanges();
}
catch (Exception ex)
{
return(RedirectToAction("Error", new { msg = ex.Message }));
}
}
return(RedirectToAction("Hotel"));
}
public ActionResult Create([Bind(Include = "HotelId,HotelName,HotelDesc,HotelLocation,IdealPrice")] HOTEL hOTEL)
{
if (ModelState.IsValid)
{
db.HOTELs.Add(hOTEL);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(hOTEL));
}
public ActionResult Edit([Bind(Include = "HotelId,CiudadId,NomHotel")] HOTEL hOTEL)
{
if (ModelState.IsValid)
{
db.Entry(hOTEL).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CiudadId = new SelectList(db.Ciudades, "CiudadId", "Nombre", hOTEL.CiudadId);
return(View(hOTEL));
}
public ActionResult EditHotel(int id)
{
//Lay doi tuong sanpham theo ma
HOTEL hotel = db.HOTELs.SingleOrDefault(n => n.ID_HOTEL == id);
if (hotel == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(hotel));
}
public ActionResult Create([Bind(Include = "HotelId,CiudadId,NomHotel")] HOTEL hOTEL)
{
if (ModelState.IsValid)
{
db.Hoteles.Add(hOTEL);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CiudadId = new SelectList(db.Ciudades, "CiudadId", "Nombre", hOTEL.CiudadId);
return(View(hOTEL));
}
// GET: HOTELs/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HOTEL hOTEL = db.HOTELs.Find(id);
if (hOTEL == null)
{
return(HttpNotFound());
}
return(View(hOTEL));
}
// GET: HOTELs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HOTEL hOTEL = db.Hoteles.Find(id);
if (hOTEL == null)
{
return(HttpNotFound());
}
ViewBag.CiudadId = new SelectList(db.Ciudades, "CiudadId", "Nombre", hOTEL.CiudadId);
return(View(hOTEL));
}
protected void Book_Click(object sender, EventArgs e)
{
var db = new DataClasses1DataContext();
HOTEL h = new HOTEL();
UserInfo u = new UserInfo();
HOTEL_BOOKING hb = new HOTEL_BOOKING();
h = db.HOTELs.SingleOrDefault(i => i.hotel_id == Convert.ToInt32(Session["h_id"]));
u = db.UserInfos.SingleOrDefault(i => i.Email == Session["email"].ToString());
hb.user_email = u.Email;
hb.hotel_id = h.hotel_id;
hb.PERSONS = Convert.ToInt32(no_of_person.SelectedValue);
hb.Total_Cost = Convert.ToInt32(no_of_person.SelectedValue) * Convert.ToInt32(Session["h_price"]);
db.HOTEL_BOOKINGs.InsertOnSubmit(hb);
db.SubmitChanges();
Response.Redirect("myHotels.aspx");
}
public ActionResult CreateHotel(HOTEL hotel, HttpPostedFileBase fileUpload)
{
if (db.HOTELs.Any(x => x.ID_HOTEL == hotel.ID_HOTEL))
{
hotel.ID_HOTEL = db.HOTELs.Max(x => x.ID_HOTEL) + 1;
}
if (fileUpload == null)
{
return(View());
}
if (ModelState.IsValid)
{
var fileName = Path.GetFileName(fileUpload.FileName);
//Luu duong dan cua file
var path = Path.Combine(Server.MapPath("~/Images"), fileName);
//Kiem tra hinh anh ton tai chua
if (System.IO.File.Exists(path))
{
ViewBag.Message = "Image was existed ! Please choose another image.";
return(View());
}
else
{
//Luu hinh anh vao duong dan
fileUpload.SaveAs(path);
hotel.IMAGE_HOTEL = path;
}
try
{
db.HOTELs.Add(hotel);
db.SaveChanges();
}
catch (Exception ex)
{
return(RedirectToAction("Error", new { msg = ex.Message }));
}
}
else
{
return(View());
}
return(RedirectToAction("Hotel"));
}
public string getAccreditStatus(string accommoId)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
HOTEL updateAccred = (from accommo in db.HOTELs
where accommo.HOTEL_ID.Equals(Convert.ToInt32(accommoId))
select accommo).Single();
return(updateAccred.ACCRED_STATUS);
}
}
catch (Exception)
{
return("Failed to get status");
}
}
public ActionResult DeleteHotel(int id, int?aaa)
{
try
{
HOTEL hotel = db.HOTELs.SingleOrDefault(n => n.ID_HOTEL == id);
if (hotel == null)
{
Response.StatusCode = 404;
return(null);
}
db.HOTELs.Remove(hotel);
db.SaveChanges();
return(RedirectToAction("Hotel"));
}
catch (Exception ex)
{
return(RedirectToAction("Error", new { msg = ex.Message }));
}
//return View();
}
public string cancelAccredit(string accommoId)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
HOTEL updateAccred = new HOTEL();
updateAccred = (from accommo in db.HOTELs
where accommo.HOTEL_ID.Equals(Convert.ToInt32(accommoId))
select accommo).Single();
updateAccred.ACCRED_STATUS = "CANCELLED";
db.SubmitChanges();
return("Success Cancellation made");
}
}
catch (Exception)
{
return("Failed to perform cancellation");
}
}
public string accreditAccommo(string accommoId)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
HOTEL updateAccred = (from accommo in db.HOTELs
where accommo.HOTEL_ID.Equals(Convert.ToInt32(accommoId))
select accommo).Single();
updateAccred.ACCRED_STATUS = "ACCREDITED";
updateAccred.ACCRED_START_DATE = Convert.ToDateTime(DateTime.Now.AddYears(1).Year.ToString() + "-01-01");
updateAccred.ACCRED_EXPIRY_DATE = Convert.ToDateTime(AccreditationDuration.computeDuration());
db.SubmitChanges();
return("Success Accreditation made");
}
}
catch (Exception)
{
return("Failed to perform accreditation");
}
}
public ActionResult CreateHotel()
{
HOTEL model = new HOTEL();
return(View(model));
}
