//Hiennv public List<BookingRStatusPayViewEN> GetListUnPayBookingR_ByIDBookingR(int IDBookingR) { List<vw__PaymentInfo__BookingRs_BookingRooms_Customers> aListTemp = new List<vw__PaymentInfo__BookingRs_BookingRooms_Customers>(); int?[] BookingRoomStatus = new int?[] { 3, 5, 7 }; aListTemp = aDatabaseDA.vw__PaymentInfo__BookingRs_BookingRooms_Customers.Where(c => c.BookingRs_ID == IDBookingR).Where(e => BookingRoomStatus.Contains(e.BookingRooms_Status)).ToList(); List<BookingRStatusPayViewEN> aListReturn = new List<BookingRStatusPayViewEN>(); BookingRStatusPayViewEN aBookingRStatusPayViewEN; CompaniesBO aCompaniesBO = new CompaniesBO(); for (int i = 0; i < aListTemp.Count; i++) { aBookingRStatusPayViewEN = new BookingRStatusPayViewEN(); aBookingRStatusPayViewEN.IDBookingR = aListTemp[i].BookingRs_ID; aBookingRStatusPayViewEN.CreatedDate = aListTemp[i].BookingRs_CreatedDate; aBookingRStatusPayViewEN.Customer_Name = aListTemp[i].Customers_Name; aBookingRStatusPayViewEN.Subject = aListTemp[i].BookingRs_Subject; aBookingRStatusPayViewEN.IDCustomer = aListTemp[i].Customers_ID; aBookingRStatusPayViewEN.IDCustomerGroup = aListTemp[i].CustomerGroups_ID; aBookingRStatusPayViewEN.BookingRs_Status = aListTemp[i].BookingRs_Status; int IDCompany = !String.IsNullOrEmpty(aListTemp[i].CustomerGroups_IDCompany.ToString()) ? Convert.ToInt32(aListTemp[i].CustomerGroups_IDCompany) : 0; Companies aCompanies = aCompaniesBO.Select_ByID(IDCompany); aBookingRStatusPayViewEN.NameCompany = aCompanies.Name; aBookingRStatusPayViewEN.CustomerGroups_Name = aListTemp[i].CustomerGroups_Name; aBookingRStatusPayViewEN.StatusPay = aListTemp[i].BookingRs_StatusPay; aBookingRStatusPayViewEN.BookingMoney = aListTemp[i].BookingRs_BookingMonye; aBookingRStatusPayViewEN.IDBookingRoom = aListTemp[i].BookingRooms_ID; aBookingRStatusPayViewEN.Sku = aListTemp[i].Rooms_Sku; aBookingRStatusPayViewEN.BookingStatus = aListTemp[i].BookingRooms_Status; aBookingRStatusPayViewEN.BookingRooms_CodeRoom = aListTemp[i].BookingRooms_CodeRoom; switch (aBookingRStatusPayViewEN.StatusPay) { case 1: aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Chưa thanh toán"; break; case 2: aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Tạm ứng"; break; case 3: aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Đã thanh toán"; break; default: aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Chưa xác định"; break; } switch (aBookingRStatusPayViewEN.BookingStatus) { case 3: aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Đã check in"; break; case 5: aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Pending"; break; case 7: aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Đã check out nhưng chưa thanh toán"; break; case 8: aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Đã thanh toán"; break; default: aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Chưa xác định"; break; } aListReturn.Add(aBookingRStatusPayViewEN); } return aListReturn; }
//Ngoc da sua lai ten ham 26/12/2014 public List<BookingRStatusPayViewEN> GetListBookingRByStatus(DateTime? From, DateTime? To, int? CustomerType, string StatusPay) { List<sp_BookingRsExt_GetInfo_ByTime_ByCustomerType_ByStatusPay_Result> aListTemp = new List<sp_BookingRsExt_GetInfo_ByTime_ByCustomerType_ByStatusPay_Result>(); aListTemp = aDatabaseDA.sp_BookingRsExt_GetInfo_ByTime_ByCustomerType_ByStatusPay(From, To, CustomerType, StatusPay).ToList(); List<BookingRStatusPayViewEN> aListReturn = new List<BookingRStatusPayViewEN>(); BookingRStatusPayViewEN aBookingRStatusPayViewEN; CompaniesBO aCompaniesBO = new CompaniesBO(); List<Companies> aListCompaniesTemp = aCompaniesBO.Select_All(); BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO(); List<BookingRooms> aListBookingRoomTemp = aBookingRoomsBO.Select_All(); for (int i = 0; i < aListTemp.Count; i++) { aBookingRStatusPayViewEN = new BookingRStatusPayViewEN(); aBookingRStatusPayViewEN.IDBookingR = aListTemp[i].BookingRs_ID; aBookingRStatusPayViewEN.CreatedDate = aListTemp[i].BookingRs_CreatedDate; aBookingRStatusPayViewEN.Customer_Name = aListTemp[i].Customers_Name; aBookingRStatusPayViewEN.Subject = aListTemp[i].BookingRs_Subject; aBookingRStatusPayViewEN.IDCustomer = aListTemp[i].Customers_ID; aBookingRStatusPayViewEN.IDCustomerGroup = aListTemp[i].CustomerGroups_ID; aBookingRStatusPayViewEN.BookingRs_Status = aListTemp[i].BookingRs_Status; aBookingRStatusPayViewEN.CustomerGroups_Name = aListTemp[i].CustomerGroups_Name; int IDCompany = !String.IsNullOrEmpty(aListTemp[i].Companies_ID.ToString()) ? Convert.ToInt32(aListTemp[i].Companies_ID) : 0; if (aListCompaniesTemp.Where(c => c.ID == IDCompany).ToList().Count > 0) { aBookingRStatusPayViewEN.NameCompany = aListCompaniesTemp.Where(c => c.ID == IDCompany).ToList()[0].Name; } else { aBookingRStatusPayViewEN.NameCompany = string.Empty; } aBookingRStatusPayViewEN.StatusPay = aListTemp[i].BookingRs_StatusPay; aBookingRStatusPayViewEN.BookingMoney = aListTemp[i].BookingRs_BookingMoney; aBookingRStatusPayViewEN.Sku = aListTemp[i].Rooms_Sku; aBookingRStatusPayViewEN.IDBookingH = aListTemp[i].BookingRs_BookingHs_IDBookingH; aBookingRStatusPayViewEN.BookingHs_Status = aListTemp[i].BookingHs_Status; aBookingRStatusPayViewEN.BookingHs_StatusPay = aListTemp[i].BookingHs_StatusPay; aBookingRStatusPayViewEN.BookingHs_Type = aListTemp[i].BookingHs_Type; aBookingRStatusPayViewEN.BookingHs_Disable = aListTemp[i].BookingHs_Disable; aBookingRStatusPayViewEN.BookingHs_Subject = aListTemp[i].BookingHs_Subject; List<BookingRooms> aListBookingRooms = aListBookingRoomTemp.Where(br => br.IDBookingR == aListTemp[i].BookingRs_ID && br.CodeRoom == aListTemp[i].Rooms_Code).ToList(); if (aListBookingRooms.Count > 0) { switch (aListBookingRooms[0].Status) { case 3: aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Đã check in"; break; case 5: aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Pending"; break; case 7: aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Đã check out nhưng chưa thanh toán"; break; case 8: aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Đã thanh toán"; break; default: aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Chưa xác định"; break; } aBookingRStatusPayViewEN.IDBookingRoom = aListBookingRooms[0].ID; aBookingRStatusPayViewEN.BookingRooms_CodeRoom = aListBookingRooms[0].CodeRoom; aBookingRStatusPayViewEN.CheckInActual = aListBookingRooms[0].CheckInActual; aBookingRStatusPayViewEN.CheckOut = aListBookingRooms[0].CheckOutPlan; } switch (aBookingRStatusPayViewEN.StatusPay) { case 1: aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Chưa thanh toán"; break; case 2: aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Tạm ứng"; break; case 3: aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Đã thanh toán"; break; default: aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Chưa xác định"; break; } switch (aListTemp[i].BookingRs_CustomerType) { case 1: aBookingRStatusPayViewEN.CustomerTypeDisplay = "Nhà nước"; break; case 2: aBookingRStatusPayViewEN.CustomerTypeDisplay = "Khách đoàn"; break; case 3: aBookingRStatusPayViewEN.CustomerTypeDisplay = "Khách lẻ"; break; case 4: aBookingRStatusPayViewEN.CustomerTypeDisplay = "Khách vãng lai"; break; case 5: aBookingRStatusPayViewEN.CustomerTypeDisplay = "Khách bộ ngoại giao"; break; default: aBookingRStatusPayViewEN.CustomerTypeDisplay = "Chưa xác định"; break; } aListReturn.Add(aBookingRStatusPayViewEN); } return aListReturn; }
public List<BookingRStatusPayViewEN> GetListUnPayBookingR(DateTime From, DateTime To, int CustomerType, string StatusPay) { BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO(); try { List<sp_BookingRsExt_GetInfo_ByTime_ByCustomerType_ByStatusPay_Result> aListSP = new List<sp_BookingRsExt_GetInfo_ByTime_ByCustomerType_ByStatusPay_Result>(); aListSP = aDatabaseDA.sp_BookingRsExt_GetInfo_ByTime_ByCustomerType_ByStatusPay(From, To, CustomerType, StatusPay).ToList(); List<BookingRStatusPayViewEN> aListBookingR = new List<BookingRStatusPayViewEN>(); BookingRStatusPayViewEN aBookingRStatusPayViewEN = new BookingRStatusPayViewEN(); for (int i = 0; i < aListSP.Count; i++) { aBookingRStatusPayViewEN = new BookingRStatusPayViewEN(); aBookingRStatusPayViewEN.IDBookingR = aListSP[i].BookingRs_ID; aBookingRStatusPayViewEN.CreatedDate = aListSP[i].BookingRs_CreatedDate; aBookingRStatusPayViewEN.Customer_Name = aListSP[i].Customers_Name; aBookingRStatusPayViewEN.Subject = aListSP[i].BookingRs_Subject; aBookingRStatusPayViewEN.IDCustomer = Convert.ToInt32(aListSP[i].Customers_ID.ToString()); aBookingRStatusPayViewEN.IDCustomerGroup = Convert.ToInt32(aListSP[i].CustomerGroups_ID.ToString()); aBookingRStatusPayViewEN.CustomerGroups_Name = aListSP[i].CustomerGroups_Name; aBookingRStatusPayViewEN.StatusPay = aListSP[i].BookingRs_StatusPay; aBookingRStatusPayViewEN.BookingMoney = aListSP[i].BookingRs_BookingMoney; switch (aBookingRStatusPayViewEN.StatusPay) { case 0: aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Chưa thanh toán"; break; case 1: aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Tạm ứng"; break; default: aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Chưa xác định"; break; } aListBookingR.Add(aBookingRStatusPayViewEN); } return aListBookingR; } catch (Exception ex) { throw new Exception("ReceptionTaskBO.GetListUnPayBookingR \n" + ex.ToString()); } }
//======================================================= //Author: LinhTing //Function : Tìm danh sách phòng + hóa đơn đã đặt //======================================================= public List<BookingRStatusPayViewEN> GetListBookedBookingR_BookingRoom(DateTime From, DateTime To, int CustomerType, int BookingStatus) { List<vw__PaymentInfo__BookingRs_BookingRooms_Customers> aListTemp = new List<vw__PaymentInfo__BookingRs_BookingRooms_Customers>(); aListTemp = aDatabaseDA.vw__PaymentInfo__BookingRs_BookingRooms_Customers.ToList().Where(a => a.BookingRs_CreatedDate > From).Where(b => b.BookingRs_CreatedDate < To).Where(c => c.BookingRooms_Status == BookingStatus).Where(d => d.BookingRs_CustomerType == CustomerType).ToList(); List<BookingRStatusPayViewEN> aListReturn = new List<BookingRStatusPayViewEN>(); BookingRStatusPayViewEN aBookingRStatusPayViewEN = new BookingRStatusPayViewEN(); CompaniesBO aCompaniesBO = new CompaniesBO(); for (int i = 0; i < aListTemp.Count; i++) { aBookingRStatusPayViewEN = new BookingRStatusPayViewEN(); aBookingRStatusPayViewEN.IDBookingR = aListTemp[i].BookingRs_ID; aBookingRStatusPayViewEN.CreatedDate = aListTemp[i].BookingRs_CreatedDate; aBookingRStatusPayViewEN.Customer_Name = aListTemp[i].Customers_Name; aBookingRStatusPayViewEN.Subject = aListTemp[i].BookingRs_Subject; aBookingRStatusPayViewEN.IDCustomer = aListTemp[i].Customers_ID; aBookingRStatusPayViewEN.IDCustomerGroup = aListTemp[i].CustomerGroups_ID; int IDCompany = !String.IsNullOrEmpty(aListTemp[i].CustomerGroups_IDCompany.ToString()) ? Convert.ToInt32(aListTemp[i].CustomerGroups_IDCompany) : 0; Companies aCompanies = aCompaniesBO.Select_ByID(IDCompany); aBookingRStatusPayViewEN.NameCompany = aCompanies.Name; aBookingRStatusPayViewEN.CustomerGroups_Name = aListTemp[i].CustomerGroups_Name; aBookingRStatusPayViewEN.StatusPay = aListTemp[i].BookingRs_StatusPay; aBookingRStatusPayViewEN.BookingMoney = aListTemp[i].BookingRs_BookingMonye; aBookingRStatusPayViewEN.IDBookingRoom = aListTemp[i].BookingRooms_ID; aBookingRStatusPayViewEN.Sku = aListTemp[i].Rooms_Sku; aBookingRStatusPayViewEN.BookingStatus = aListTemp[i].BookingRooms_Status; aListReturn.Add(aBookingRStatusPayViewEN); } return aListReturn; }