public ActionResult DeleteConfirmed(int id)
{
PRODUCT_RESERVATION pRODUCT_RESERVATION = db.PRODUCT_RESERVATION.Find(id);
var calenderId = pRODUCT_RESERVATION.ProductCalenderId;
var categoryProductId = pRODUCT_RESERVATION.ProductCalenderId;
string backtoList = Request.Params["BacktoList"] == null ? "" : Request.Params["BacktoList"];
if (backtoList.Equals("BacktoList"))
{
PRODUCT_CALENDER p = db.PRODUCT_CALENDER.Find(pRODUCT_RESERVATION.ProductCalenderId);
if (p == null)
{
return(HttpNotFound());
}
return(RedirectToAction("Index", new { ProductCalenderId = p.Id, CategoryProductId = p.CategoryProductId }));
}
else
{
db.PRODUCT_RESERVATION.Remove(pRODUCT_RESERVATION);
db.Database.ExecuteSqlCommand("delete FROM [dbo].[PRODUCT_RESERVATION] where [BookId] = " + pRODUCT_RESERVATION.Id);
if (pRODUCT_RESERVATION.PaxId <= 0)
{
db.SP_Delete_PaxDefault(pRODUCT_RESERVATION.PaxId);
}
db.SaveChanges();
db.SP_Insert_CountReservation(calenderId);
}
return(RedirectToAction("Index", new { ProductCalenderId = calenderId, CategoryProductId = categoryProductId }));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PRODUCT_RESERVATION pRODUCT_RESERVATION = db.PRODUCT_RESERVATION.Find(id);
if (pRODUCT_RESERVATION == null)
{
return(HttpNotFound());
}
return(View(pRODUCT_RESERVATION));
}
public ActionResult Edit(int?id, int?ProductCalenderId, int?CategoryProductId, int?tourdays)
{
if (id == null)
{
return(View(" Edit HttpNotFoundReservation", HttpStatusCode.BadRequest));
}
PRODUCT_RESERVATION pRODUCT_RESERVATION = db.PRODUCT_RESERVATION.Include(a => a.PRODUCT_CALENDER).Include(a => a.PRODUCT_CALENDER.CATEGORY_PRODUCT).Include(a => a.CABIN).Where(a => a.Id == id).First();
if (pRODUCT_RESERVATION == null)
{
return(View(" EditReservation Found", HttpStatusCode.BadRequest));
}
int tu;
if (int.TryParse(Request["tourdays"].ToString(), out tu))
{
ViewBag.TourDaysId = new SelectList(db.TOUR_DAYS.Where(f => f.TourDaysId == tu), "Id", "Name", pRODUCT_RESERVATION.TourDaysId);
}
else
{
ViewBag.TourDaysId = new SelectList(db.TOUR_DAYS, "Id", "Name", pRODUCT_RESERVATION.TourDaysId);
}
ViewBag.AgencyId = new SelectList(db.AGENCY, "Id", "Name", pRODUCT_RESERVATION.AgencyId);
ViewBag.AgentId = new SelectList(db.AGENT, "ID", "FirstName", pRODUCT_RESERVATION.AgentId);
ViewBag.PaxId = new SelectList(db.PAX, "Id", "First_Name", pRODUCT_RESERVATION.PaxId);
ViewBag.PaymentTypeId = new SelectList(db.PAYMENT_TYPE, "Id", "Description", pRODUCT_RESERVATION.PaymentTypeId);
ViewBag.ProductCalenderId = new SelectList(db.PRODUCT_CALENDER, "Id", "Id", pRODUCT_RESERVATION.ProductCalenderId);
ViewBag.ProductCalenderId = new SelectList(db.PRODUCT_CALENDERHOUR, "Id", "Times", pRODUCT_RESERVATION.ProductCalenderId);
ViewBag.PaymentStatusId = new SelectList(db.PAYMENT_STATUS, "Id", "Description", pRODUCT_RESERVATION.PaymentStatusId);
ViewBag.ProductReservationTypeId = new SelectList(db.PRODUCT_RESERVATION_TYPE, "Id", "Name", pRODUCT_RESERVATION.ProductReservationTypeId);
ViewBag.DiveId = new SelectList(db.DIVE, "Id", "Name", pRODUCT_RESERVATION.DiveId);
var s = (from a in db.Cabin
from od in a.PRODUCT_RESERVATION.Where(r => r.ProductCalenderId == pRODUCT_RESERVATION.ProductCalenderId).DefaultIfEmpty()
where (a.Id != od.CabinId & a.CategoryProductId == pRODUCT_RESERVATION.PRODUCT_CALENDER.CategoryProductId)
select new
{
Id = a.Id,
Name = a.Name,
Description = a.Name + " " + a.Description,
CategoryProductId = a.CategoryProductId
})
;
ViewBag.CabinId = new SelectList(s, "Id", "Description", pRODUCT_RESERVATION.CabinId);
return(View(pRODUCT_RESERVATION));
}
public ActionResult Edit([Bind(Include = "Id,ProductCalenderId,AgentId,PaymentTypeId,PaymentStatusId,AgencyId,Description,PaxId,Price,CreateDate,TourDaysId,ProductReservationTypeId,DivePrice,DiveId,PickUp,DropOff,Restrictions,Continua,CabinId,BloqueoDate,FacturaNr,NetoPrice")] PRODUCT_RESERVATION pRODUCT_RESERVATION)
{
PRODUCT_CALENDER p = db.PRODUCT_CALENDER.Find(pRODUCT_RESERVATION.ProductCalenderId);
pRODUCT_RESERVATION.PRODUCT_CALENDER = p;
string backtoList = Request.Params["BacktoList"] == null && Request.Params["Edit"] != null ? "Edit" : Request.Params["BacktoList"];
if (backtoList.Equals("BacktoList"))
{
if (p == null)
{
return(View("HttpNotFoundReservation", HttpNotFound().StatusDescription));
}
return(RedirectToAction("Index", new { ProductCalenderId = p.Id, CategoryProductId = p.CategoryProductId }));
}
else
{
if (ModelState.IsValid)
{
if (pRODUCT_RESERVATION.PaxId == null)
{
var pax = db.SP_Insert_PaxDefault(pRODUCT_RESERVATION.ProductCalenderId.ToString());
pRODUCT_RESERVATION.PaxId = int.Parse(pax.ToString());
}
pRODUCT_RESERVATION.UserName = User.Identity.GetUserName();
pRODUCT_RESERVATION.PC_ID = System.Web.HttpContext.Current.Request.UserHostAddress == null ? HttpContext.Request.UserHostAddress : System.Web.HttpContext.Current.Request.UserHostAddress;
pRODUCT_RESERVATION.ProductReservationTypeId = pRODUCT_RESERVATION.ProductReservationTypeId == 0 ? 1 : pRODUCT_RESERVATION.ProductReservationTypeId;
pRODUCT_RESERVATION.CreateDate = pRODUCT_RESERVATION.CreateDate == null ? DateTime.Now.Date : pRODUCT_RESERVATION.CreateDate;
db.Entry(pRODUCT_RESERVATION).State = EntityState.Modified;
db.SaveChanges();
db.SP_Insert_CountReservation(pRODUCT_RESERVATION.ProductCalenderId);
db.SP_Insert_ReservationContinue(pRODUCT_RESERVATION.Id, pRODUCT_RESERVATION.ProductCalenderId, pRODUCT_RESERVATION.PRODUCT_CALENDER.CategoryProductId);
return(RedirectToAction("Index", new { ProductCalenderId = pRODUCT_RESERVATION.ProductCalenderId }));
}
ViewBag.AgencyId = new SelectList(db.AGENCY, "Id", "Name", pRODUCT_RESERVATION.AgencyId);
ViewBag.AgentId = new SelectList(db.AGENT, "ID", "FirstName", pRODUCT_RESERVATION.AgentId);
ViewBag.PaxId = new SelectList(db.PAX, "Id", "First_Name", pRODUCT_RESERVATION.PaxId);
ViewBag.PaymentTypeId = new SelectList(db.PAYMENT_TYPE, "Id", "Description", pRODUCT_RESERVATION.PaymentTypeId);
ViewBag.ProductCalenderId = new SelectList(db.PRODUCT_CALENDER, "Id", "Id", pRODUCT_RESERVATION.ProductCalenderId);
//ViewBag.ProductCalenderId = new SelectList(db.PRODUCT_CALENDERHOUR, "Id", "Times", pRODUCT_RESERVATION.ProductCalenderId);
ViewBag.PaymentStatusId = new SelectList(db.PAYMENT_STATUS, "Id", "Description", pRODUCT_RESERVATION.PaymentStatusId);
ViewBag.TourDaysId = new SelectList(db.TOUR_DAYS, "Id", "Name", pRODUCT_RESERVATION.TourDaysId);
ViewBag.ProductReservationTypeId = new SelectList(db.PRODUCT_RESERVATION_TYPE, "Id", "Name", pRODUCT_RESERVATION.ProductReservationTypeId);
ViewBag.DiveId = new SelectList(db.DIVE, "Id", "Name", pRODUCT_RESERVATION.DiveId);
var s = (from a in db.Cabin
from od in a.PRODUCT_RESERVATION.Where(r => r.ProductCalenderId == pRODUCT_RESERVATION.ProductCalenderId).DefaultIfEmpty()
where (a.Id != od.CabinId & a.CategoryProductId == pRODUCT_RESERVATION.PRODUCT_CALENDER.CategoryProductId)
select new
{
Id = a.Id,
Name = a.Name,
Description = a.Name + " " + a.Description,
CategoryProductId = a.CategoryProductId
})
;
ViewBag.CabinId = new SelectList(s, "Id", "Description", pRODUCT_RESERVATION.CabinId);
return(View(pRODUCT_RESERVATION));
}
}
public ActionResult Create([Bind(Include = "Id,ProductCalenderId,AgentId,PaymentTypeId,PaymentStatusId,AgencyId,Description,PaxId,Price,CreateDate,TourDaysId,ProductReservationTypeId,DivePrice,DiveId,PickUp,DropOff,Restrictions,Continua,CabinId,BloqueoDate,FacturaNr,NetoPrice")] PRODUCT_RESERVATION pRODUCT_RESERVATION)
{
string backtoList = Request.Params["BacktoList"] == null && Request.Params["Create"] != null ? "Create" : Request.Params["BacktoList"];
if (backtoList.Equals("BacktoList"))
{
string calId = Request.Params["ProductCalenderId"];
int id = 0;
if (calId.Length > 0)
{
id = int.Parse(calId);
PRODUCT_CALENDER p = db.PRODUCT_CALENDER.Where(s => s.Id == id).FirstOrDefault();
if (p == null)
{
return(View(" Create HttpNotFoundReservation", HttpStatusCode.BadRequest));
}
}
return(RedirectToAction("Index", new { ProductCalenderId = id }));
}
else
{
if (backtoList.Equals(""))
{
return(HttpNotFound());
}
if (ModelState.IsValid)
{
int cid = Request.Params["ProductCalenderId"] == null ? pRODUCT_RESERVATION.Id : int.Parse(Request.Params["ProductCalenderId"].ToString());
int cuantas = 1;
if (Request.Form["CuantaVeces"] != null)
{
cuantas = int.Parse(Request.Form["CuantaVeces"].ToString()) == 0 ? 1 : int.Parse(Request.Form["CuantaVeces"].ToString());
}
for (int i = 0; i < cuantas; i++)
{
// SET @ID = SCOPE_IDENTITY()
int paxId = db.SP_Insert_PaxDefault((i + 1).ToString() + "pax ");
pRODUCT_RESERVATION.PaxId = paxId;
pRODUCT_RESERVATION.UserName = User.Identity.GetUserName();
pRODUCT_RESERVATION.PC_ID = System.Web.HttpContext.Current.Request.UserHostAddress == null ? HttpContext.Request.UserHostAddress : System.Web.HttpContext.Current.Request.UserHostAddress;
pRODUCT_RESERVATION.CreateDate = DateTime.Now;
pRODUCT_RESERVATION.ProductCalenderId = db.PRODUCT_CALENDER.Find(cid).Id;
db.PRODUCT_RESERVATION.Add(pRODUCT_RESERVATION);
db.SaveChanges();
}
db.SP_Insert_CountReservation(pRODUCT_RESERVATION.ProductCalenderId);
PRODUCT_CALENDER p = db.PRODUCT_CALENDER.Find(pRODUCT_RESERVATION.ProductCalenderId);
pRODUCT_RESERVATION.PRODUCT_CALENDER = p;
if (pRODUCT_RESERVATION.PRODUCT_CALENDER.CategoryProductId == 5)
{
db.SP_Insert_ReservationContinue(pRODUCT_RESERVATION.Id, pRODUCT_RESERVATION.ProductCalenderId, pRODUCT_RESERVATION.PRODUCT_CALENDER.CategoryProductId);
}
return(RedirectToAction("Index", new { ProductCalenderId = pRODUCT_RESERVATION.ProductCalenderId }));
}
ViewBag.AgencyId = new SelectList(db.AGENCY.OrderByDescending(a => a.Name), "Id", "Name", pRODUCT_RESERVATION.AgencyId);
ViewBag.AgentId = new SelectList(db.AGENT.OrderByDescending(a => a.FirstName), "ID", "FirstName", pRODUCT_RESERVATION.AgentId);
ViewBag.PaxId = new SelectList(db.PAX, "Id", "First_Name", pRODUCT_RESERVATION.PaxId);
ViewBag.PaymentTypeId = new SelectList(db.PAYMENT_TYPE, "Id", "Description", pRODUCT_RESERVATION.PaymentTypeId);
ViewBag.ProductCalenderId = pRODUCT_RESERVATION.ProductCalenderId;
ViewBag.PaymentStatusId = new SelectList(db.PAYMENT_STATUS, "Id", "Description", pRODUCT_RESERVATION.PaymentStatusId);
var s = (from a in db.Cabin
from od in a.PRODUCT_RESERVATION.Where(r => r.ProductCalenderId == pRODUCT_RESERVATION.ProductCalenderId).DefaultIfEmpty()
where (a.Id != od.CabinId & a.CategoryProductId == pRODUCT_RESERVATION.PRODUCT_CALENDER.CategoryProductId)
select new
{
Id = a.Id,
Name = a.Name,
Description = a.Name + " " + a.Description,
CategoryProductId = a.CategoryProductId
})
;
ViewBag.CabinId = new SelectList(s, "Id", "Description", pRODUCT_RESERVATION.CabinId);
int tu;
if (int.TryParse(Request["tourdays"].ToString(), out tu))
{
ViewBag.TourDaysId = new SelectList(db.TOUR_DAYS.Where(f => f.TourDaysId == tu), "Id", "Name", pRODUCT_RESERVATION.TourDaysId);
}
else
{
ViewBag.TourDaysId = new SelectList(db.TOUR_DAYS, "Id", "Name", pRODUCT_RESERVATION.TourDaysId);
}
ViewBag.ProductReservationTypeId = new SelectList(db.PRODUCT_RESERVATION_TYPE, "Id", "Name", pRODUCT_RESERVATION.ProductReservationTypeId);
ViewBag.DiveId = new SelectList(db.DIVE, "Id", "Name", pRODUCT_RESERVATION.DiveId);
return(View(pRODUCT_RESERVATION));
}
}