public JsonResult GetCheckOutInfo(int roomId)
{
//try
//{
var ios = from io in db.InOuts
where io.RoomId == roomId && io.Status == 0
select io;
if (ios != null)
{
CheckOut checkout = new CheckOut();
foreach (var io in ios)
{
checkout.CheckinTime = io.CheckinTime;
checkout.CheckInTimeStr = io.CheckinTime.ToString("dd/MM/yyyy HH:mm");
checkout.Note = io.Note;
checkout.OtherServiceAmount = io.OtherServiceAmount;
checkout.PersonNumber = io.PersonNumber;
checkout.RoomId = io.RoomId.Value;
checkout.RoomServiceType = io.RoomServiceType;
checkout.TotalAmount = io.TotalAmount;
checkout.OtherServices = new List <Models.AjaxModel.OtherService>();
try
{
foreach (InOut_OtherServices item in io.InOut_OtherServices)
{
Models.AjaxModel.OtherService os = new Models.AjaxModel.OtherService();
os.OtherServiceId = item.OtherServiceId;
os.Quantity = item.Quantity;
os.ServiceName = item.OtherService.ServiceName;
os.Amount = item.Quantity * item.OtherService.Price;
checkout.OtherServices.Add(os);
}
}
catch { }
}
var result = Json(new { success = true, data = checkout }, JsonRequestBehavior.AllowGet);
return(result);
}
else
{
return(Json(new { success = false, ErrInfo = "Không tìm thấy checkin" }, JsonRequestBehavior.AllowGet));
}
//}
//catch (Exception ex)
//{
// return Json(new { success = false, ErrInfo = ex }, JsonRequestBehavior.DenyGet);
//}
}
public ActionResult Bill(int roomId)
{
BillModel billModel = new BillModel();
var ios = from io in db.InOuts
where io.RoomId == roomId && io.Status == 0
select io;
if (ios != null && ios.Count() > 0)
{
foreach (var io in ios)
{
billModel.CheckInTimeStr = io.CheckinTime.ToString("dd/MM/yyyy HH:mm");
billModel.CheckOutTimeStr = io.CheckOutTime.ToString("dd/MM/yyyy HH:mm");
billModel.OtherServiceAmount = io.OtherServiceAmount;
billModel.PersonNumber = io.PersonNumber;
billModel.RoomServiceType = io.RoomServiceType;
billModel.TotalAmount = io.TotalAmount;
billModel.RoomServiceAmout = io.TotalAmount - io.OtherServiceAmount;
billModel.RoomName = io.Room.RoomName;
string invoiceNum = io.InOutId.ToString().PadLeft(5, '0');
billModel.InvoiceNumber = invoiceNum.Substring(invoiceNum.Length - 5);
billModel.LengthStay = io.LengthStay;
billModel.OtherServices = new List <Models.AjaxModel.OtherService>();
foreach (InOut_OtherServices item in io.InOut_OtherServices)
{
Models.AjaxModel.OtherService os = new Models.AjaxModel.OtherService();
os.OtherServiceId = item.OtherServiceId;
os.Quantity = item.Quantity;
os.ServiceName = item.OtherService.ServiceName;
os.Amount = item.Quantity * item.OtherService.Price;
billModel.OtherServices.Add(os);
}
}
}
return(View("Bill", billModel));
}
