public PartialViewResult AddUsingCustomers(int checkinID) { var obj = _svustomerArrive.GetRoomUsingCheckIn(checkinID); var model = new CustomeCheckInModel(); model.CheckInID = obj.CheckInID.GetValueOrDefault(); model.CustomerIdOld = obj.customerid.GetValueOrDefault(); model.Roomid = obj.roomid.GetValueOrDefault(); model.DOB = DateTime.Now.ToString("dd/MM/yyyy"); model.SysHotelID = obj.SysHotelID.GetValueOrDefault(); //model.Id = obj.Id; //model.Name = obj.Name; //model.CountryId = obj.CountryId; //model.DOB = obj.DOB.GetValueOrDefault().ToString("dd/MM/yyyy"); //model.Address = obj.Address; //model.Sex = obj.Sex; //model.TeamSTT = obj.TeamSTT; //model.TeamMergeSTT = obj.TeamMergeSTT; //model.Email = obj.Email; //model.IdentifyNumber = obj.IdentifyNumber; //model.Phone = obj.Phone; //model.Company = obj.Company; //model.Payer = true; //model.Leader = true; model.ListCountry = _svustomerArrive.getAllCountry(); return(PartialView("AddUsingCustomer", model)); }
/// <summary> /// thêm khách ở cùng /// </summary> /// <param name="obj"></param> /// <returns></returns> public ActionResult AddUsingRoom(CustomeCheckInModel obj) { //return Json(new { result = 0 }, JsonRequestBehavior.AllowGet); var rs = _svustomerArrive.AddUsingRoom(obj); return(Json(rs, JsonRequestBehavior.AllowGet)); }
public JsonRs UndoRoom(CustomeCheckInModel obj) { var rs = new JsonRs(); using (var db = _connectionData.OpenDbConnection()) { try { var usingroom = db.Single <tbl_RoomUsing>( x => x.status == 1 && x.CheckInID == obj.CheckInID && x.roomid == obj.Roomid); if (usingroom != null) { usingroom.status = 2; db.Update(usingroom); rs.Status = "01"; rs.Message = "Trả phòng thành công."; return(rs); } else { rs.Status = "00"; rs.Message = "Không tìm thấy phòng của khách hàng. Vui lòng kiểm tra lại."; } } catch (Exception e) { rs.Status = "00"; rs.Message = "Trả phòng thất bại!"; return(rs); } } return(rs); }
public JsonRs AddUsingRoom(CustomeCheckInModel obj) { var rs = new JsonRs(); using (var db = _connectionData.OpenDbConnection()) { if (obj.CustomerId > 0) { try { var usingroom = new tbl_RoomUsing(); usingroom.SysHotelID = comm.GetHotelId();// obj.SysHotelID; usingroom.CheckInID = obj.CheckInID; usingroom.customerid = obj.CustomerId; usingroom.datecreated = DateTime.Now; usingroom.roomid = obj.Roomid; usingroom.status = 2; db.Insert(usingroom); rs.Status = "01"; rs.Message = "Thêm mới khách ở cùng thàng công."; return(rs); } catch (Exception e) { rs.Status = "00"; rs.Message = "Thêm mới khách ở cùng thất bại!"; return(rs); } } else { using (var tran = db.OpenTransaction()) { DateTime DOB; DateTime.TryParse(obj.DOB, CultureInfo.GetCultureInfo("vi-vn"), DateTimeStyles.None, out DOB); try { var Customer = new tbl_Customer(); Customer.Name = obj.Name; Customer.CountryId = obj.CountryId; Customer.DOB = DOB; Customer.Address = obj.Address; Customer.Sex = obj.Sex; Customer.TeamSTT = obj.TeamSTT; Customer.TeamMergeSTT = obj.TeamMergeSTT; Customer.Email = obj.Email; Customer.IdentifyNumber = obj.IdentifyNumber; Customer.Phone = obj.Phone; Customer.Address = obj.Address; Customer.Company = obj.Company; Customer.Status = true; Customer.TeamMergeSTT = obj.TeamMergeSTT; Customer.TeamSTT = obj.TeamSTT; Customer.Payer = 0; Customer.Status = true; Customer.ReservationID = obj.CheckInID; Customer.HotelCode = comm.GetHotelCode(); Customer.SysHotelID = comm.GetHotelId(); long idCustomer = db.Insert(Customer, true); var usingroom = new tbl_RoomUsing(); usingroom.SysHotelID = comm.GetHotelId();//Customer.SysHotelID; usingroom.SysHotelCode = comm.GetHotelCode(); usingroom.CheckInID = obj.CheckInID; usingroom.customerid = (int)idCustomer;// Customer.Id; usingroom.datecreated = DateTime.Now; usingroom.roomid = obj.Roomid; usingroom.status = 2; db.Insert(usingroom); /* * var group = new tbl_CustomerGroup(); * group.Doan_ID = obj.TeamSTT; * group.Gop_Doan_ID = obj.TeamMergeSTT; * group.Customer_ID = Customer.Id; * db.Insert(group); */ tran.Commit(); rs.Status = "01"; rs.Message = "Thêm mới khách ở cùng thàng công."; return(rs); } catch (Exception) { tran.Rollback(); rs.Status = "00"; rs.Message = "Thêm mới khách ở cùng thất bại!"; return(rs); } } } } }
/// <summary> /// Trả phòng /// </summary> /// <param name="id"></param> /// <returns></returns> public JsonResult UndoRoom(CustomeCheckInModel obj) { var rs = _svustomerArrive.UndoRoom(obj); return(Json(rs, JsonRequestBehavior.AllowGet)); }