public frmRpt_Payment_BookingRsUnPay(NewPaymentEN aNewPaymentEN)
{
InitializeComponent();
this.aNewPaymentEN = aNewPaymentEN;
try
{
//------------- Phong ------------------------
lblNumberVote.Text = Convert.ToString(this.aNewPaymentEN.IDBookingR);
lblIDBookingR.Text = Convert.ToString(this.aNewPaymentEN.IDBookingR);
lblNameCustomer.Text = this.aNewPaymentEN.NameCustomer;
lblGroup.Text = this.aNewPaymentEN.NameCustomerGroup;
lblCompany.Text = this.aNewPaymentEN.NameCompany;
lblTaxNumberCode.Text = this.aNewPaymentEN.TaxNumberCodeCompany;
int day = DateTime.Now.Day;
int month = DateTime.Now.Month;
int year = DateTime.Now.Year;
lblDayMonthYear.Text = "Hà Nội, ngày " + day.ToString() + " tháng " + month.ToString() + " năm " + year.ToString();
aListServiceUsed = this.aNewPaymentEN.GetAllServiceUsedInRoom();
//Lấy List< IDServiceGroup>
List<int> aTemp = new List<int>();
int IDServiceGroup;
foreach (ServiceUsedEN item in aListServiceUsed)
{
IDServiceGroup = new int();
IDServiceGroup = item.IDServiceGroup;
aTemp.Add(IDServiceGroup);
}
aListIDServicesGroup = aTemp.Distinct().ToList();
ServiceGroupEN aServicesGroupEN;
ServiceGroupsBO aServiceGroupsBO = new ServiceGroupsBO();
foreach (int item in aListIDServicesGroup)
{
aServicesGroupEN = new ServiceGroupEN();
aServicesGroupEN.IDServiceGroup = item;
aServicesGroupEN.TotalMoneyBeforeTax = this.GetTotalMoneyServiceGroupBeforeTax(item);
aServicesGroupEN.DisplayMoneyTax = aNewPaymentEN.GetMoneyTax(this.GetTotalMoneyServiceGroupBeforeTax(item), 10);
aServicesGroupEN.TotalMoneyAfterTax = this.GetTotalMoneyServiceGroupAfterTax(item);
aServicesGroupEN.ServiceGroupName = aServiceGroupsBO.Sel_ByID(item).Name;
aListServicesGroupEN.Add(aServicesGroupEN);
}
//danh sach phong
this.DetailReport.DataSource = aNewPaymentEN.aListBookingRoomUsed;
colSkuRoom.DataBindings.Add("Text", this.DetailReport.DataSource, "RoomSku");
colCheckIn.DataBindings.Add("Text", this.DetailReport.DataSource, "CheckInActual", "{0:dd-MM-yyyy HH:mm}");
if (aNewPaymentEN.Status_BookingR == 8 || aNewPaymentEN.Status_BookingR == 7)
{
colCheckOut.DataBindings.Add("Text", this.DetailReport.DataSource, "CheckOutActual", "{0:dd-MM-yyyy HH:mm}");
}
else
{
colCheckOut.DataBindings.Add("Text", this.DetailReport.DataSource, "CheckOutPlan", "{0:dd-MM-yyyy HH:mm}");
}
colBookingRoomCost.DataBindings.Add("Text", this.DetailReport.DataSource, "Cost", "{0:0,0.##}");
colDateInUse.DataBindings.Add("Text", this.DetailReport.DataSource, "DateUsed", "{0:0,0.##}");
colMoneyRoomBeforeTax.DataBindings.Add("Text", this.DetailReport.DataSource, "MoneyRoomBeforeTax", "{0:0,0}");
colPercentTaxRoom.DataBindings.Add("Text", this.DetailReport.DataSource, "DisplayMoneyTaxRoom", "{0:0,0}");
colPaymentMoneyaRoom.DataBindings.Add("Text", this.DetailReport.DataSource, "MoneyRoom", "{0:0,0}");
////tong tien phong truoc thue
//lblSumMoneyRoomsBeforeTax.Text = String.Format("{0:0,0}", Convert.ToDecimal(this.aNewPaymentEN.GetMoneyRoomsBeforeTax()));
////Tong tien thue
//lblSumMoneyRoomTax.Text = String.Format("{0:0,0}", Convert.ToDecimal(this.aNewPaymentEN.GetMoneyTax(this.aNewPaymentEN.GetMoneyRoomsBeforeTax(), 10)));
////tong tien phong sau thue
//lblSumMoneyRoomsAfterTax.Text = String.Format("{0:0,0}", Convert.ToDecimal(this.aNewPaymentEN.GetMoneyRooms()));
XRSummary aXRSummaryMoneyRoomBeforeTax = new XRSummary();
aXRSummaryMoneyRoomBeforeTax.Func = SummaryFunc.Sum;
aXRSummaryMoneyRoomBeforeTax.Running = SummaryRunning.Group;
aXRSummaryMoneyRoomBeforeTax.IgnoreNullValues = true;
aXRSummaryMoneyRoomBeforeTax.FormatString = "{0:0,0}";
XRBinding aXRBindingMoneyRoomBeforeTax = new XRBinding("Text", this.DetailReport.DataSource, "MoneyRoomBeforeTax", "{0:0,0}");
XRBinding[] listXRBindingMoneyRoomBeforeTax = new XRBinding[] { aXRBindingMoneyRoomBeforeTax };
lblSumMoneyRoomsBeforeTax.DataBindings.AddRange(listXRBindingMoneyRoomBeforeTax);
lblSumMoneyRoomsBeforeTax.Summary = aXRSummaryMoneyRoomBeforeTax;
XRSummary aXRSummaryDisplayMoneyTaxRoom = new XRSummary();
aXRSummaryDisplayMoneyTaxRoom.Func = SummaryFunc.Sum;
aXRSummaryDisplayMoneyTaxRoom.Running = SummaryRunning.Group;
aXRSummaryDisplayMoneyTaxRoom.IgnoreNullValues = true;
aXRSummaryDisplayMoneyTaxRoom.FormatString = "{0:0,0}";
XRBinding aXRBindingDisplayMoneyTaxRoom = new XRBinding("Text", this.DetailReport.DataSource, "DisplayMoneyTaxRoom", "{0:0,0}");
XRBinding[] listXRBindingDisplayMoneyTaxRoom = new XRBinding[] { aXRBindingDisplayMoneyTaxRoom };
lblSumMoneyRoomTax.DataBindings.AddRange(listXRBindingDisplayMoneyTaxRoom);
lblSumMoneyRoomTax.Summary = aXRSummaryDisplayMoneyTaxRoom;
XRSummary aXRSummaryMoneyRoom = new XRSummary();
aXRSummaryMoneyRoom.Func = SummaryFunc.Sum;
aXRSummaryMoneyRoom.Running = SummaryRunning.Group;
aXRSummaryMoneyRoom.IgnoreNullValues = true;
aXRSummaryMoneyRoom.FormatString = "{0:0,0}";
XRBinding aXRBindingMoneyRoom = new XRBinding("Text", this.DetailReport.DataSource, "MoneyRoom", "{0:0,0}");
XRBinding[] listXRBindingMoneyRoom = new XRBinding[] { aXRBindingMoneyRoom };
lblSumMoneyRoomsAfterTax.DataBindings.AddRange(listXRBindingMoneyRoom);
lblSumMoneyRoomsAfterTax.Summary = aXRSummaryMoneyRoom;
//danh sach dich vu
this.DetailReport2.DataSource = aListServicesGroupEN;
colNamService.DataBindings.Add("Text", this.DetailReport2.DataSource, "ServiceGroupName");
colTotalMoneyBeforeTax.DataBindings.Add("Text", this.DetailReport2.DataSource, "TotalMoneyBeforeTax", "{0:0,0}");
colPercentTaxService.DataBindings.Add("Text", this.DetailReport2.DataSource, "DisplayMoneyTax", "{0:0,0}");
colTotalMoneyServiceAfterTax.DataBindings.Add("Text", this.DetailReport2.DataSource, "TotalMoneyAfterTax", "{0:0,0}");
////tong tien dich vu truoc thue
//lblSumMoneyService_BookingRBeforeTax.Text = String.Format("{0:0,0}", Convert.ToDecimal(this.aNewPaymentEN.GetTotalMoneyServiceUsedInRoomsBeforeTax()));
////Tong so tien thue
//lblSumMoneyServiceTax.Text = String.Format("{0:0,0}", Convert.ToDecimal(this.aNewPaymentEN.GetMoneyTax(this.aNewPaymentEN.GetTotalMoneyServiceUsedInRoomsBeforeTax(), 10)));
////tong tien dich vu sau thue
//lblSumMoneyService_BookingRAfterTax.Text = String.Format("{0:0,0}", Convert.ToDecimal(this.aNewPaymentEN.GetTotalMoneyServiceUsedInRooms()));
XRSummary aXRSummaryTotalMoneyBeforeTax = new XRSummary();
aXRSummaryTotalMoneyBeforeTax.Func = SummaryFunc.Sum;
aXRSummaryTotalMoneyBeforeTax.Running = SummaryRunning.Group;
aXRSummaryTotalMoneyBeforeTax.IgnoreNullValues = true;
aXRSummaryTotalMoneyBeforeTax.FormatString = "{0:0,0}";
lblSumMoneyService_BookingRBeforeTax.DataBindings.AddRange(new XRBinding[] { new XRBinding("Text", this.DetailReport2.DataSource, "TotalMoneyBeforeTax", "{0:0,0}") });
lblSumMoneyService_BookingRBeforeTax.Summary = aXRSummaryTotalMoneyBeforeTax;
XRSummary aXRSummaryDisplayMoneyTax = new XRSummary();
aXRSummaryDisplayMoneyTax.Func = SummaryFunc.Sum;
aXRSummaryDisplayMoneyTax.Running = SummaryRunning.Group;
aXRSummaryDisplayMoneyTax.IgnoreNullValues = true;
aXRSummaryDisplayMoneyTax.FormatString = "{0:0,0}";
lblSumMoneyServiceTax.DataBindings.AddRange(new XRBinding[] { new XRBinding("Text", this.DetailReport2.DataSource, "DisplayMoneyTax", "{0:0,0}") });
lblSumMoneyServiceTax.Summary = aXRSummaryDisplayMoneyTax;
XRSummary aXRSummaryTotalMoneyAfterTax = new XRSummary();
aXRSummaryTotalMoneyAfterTax.Func = SummaryFunc.Sum;
aXRSummaryTotalMoneyAfterTax.Running = SummaryRunning.Group;
aXRSummaryTotalMoneyAfterTax.IgnoreNullValues = true;
aXRSummaryTotalMoneyAfterTax.FormatString = "{0:0,0}";
lblSumMoneyService_BookingRAfterTax.DataBindings.AddRange(new XRBinding[] { new XRBinding("Text", this.DetailReport2.DataSource, "TotalMoneyAfterTax", "{0:0,0}") });
lblSumMoneyService_BookingRAfterTax.Summary = aXRSummaryTotalMoneyAfterTax;
//tong tien thanh toan truoc thue
lblTotalMoneyBookingRBeforeTax.Text = String.Format("{0:0,0}", Convert.ToDecimal(this.aNewPaymentEN.GetTotalMoneyBeforeTax()));
//tien thue
lblTotalMoneyTax.Text = String.Format("{0:0,0}", Convert.ToDecimal(this.aNewPaymentEN.GetMoneyTax(Convert.ToDecimal(this.aNewPaymentEN.GetMoneyRoomsBeforeTax()) + Convert.ToDecimal(this.aNewPaymentEN.GetTotalMoneyServiceUsedInRoomsBeforeTax()), 10)));
//tong tien thanh toan sau thue
lblTotalMoneyBookingRAfterTax.Text = String.Format("{0:0,0}", Convert.ToDecimal(this.aNewPaymentEN.GetTotalMoney()));
//So tien ung truoc
lblBookingMoney_BookingR.Text = String.Format("{0:0,0}", Convert.ToDecimal(this.aNewPaymentEN.BookingRMoney));
//so tien con lai can thanh toan
lblTotalMoney_BookingR.Text = String.Format("{0:0,0}", (Convert.ToDecimal(this.aNewPaymentEN.GetTotalMoney()) - Convert.ToDecimal(this.aNewPaymentEN.BookingRMoney)));
string TotalMoney_BookingRString = UppercaseFirst(StringUtility.ConvertDecimalToString((Convert.ToDecimal(this.aNewPaymentEN.GetTotalMoney()) - Convert.ToDecimal(this.aNewPaymentEN.BookingRMoney))));
lblTotalMoney_BookingRString.Text = "(" + TotalMoney_BookingRString + ")";
}
catch (Exception ex)
{
ex.ToString();
}
}
public frmRpt_Payment_BookingRsAndBookingHs(NewPaymentEN aNewPaymentEN)
{
InitializeComponent();
this.aNewPaymentEN = aNewPaymentEN;
try
{
lblNumberVote.Text = Convert.ToString(this.aNewPaymentEN.IDBookingR);
lblIIDBookingR.Text = Convert.ToString(this.aNewPaymentEN.IDBookingR);
lblNameCustomer.Text = this.aNewPaymentEN.NameCustomer;
lblGroup.Text = this.aNewPaymentEN.NameCustomerGroup;
lblCompany.Text = this.aNewPaymentEN.NameCompany;
lblTaxNumberCode.Text = this.aNewPaymentEN.TaxNumberCodeCompany;
int day = DateTime.Now.Day;
int month = DateTime.Now.Month;
int year = DateTime.Now.Year;
lblDayMonthYear.Text = "Hà nội , ngày " + day.ToString() + " tháng " + month.ToString() + " năm " + year.ToString();
#region Phòng
aListServiceUsedRoom = this.aNewPaymentEN.GetAllServiceUsedInRoom();
//Lấy List< IDServiceGroup>
List<int> aTemp = new List<int>();
int IDServiceGroup;
foreach (ServiceUsedEN item in aListServiceUsedRoom)
{
IDServiceGroup = new int();
IDServiceGroup = item.IDServiceGroup;
aTemp.Add(IDServiceGroup);
}
aListIDServicesGroupRoom = aTemp.Distinct().ToList();
ServiceGroupEN aServicesGroupEN;
ServiceGroupsBO aServiceGroupsBO = new ServiceGroupsBO();
foreach (int item in aListIDServicesGroupRoom)
{
aServicesGroupEN = new ServiceGroupEN();
aServicesGroupEN.IDServiceGroup = item;
aServicesGroupEN.TotalMoneyBeforeTax = this.GetTotalMoneyServiceGroupRoomBeforeTax(item);
aServicesGroupEN.TotalMoneyAfterTax = this.GetTotalMoneyServiceGroupRoomAfterTax(item);
aServicesGroupEN.DisplayMoneyTax = aNewPaymentEN.GetMoneyTax(this.GetTotalMoneyServiceGroupRoomBeforeTax(item), 10);
aServicesGroupEN.ServiceGroupName = aServiceGroupsBO.Sel_ByID(item).Name;
aListServicesGroupRoomEN.Add(aServicesGroupEN);
}
//danh sach phong
this.DetailReport.DataSource = aNewPaymentEN.aListBookingRoomUsed;
colSkuRoom.DataBindings.Add("Text", this.DetailReport.DataSource, "RoomSku");
colCheckIn.DataBindings.Add("Text", this.DetailReport.DataSource, "CheckInActual", "{0:dd-MM-yyyy HH:mm}");
colCheckOut.DataBindings.Add("Text", this.DetailReport.DataSource, "CheckOutActual", "{0:dd-MM-yyyy HH:mm}");
colBookingRoomCost.DataBindings.Add("Text", this.DetailReport.DataSource, "Cost", "{0:0,0}");
colDateInUse.DataBindings.Add("Text", this.DetailReport.DataSource, "DateUsed", "{0:0,0}");
colMoneyRoomBeforeTax.DataBindings.Add("Text", this.DetailReport.DataSource, "MoneyRoomBeforeTax", "{0:0,0}");
colPercentTaxRoom.DataBindings.Add("Text", this.DetailReport.DataSource, "DisplayMoneyTaxRoom", "{0:0,0}");
colPaymentMoneyRoom.DataBindings.Add("Text", this.DetailReport.DataSource, "MoneyRoom", "{0:0,0}");
XRSummary aXRSummaryMoneyRoomBeforeTax = new XRSummary();
aXRSummaryMoneyRoomBeforeTax.Func = SummaryFunc.Sum;
aXRSummaryMoneyRoomBeforeTax.Running = SummaryRunning.Group;
aXRSummaryMoneyRoomBeforeTax.IgnoreNullValues = true;
aXRSummaryMoneyRoomBeforeTax.FormatString = "{0:0,0}";
XRBinding aXRBindingMoneyRoomBeforeTax = new XRBinding("Text", this.DetailReport.DataSource, "MoneyRoomBeforeTax", "{0:0,0}");
XRBinding[] listXRBindingMoneyRoomBeforeTax = new XRBinding[] { aXRBindingMoneyRoomBeforeTax };
lblSumMoneyRoomsBeforeTax.DataBindings.AddRange(listXRBindingMoneyRoomBeforeTax);
lblSumMoneyRoomsBeforeTax.Summary = aXRSummaryMoneyRoomBeforeTax;
XRSummary aXRSummaryDisplayMoneyTaxRoom = new XRSummary();
aXRSummaryDisplayMoneyTaxRoom.Func = SummaryFunc.Sum;
aXRSummaryDisplayMoneyTaxRoom.Running = SummaryRunning.Group;
aXRSummaryDisplayMoneyTaxRoom.IgnoreNullValues = true;
aXRSummaryDisplayMoneyTaxRoom.FormatString = "{0:0,0}";
XRBinding aXRBindingDisplayMoneyTaxRoom = new XRBinding("Text", this.DetailReport.DataSource, "DisplayMoneyTaxRoom", "{0:0,0})");
XRBinding[] listXRBindingDisplayMoneyTaxRoom = new XRBinding[] { aXRBindingDisplayMoneyTaxRoom };
lblSumMoneyRoomTax.DataBindings.AddRange(listXRBindingDisplayMoneyTaxRoom);
lblSumMoneyRoomTax.Summary = aXRSummaryDisplayMoneyTaxRoom;
XRSummary aXRSummaryMoneyRoom = new XRSummary();
aXRSummaryMoneyRoom.Func = SummaryFunc.Sum;
aXRSummaryMoneyRoom.Running = SummaryRunning.Group;
aXRSummaryMoneyRoom.IgnoreNullValues = true;
aXRSummaryMoneyRoom.FormatString = "{0:0,0}";
XRBinding aXRBindingMoneyRoom = new XRBinding("Text", this.DetailReport.DataSource, "MoneyRoom", "{0:0,0}");
XRBinding[] listXRBindingMoneyRoom = new XRBinding[] { aXRBindingMoneyRoom };
lblSumMoneyRoomsAfterTax.DataBindings.AddRange(listXRBindingMoneyRoom);
lblSumMoneyRoomsAfterTax.Summary = aXRSummaryMoneyRoom;
//danh sach dich vu
this.DetailReport2.DataSource = aListServicesGroupRoomEN;
colNamServiceRoom.DataBindings.Add("Text", this.DetailReport2.DataSource, "ServiceGroupName");
colTotalMoneyServiceRoomBeforeTax.DataBindings.Add("Text", this.DetailReport2.DataSource, "TotalMoneyBeforeTax", "{0:0,0}");
colPercentTaxServiceRoom.DataBindings.Add("Text", this.DetailReport2.DataSource, "DisplayMoneyTax", "{0:0,0}");
colTotalMoneyServiceRoomAfterTax.DataBindings.Add("Text", this.DetailReport2.DataSource, "TotalMoneyAfterTax", "{0:0,0}");
XRSummary aXRSummaryTotalMoneyBeforeTax = new XRSummary();
aXRSummaryTotalMoneyBeforeTax.Func = SummaryFunc.Sum;
aXRSummaryTotalMoneyBeforeTax.Running = SummaryRunning.Group;
aXRSummaryTotalMoneyBeforeTax.IgnoreNullValues = true;
aXRSummaryTotalMoneyBeforeTax.FormatString = "{0:0,0}";
lblSumMoneyServiceRoomsBeforeTax.DataBindings.AddRange(new XRBinding[] { new XRBinding("Text", this.DetailReport2.DataSource, "TotalMoneyBeforeTax", "{0:0,0}") });
lblSumMoneyServiceRoomsBeforeTax.Summary = aXRSummaryTotalMoneyBeforeTax;
XRSummary aXRSummaryDisplayMoneyTax = new XRSummary();
aXRSummaryDisplayMoneyTax.Func = SummaryFunc.Sum;
aXRSummaryDisplayMoneyTax.Running = SummaryRunning.Group;
aXRSummaryDisplayMoneyTax.IgnoreNullValues = true;
aXRSummaryDisplayMoneyTax.FormatString = "{0:0,0}";
lblSumMoneyServiceRoomsTax.DataBindings.AddRange(new XRBinding[] { new XRBinding("Text", this.DetailReport2.DataSource, "DisplayMoneyTax", "{0:0,0}") });
lblSumMoneyServiceRoomsTax.Summary = aXRSummaryDisplayMoneyTax;
XRSummary aXRSummaryTotalMoneyAfterTax = new XRSummary();
aXRSummaryTotalMoneyAfterTax.Func = SummaryFunc.Sum;
aXRSummaryTotalMoneyAfterTax.Running = SummaryRunning.Group;
aXRSummaryTotalMoneyAfterTax.IgnoreNullValues = true;
aXRSummaryTotalMoneyAfterTax.FormatString = "{0:0,0}";
lblSumMoneyServiceRoomsAfterTax.DataBindings.AddRange(new XRBinding[] { new XRBinding("Text", this.DetailReport2.DataSource, "TotalMoneyAfterTax", "{0:0,0}") });
lblSumMoneyServiceRoomsAfterTax.Summary = aXRSummaryTotalMoneyAfterTax;
#endregion
#region Hội trường
aListServiceUsedHall = this.aNewPaymentEN.GetAllServiceUsedInHall();
//Lấy List< IDServiceGroup>
List<int> aTemp1 = new List<int>();
int IDServiceGroupHall;
foreach (ServiceUsedEN item in aListServiceUsedHall)
{
IDServiceGroupHall = new int();
IDServiceGroupHall = item.IDServiceGroup;
aTemp1.Add(IDServiceGroupHall);
}
aListIDServicesGroupHall = aTemp1.Distinct().ToList();
ServiceGroupEN aServicesGroupHallEN;
foreach (int item in aListIDServicesGroupHall)
{
aServicesGroupHallEN = new ServiceGroupEN();
aServicesGroupHallEN.IDServiceGroup = item;
aServicesGroupHallEN.TotalMoneyBeforeTax = this.GetTotalMoneyServiceGroupHallBeforeTax(item);
aServicesGroupHallEN.TotalMoneyAfterTax = this.GetTotalMoneyServiceGroupHallAfterTax(item);
aServicesGroupHallEN.DisplayMoneyTax = aNewPaymentEN.GetMoneyTax(this.GetTotalMoneyServiceGroupHallBeforeTax(item), 10);
aServicesGroupHallEN.ServiceGroupName = aServiceGroupsBO.Sel_ByID(item).Name;
aListServicesGroupHallEN.Add(aServicesGroupHallEN);
}
//danh sach hoi truong
this.DetailReportHall.DataSource = aNewPaymentEN.aListBookingHallUsed;
colSkuHall.DataBindings.Add("Text", this.DetailReportHall.DataSource, "HallSku");
colCreateDate.DataBindings.Add("Text", this.DetailReportHall.DataSource, "Date", "{0:dd/MM/yyyy}");
colBookingHallCost.DataBindings.Add("Text", this.DetailReportHall.DataSource, "Cost", "{0:0,0}");
colPercentTax.DataBindings.Add("Text", this.DetailReportHall.DataSource, "DisplayMoneyTaxHall", "{0:0,0}");
colPaymentMoneyHall.DataBindings.Add("Text", this.DetailReportHall.DataSource, "MoneyHall", "{0:0,0}");
XRSummary aXRSummaryDisplayMoneyTaxHall = new XRSummary();
aXRSummaryDisplayMoneyTaxHall.Func = SummaryFunc.Sum;
aXRSummaryDisplayMoneyTaxHall.Running = SummaryRunning.Group;
aXRSummaryDisplayMoneyTaxHall.IgnoreNullValues = true;
aXRSummaryDisplayMoneyTaxHall.FormatString = "{0:0,0}";
XRBinding aXRBindingDisplayMoneyTaxHall = new XRBinding("Text", this.DetailReportHall.DataSource, "DisplayMoneyTaxHall", "{0:0,0}");
XRBinding[] listXRBindingDisplayMoneyTaxHall = new XRBinding[] { aXRBindingDisplayMoneyTaxHall };
lblSumMoneyHallsTax.DataBindings.AddRange(listXRBindingDisplayMoneyTaxHall);
lblSumMoneyHallsTax.Summary = aXRSummaryDisplayMoneyTaxHall;
//danh sach dich vu su dung
this.DetailReportService.DataSource = aListServicesGroupHallEN;
colNamServiceHall.DataBindings.Add("Text", this.DetailReportService.DataSource, "ServiceGroupName");
colTotalMoneyServiceHallBeforeTax.DataBindings.Add("Text", this.DetailReportService.DataSource, "TotalMoneyBeforeTax", "{0:0,0}");
colPercentTaxServiceHall.DataBindings.Add("Text", this.DetailReportService.DataSource, "DisplayMoneyTax", "{0:0,0}");
colTotalMoneyServiceHallAfterTax.DataBindings.Add("Text", this.DetailReportService.DataSource, "TotalMoneyAfterTax", "{0:0,0}");
XRSummary aXRSummaryDisplayMoneyServiceHallTax = new XRSummary();
aXRSummaryDisplayMoneyServiceHallTax.Func = SummaryFunc.Sum;
aXRSummaryDisplayMoneyServiceHallTax.Running = SummaryRunning.Group;
aXRSummaryDisplayMoneyServiceHallTax.IgnoreNullValues = true;
aXRSummaryDisplayMoneyServiceHallTax.FormatString = "{0:0,0}";
lblSumMoneyServiceHallsTax.DataBindings.AddRange(new XRBinding[] { new XRBinding("Text", this.DetailReportService.DataSource, "DisplayMoneyTax", "{0:0,0}") });
lblSumMoneyServiceHallsTax.Summary = aXRSummaryDisplayMoneyServiceHallTax;
//tong tien hoi truong truoc thue
lblSumMoneyHallsBeforeTax.Text = String.Format("{0:0,0}", Convert.ToDecimal(this.aNewPaymentEN.GetOnlyMoneyHallsBeforeTax()));
//tong tien hoi truong sau thue
lblSumMoneyHallsAfterTax.Text = String.Format("{0:0,0}", Convert.ToDecimal(this.aNewPaymentEN.GetOnlyMoneyHalls()));
//tong tien dich vu hoi truong truoc thue
lblSumMoneyServiceHallsBeforeTax.Text = String.Format("{0:0,0}", Convert.ToDecimal(this.aNewPaymentEN.GetTotalMoneyServiceUsedInHallsBeforeTax()));
//tong tien dich vu hoi truong sau thue
lblSumMoneyServiceHallsAfterTax.Text = String.Format("{0:0,0}", Convert.ToDecimal(this.aNewPaymentEN.GetTotalMoneyServiceUsedInHalls()));
//Tong tien hoa don can thanh toan
decimal? beforTax = Convert.ToDecimal(this.aNewPaymentEN.GetTotalMoneyBeforeTax());
decimal? afterTax = Convert.ToDecimal(this.aNewPaymentEN.GetTotalMoney());
decimal? bookingMoney = Convert.ToDecimal(this.aNewPaymentEN.BookingHMoney) + Convert.ToDecimal(this.aNewPaymentEN.BookingRMoney);
//tong tien thanh toan truoc thue
lblTotalMoneyBeforeTax.Text = String.Format("{0:0,0}", beforTax);
//tien thue
lblTotalMoneyTax.Text = String.Format("{0:0,0}", Convert.ToDecimal(this.aNewPaymentEN.GetMoneyTax(beforTax, 10)));
//tong tien thanh toan sau thue
lblTotalMoneyAfterTax.Text = String.Format("{0:0,0}", afterTax);
//So tien ung truoc
lblBookingMoney.Text = String.Format("{0:0,0}", bookingMoney);
//so tien con lai can thanh toan
lblTotalMoney.Text = String.Format("{0:0,0}", afterTax - bookingMoney);
string TotalMoney_BookingRString = UppercaseFirst(StringUtility.ConvertDecimalToString(Convert.ToDecimal(afterTax - bookingMoney)));
lblTotalMoneyString.Text = "(" + TotalMoney_BookingRString + ")";
#endregion
}
catch (Exception ex)
{
ex.ToString();
}
}
public frmRpt_SplitPayment_BookingHs(NewPaymentEN aNewPaymentEN, int IndexSub)
{
InitializeComponent();
this.aNewPaymentEN = aNewPaymentEN;
this.IndexSub = IndexSub;
try
{
lblNumberVote.Text = Convert.ToString(this.aNewPaymentEN.IDBookingH);
lblIDBookingH.Text = Convert.ToString(this.aNewPaymentEN.IDBookingH);
lblNameCustomer.Text = this.aNewPaymentEN.NameCustomer;
lblGroup.Text = this.aNewPaymentEN.NameCustomerGroup;
lblCompany.Text = this.aNewPaymentEN.NameCompany;
lblTaxNumberCode.Text = this.aNewPaymentEN.TaxNumberCodeCompany;
int day = DateTime.Now.Day;
int month = DateTime.Now.Month;
int year = DateTime.Now.Year;
lblDayMonthYear.Text = "Hà Nội, ngày " + day.ToString() + " tháng " + month.ToString() + " năm " + year.ToString();
//Lấy dữ liệu
List<BookingHallUsedEN> aListBookingHallUsedEN = new List<BookingHallUsedEN>();
aListBookingHallUsedEN = this.aNewPaymentEN.aListBookingHallUsed.Where(r => r.IndexSubPayment == this.IndexSub).OrderBy(r => r.HallSku).ToList();
aListBookingHallUsedEN.Count();
aListServiceUsedHall = this.aNewPaymentEN.GetAllServiceUsedInHall().Where(r => r.IndexSubPayment == this.IndexSub).OrderBy(r => r.Sku).ToList();
//Lấy List< IDServiceGroup>
List<int> aTemp1 = new List<int>();
int IDServiceGroupHall;
foreach (ServiceUsedEN item in aListServiceUsedHall)
{
IDServiceGroupHall = new int();
IDServiceGroupHall = item.IDServiceGroup;
aTemp1.Add(IDServiceGroupHall);
}
aListIDServicesGroupHall = aTemp1.Distinct().ToList();
ServiceGroupEN aServicesGroupHallEN;
foreach (int item in aListIDServicesGroupHall)
{
aServicesGroupHallEN = new ServiceGroupEN();
aServicesGroupHallEN.IDServiceGroup = item;
aServicesGroupHallEN.TotalMoneyBeforeTax = this.GetTotalMoneyServiceGroupHallBeforeTax(item);
aServicesGroupHallEN.TotalMoneyAfterTax = this.GetTotalMoneyServiceGroupHallAfterTax(item);
aServicesGroupHallEN.DisplayMoneyTax = aNewPaymentEN.GetMoneyTax(this.GetTotalMoneyServiceGroupHallBeforeTax(item), 10);
aServicesGroupHallEN.ServiceGroupName = aServiceGroupsBO.Sel_ByID(item).Name;
aListServicesGroupHallEN.Add(aServicesGroupHallEN);
}
decimal? sumMoneyHallBeforeTax = aListBookingHallUsedEN.Sum(r => r.GetMoneyHallBeforeTax());
decimal? SumMoneyTaxHall = aListBookingHallUsedEN.Sum(r => r.GetTotalMoneyHall());
decimal? sumMoneyHallAfterTax = aListBookingHallUsedEN.Sum(r => r.GetTotalMoneyHall());
decimal? sumMoneyServiceHallBeforeTax = aListServicesGroupHallEN.Sum(s => s.TotalMoneyBeforeTax);
decimal? sumMoneyTaxServices = aListServicesGroupHallEN.Sum(s => s.DisplayMoneyTax);
decimal? sumMoneyServiceHallAfterTax = aListServicesGroupHallEN.Sum(s => s.TotalMoneyAfterTax);
//Tong tien hoa don can thanh toan
decimal? beforTax = sumMoneyHallBeforeTax + sumMoneyServiceHallBeforeTax;
decimal? afterTax = sumMoneyHallAfterTax + sumMoneyServiceHallAfterTax;
decimal? bookingMoney = Convert.ToDecimal(this.aNewPaymentEN.BookingHMoney);
//danh sach hoi truong
this.DetailReportHall.DataSource = aNewPaymentEN.aListBookingHallUsed;
colSkuHall.DataBindings.Add("Text", this.DetailReportHall.DataSource, "HallSku");
colCreateDate.DataBindings.Add("Text", this.DetailReportHall.DataSource, "Date", "{0:dd/MM/yyyy}");
colBookingHallCost.DataBindings.Add("Text", this.DetailReportHall.DataSource, "Cost", "{0:0,0}");
colPercentTax.DataBindings.Add("Text", this.DetailReportHall.DataSource, "DisplayMoneyTaxHall", "{0:0,0}");
colPaymentMoneyHall.DataBindings.Add("Text", this.DetailReportHall.DataSource, "MoneyHall", "{0:0,0}");
XRSummary aXRSummaryDisplayMoneyTaxHall = new XRSummary();
aXRSummaryDisplayMoneyTaxHall.Func = SummaryFunc.Sum;
aXRSummaryDisplayMoneyTaxHall.Running = SummaryRunning.Group;
aXRSummaryDisplayMoneyTaxHall.IgnoreNullValues = true;
aXRSummaryDisplayMoneyTaxHall.FormatString = "{0:0,0}";
XRBinding aXRBindingDisplayMoneyTaxHall = new XRBinding("Text", this.DetailReportHall.DataSource, "DisplayMoneyTaxHall", "{0:0,0}");
XRBinding[] listXRBindingDisplayMoneyTaxHall = new XRBinding[] { aXRBindingDisplayMoneyTaxHall };
lblSumMoneyHallsTax.DataBindings.AddRange(listXRBindingDisplayMoneyTaxHall);
lblSumMoneyHallsTax.Summary = aXRSummaryDisplayMoneyTaxHall;
//danh sach dich vu su dung
this.DetailReportService.DataSource = aListServicesGroupHallEN;
colNamServiceHall.DataBindings.Add("Text", this.DetailReportService.DataSource, "ServiceGroupName");
colTotalMoneyServiceHallBeforeTax.DataBindings.Add("Text", this.DetailReportService.DataSource, "TotalMoneyBeforeTax", "{0:0,0}");
colPercentTaxServiceHall.DataBindings.Add("Text", this.DetailReportService.DataSource, "DisplayMoneyTax", "{0:0,0}");
colTotalMoneyServiceHallAfterTax.DataBindings.Add("Text", this.DetailReportService.DataSource, "TotalMoneyAfterTax", "{0:0,0}");
XRSummary aXRSummaryDisplayMoneyServiceHallTax = new XRSummary();
aXRSummaryDisplayMoneyServiceHallTax.Func = SummaryFunc.Sum;
aXRSummaryDisplayMoneyServiceHallTax.Running = SummaryRunning.Group;
aXRSummaryDisplayMoneyServiceHallTax.IgnoreNullValues = true;
aXRSummaryDisplayMoneyServiceHallTax.FormatString = "{0:0,0}";
lblSumMoneyServiceHallsTax.DataBindings.AddRange(new XRBinding[] { new XRBinding("Text", this.DetailReportService.DataSource, "DisplayMoneyTax", "{0:0,0}") });
lblSumMoneyServiceHallsTax.Summary = aXRSummaryDisplayMoneyServiceHallTax;
//tong tien hoi truong truoc thue
lblSumMoneyHallsBeforeTax.Text = String.Format("{0:0,0}",sumMoneyHallBeforeTax);
//tong tien hoi truong sau thue
lblSumMoneyHallsAfterTax.Text = String.Format("{0:0,0}", sumMoneyHallAfterTax);
//tong tien dich vu hoi truong truoc thue
lblSumMoneyServiceHallsBeforeTax.Text = String.Format("{0:0,0}", sumMoneyServiceHallBeforeTax);
//tong tien dich vu hoi truong sau thue
lblSumMoneyServiceHallsAfterTax.Text = String.Format("{0:0,0}", sumMoneyServiceHallAfterTax);
//tong tien thanh toan truoc thue
lblTotalMoneyBeforeTax.Text = String.Format("{0:0,0}", beforTax);
//tien thue
lblTotalMoneyTax.Text = String.Format("{0:0,0}", sumMoneyTaxServices+SumMoneyTaxHall);
//tong tien thanh toan sau thue
lblTotalMoneyAfterTax.Text = String.Format("{0:0,0}", afterTax);
//So tien ung truoc
lblBookingMoney.Text = String.Format("{0:0,0}", bookingMoney);
//so tien con lai can thanh toan
lblTotalMoney.Text = String.Format("{0:0,0}", afterTax - bookingMoney);
string TotalMoney_BookingHString = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(Library.StringUtility.ConvertDecimalToString(Convert.ToDecimal(afterTax - bookingMoney)));
lblTotalMoneyString.Text = "(" + TotalMoney_BookingHString + ")";
}
catch (Exception ex)
{
ex.ToString();
}
}
public frmRpt_SplitPayment_BookingRs(NewPaymentEN aNewPaymentEN,int IndexSub)
{
InitializeComponent();
this.aNewPaymentEN = aNewPaymentEN;
this.IndexSub = IndexSub;
try
{
lblNumberVote.Text = Convert.ToString(this.aNewPaymentEN.IDBookingR);
lblIIDBookingR.Text = Convert.ToString(this.aNewPaymentEN.IDBookingR);
lblNameCustomer.Text = aNewPaymentEN.NameCustomer;
lblGroup.Text = aNewPaymentEN.NameCustomerGroup;
lblCompany.Text =aNewPaymentEN.NameCompany;
lblTaxNumberCode.Text =aNewPaymentEN.TaxNumberCodeCompany;
int day = DateTime.Now.Day;
int month = DateTime.Now.Month;
int year = DateTime.Now.Year;
lblDayMonthYear.Text = "Hà Nội, ngày " + day.ToString() + " tháng " + month.ToString() + " năm " + year.ToString();
//------------- Phong ------------------------
List<BookingRoomUsedEN> aListBookingRoomUsedEN = new List<BookingRoomUsedEN>();
aListBookingRoomUsedEN = aNewPaymentEN.aListBookingRoomUsed.Where(r => r.IndexSubPayment == this.IndexSub).OrderBy(r => r.RoomSku).ToList();
aListServiceUsed = aNewPaymentEN.GetAllServiceUsedInRoom().Where(r => r.IndexSubPayment == this.IndexSub).OrderBy(r => r.Sku).ToList();
//Lấy List< IDServiceGroup>
List<int> aTemp = new List<int>();
int IDServiceGroup;
foreach (ServiceUsedEN item in aListServiceUsed)
{
IDServiceGroup = new int();
IDServiceGroup = item.IDServiceGroup;
aTemp.Add(IDServiceGroup);
}
aListIDServicesGroup = aTemp.Distinct().ToList();
ServiceGroupEN aServicesGroupEN;
ServiceGroupsBO aServiceGroupsBO = new ServiceGroupsBO();
foreach (int item in aListIDServicesGroup)
{
aServicesGroupEN = new ServiceGroupEN();
aServicesGroupEN.IDServiceGroup = item;
aServicesGroupEN.TotalMoneyBeforeTax = this.GetTotalMoneyServiceGroupBeforeTax(item);
aServicesGroupEN.DisplayMoneyTax = aNewPaymentEN.GetMoneyTax(this.GetTotalMoneyServiceGroupBeforeTax(item), 10);
aServicesGroupEN.TotalMoneyAfterTax = this.GetTotalMoneyServiceGroupAfterTax(item);
aServicesGroupEN.ServiceGroupName = aServiceGroupsBO.Sel_ByID(item).Name;
aListServicesGroupEN.Add(aServicesGroupEN);
}
decimal? sumMoneyRoomBeforeTax = aListBookingRoomUsedEN.Sum(r => r.GetOnlyMoneyRoomBeforeTax());
decimal? SumMoneyTaxRoom = aListBookingRoomUsedEN.Sum(r => r.GetOnlyMoneyRoom());
decimal? sumMoneyRoomAfterTax = aListBookingRoomUsedEN.Sum(r => r.GetOnlyMoneyRoom());
decimal? sumMoneyServiceRoomBeforeTax = aListServicesGroupEN.Sum(s => s.TotalMoneyBeforeTax);
decimal? sumMoneyTaxServices = aListServicesGroupEN.Sum(s => s.DisplayMoneyTax);
decimal? sumMoneyServiceRoomAfterTax = aListServicesGroupEN.Sum(s => s.TotalMoneyAfterTax);
decimal? BookingMoneyR = 0;
//danh sach phong
this.DetailReport.DataSource = aListBookingRoomUsedEN;
colSkuRoom.DataBindings.Add("Text", this.DetailReport.DataSource, "RoomSku");
colCheckIn.DataBindings.Add("Text", this.DetailReport.DataSource, "CheckInActual", "{0:dd-MM-yyyy HH:mm}");
colCheckOut.DataBindings.Add("Text", this.DetailReport.DataSource, "CheckOutActual", "{0:dd-MM-yyyy HH:mm}");
colBookingRoomCost.DataBindings.Add("Text", this.DetailReport.DataSource, "Cost", "{0:0,0.##}");
colDateInUse.DataBindings.Add("Text", this.DetailReport.DataSource, "DateUsed", "{0:0,0.##}");
colMoneyRoomBeforeTax.DataBindings.Add("Text", this.DetailReport.DataSource, "MoneyRoomBeforeTax", "{0:0,0}");
colPercentTaxRoom.DataBindings.Add("Text", this.DetailReport.DataSource, "DisplayMoneyTaxRoom", "{0:0,0}");
colPaymentMoneyaRoom.DataBindings.Add("Text", this.DetailReport.DataSource, "MoneyRoom", "{0:0,0}");
//tong tien phong truoc thue
lblSumMoneyRoomsBeforeTax.Text = String.Format("{0:0,0}", sumMoneyRoomBeforeTax);
//Tien thue phong
lblSumMoneyRoomTax.Text = String.Format("{0:0,0}", SumMoneyTaxRoom);
//tong tien phong sau thue
lblSumMoneyRoomsAfterTax.Text = String.Format("{0:0,0}", sumMoneyRoomAfterTax);
//danh sach dich vu
this.DetailReport2.DataSource = aListServicesGroupEN;
colNamService.DataBindings.Add("Text", this.DetailReport2.DataSource, "ServiceGroupName");
colTotalMoneyBeforeTax.DataBindings.Add("Text", this.DetailReport2.DataSource, "TotalMoneyBeforeTax", "{0:0,0}");
colPercentTaxService.DataBindings.Add("Text", this.DetailReport2.DataSource, "DisplayMoneyTax", "{0:0,0}");
colTotalMoneyServiceAfterTax.DataBindings.Add("Text", this.DetailReport2.DataSource, "TotalMoneyAfterTax", "{0:0,0}");
//tong tien dich vu truoc thue
lblSumMoneyService_BookingRBeforeTax.Text = String.Format("{0:0,0}", sumMoneyServiceRoomBeforeTax);
//Tien thue dich vu
lblSumMoneyServiceTax.Text = String.Format("{0:0,0}", sumMoneyTaxServices);
//tong tien dich vu sau thue
lblSumMoneyService_BookingRAfterTax.Text = String.Format("{0:0,0}", sumMoneyServiceRoomAfterTax);
//tong tien thanh toan truoc thue
lblTotalMoneyBookingRBeforeTax.Text = String.Format("{0:0,0}", (sumMoneyRoomBeforeTax + sumMoneyServiceRoomBeforeTax));
//Tong tien thue
lblTotalMoneyTax.Text = String.Format("{0:0,0}", (SumMoneyTaxRoom + sumMoneyTaxServices));
//tong tien thanh toan sau thue
lblTotalMoneyBookingRAfterTax.Text = String.Format("{0:0,0}", (sumMoneyRoomAfterTax + sumMoneyServiceRoomAfterTax));
//So tien ung truoc
lblBookingMoney_BookingR.Text = String.Format("{0:0,0}", BookingMoneyR);
//so tien con lai can thanh toan
lblTotalMoney_BookingR.Text = String.Format("{0:0,0}", ((sumMoneyRoomAfterTax + sumMoneyServiceRoomAfterTax) - BookingMoneyR));
string TotalMoney_BookingRString = UppercaseFirst(StringUtility.ConvertDecimalToString(Convert.ToDecimal((sumMoneyRoomAfterTax + sumMoneyServiceRoomAfterTax) - BookingMoneyR)));
lblTotalMoney_BookingRString.Text = "(" + TotalMoney_BookingRString + ")";
}
catch (Exception ex)
{
ex.ToString();
}
}
