public ActionResult Edit(CMS_ReservationViewModels model)
{
try
{
if (!ModelState.IsValid)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(PartialView("_Edit", model));
}
var msg = "";
model.CreatedBy = CurrentUser.UserId;
model.UpdatedBy = CurrentUser.UserId;
var result = _fac.CreateOrUpdate(model, ref msg);
if (result)
{
return(RedirectToAction("Index"));
}
ModelState.AddModelError("CustomerName", msg);
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(PartialView("_Edit", model));
}
catch (Exception ex)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(PartialView("_Edit", model));
}
}
public ActionResult Delete(CMS_ReservationViewModels model)
{
try
{
if (!ModelState.IsValid)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(PartialView("_Delete", model));
}
var msg = "";
var result = _fac.Delete(model.Id, ref msg);
if (result)
{
return(RedirectToAction("Index"));
}
ModelState.AddModelError("CustomerName", msg);
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(PartialView("_Delete", model));
}
catch (Exception ex)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(PartialView("_Delete", model));
}
}
public CMS_ReservationViewModels GetDetail(string Id)
{
CMS_ReservationViewModels model = new CMS_ReservationViewModels();
model = _fac.GetDetail(Id);
return(model);
}
public CMS_ReservationViewModels GetDetail(string Id)
{
NSLog.Logger.Info("CateReservationDetail", Id);
CMS_ReservationViewModels result = null;
try
{
using (var cxt = new CMS_Context())
{
var data = cxt.CMS_Reservation.Where(o => o.ID == Id && o.Status != (byte)Commons.EStatus.Deleted)
.Join(cxt.CMS_ReservationDetail, r => r.ID, d => d.ReservationID, (r, d) => new { r, d })
.Select(o => new CMS_ReservationViewModels
{
Id = o.r.ID,
CustomerName = o.r.CustomerName,
Phone = o.r.Mobile,
BookDay = o.r.Date,
//FromTime = o.r.Date-o.r.Date.Date,
Remark = o.r.Remark,
ProductID = o.d.ProductID,
ProductName = o.d.ProductName,
}).FirstOrDefault();
data.FromTime = data.BookDay - data.BookDay.Date;
result = data;
NSLog.Logger.Info("ResponseReservationGetDetail", result);
}
}
catch (Exception ex)
{
NSLog.Logger.Error("ErrorReservationGetDetail", ex);
}
return(result);
}
public ActionResult Index(CMS_ReservationViewModels model)
{
try
{
if (!ModelState.IsValid || model.IsSuccess == true)
{
model.ListProducts = _facProduct.GetList((byte)CMS_Common.Commons.EProductType.Procudure);
model.ListCustomer = _facCus.GetList();
model.ListEmployees = _facEmp.GetList();
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(View(model));
}
var msg = "";
var result = _fac.CreateOrUpdate(model, ref msg);
if (result)
{
model = new CMS_ReservationViewModels();
model.IsSuccess = true;
return(RedirectToAction("Success"));
}
else
{
model.IsSuccess = false;
return(View(model));
}
}
catch (Exception ex)
{
NSLog.Logger.Error("Reservation Index", ex);
return(new HttpStatusCodeResult(400, ex.Message));
}
}
// GET: Reservation
public ActionResult Index()
{
var model = new CMS_ReservationViewModels();
try
{
model.ListProducts = _facProduct.GetList((byte)CMS_Common.Commons.EProductType.Procudure);
model.ListCustomer = _facCus.GetList();
model.ListEmployees = _facEmp.GetList();
}
catch (Exception ex)
{
NSLog.Logger.Error("Reservation Index", ex);
}
return(View(model));
}
public ActionResult Create()
{
CMS_ReservationViewModels model = new CMS_ReservationViewModels();
return(PartialView("_Create", model));
}
public bool CreateOrUpdate(CMS_ReservationViewModels model, ref string msg)
{
NSLog.Logger.Info("ReservationCreateOrUpdate", model);
var Result = true;
using (var cxt = new CMS_Context())
{
try
{
if (string.IsNullOrEmpty(model.Id)) /* insert */
{
var e = new CMS_Reservation
{
ID = Guid.NewGuid().ToString(),
CustomerName = model.CustomerName,
Mobile = model.Phone,
Date = model.BookDay.Date.AddMinutes(model.FromTime.TotalMinutes),
Remark = model.Remark,
StoreID = model.StoreID,
Status = (byte)Commons.EStatus.Actived,
CreatedDate = DateTime.Now,
CreatedUser = string.IsNullOrEmpty(model.CreatedBy)? model.CustomerName: model.CreatedBy,
ModifiedUser = string.IsNullOrEmpty(model.CreatedBy) ? model.CustomerName : model.CreatedBy,
LastModified = DateTime.Now,
};
cxt.CMS_Reservation.Add(e);
var reDtl = new CMS_ReservationDetail()
{
ID = Guid.NewGuid().ToString(),
ReservationID = e.ID,
ProductID = model.ProductID,
ProductName = model.ProductName,
Status = (byte)Commons.EStatus.Actived,
CreatedDate = DateTime.Now,
CreatedUser = string.IsNullOrEmpty(model.CreatedBy) ? model.CustomerName : model.CreatedBy,
ModifiedUser = string.IsNullOrEmpty(model.CreatedBy) ? model.CustomerName : model.CreatedBy,
LastModified = DateTime.Now,
};
cxt.CMS_ReservationDetail.Add(reDtl);
}
else /* updated */
{
var e = cxt.CMS_Reservation.Find(model.Id);
if (e != null)
{
e.CustomerName = model.CustomerName;
e.Mobile = model.Phone;
e.Date = model.BookDay.Date.AddMinutes(model.FromTime.TotalMinutes);
e.Remark = model.Remark;
e.ModifiedUser = model.CreatedBy;
e.LastModified = DateTime.Now;
var reDtl = cxt.CMS_ReservationDetail.Where(o => o.ReservationID == e.ID).FirstOrDefault();
if (reDtl != null)
{
reDtl.ProductID = model.ProductID;
reDtl.ProductName = model.ProductName;
reDtl.ModifiedUser = string.IsNullOrEmpty(model.CreatedBy) ? model.CustomerName : model.CreatedBy;
reDtl.LastModified = DateTime.Now;
}
}
else
{
Result = false;
msg = "Unable to find Reservation.";
}
}
cxt.SaveChanges();
NSLog.Logger.Info("ResponseReservationCreateOrUpdate", new { Result, msg });
}
catch (Exception ex)
{
Result = false;
msg = "Vui lòng kiểm tra đường truyền";
NSLog.Logger.Error("ErrorReservationCreateOrUpdate", ex);
}
}
return(Result);
}
