public static BookingPayment BookingPayment(System.Data.IDataReader reader)
{
BookingPayment result = null;
if (null != reader && reader.Read())
{
result = new BookingPayment();
PopulateBookingPayment(result, reader);
}
return result;
}
public static void PopulateBookingPayment(BookingPayment input, System.Data.IDataReader reader)
{
PopulateRecord(input, reader);
input.RecordId = Utilities.ToNInt(reader[Mimosa.Apartment.Common.BookingPayment.ColumnNames.BookingPaymentId]);
input.BookingId = Utilities.ToInt(reader[Mimosa.Apartment.Common.BookingPayment.ColumnNames.BookingId]);
input.DateStart = Utilities.ToDateTime(reader[Mimosa.Apartment.Common.BookingPayment.ColumnNames.DateStart]);
input.DateEnd = Utilities.ToDateTime(reader[Mimosa.Apartment.Common.BookingPayment.ColumnNames.DateEnd]);
input.RoomPrice = Utilities.ToDecimal(reader[Mimosa.Apartment.Common.BookingPayment.ColumnNames.RoomPrice]);
input.EquipmentPrice = Utilities.ToDecimal(reader[Mimosa.Apartment.Common.BookingPayment.ColumnNames.EquipmentPrice]);
input.ServicePrice = Utilities.ToDecimal(reader[Mimosa.Apartment.Common.BookingPayment.ColumnNames.ServicePrice]);
input.TotalPrice = Utilities.ToDecimal(reader[Mimosa.Apartment.Common.BookingPayment.ColumnNames.TotalPrice]);
input.CustomerPaid = Utilities.ToDecimal(reader[Mimosa.Apartment.Common.BookingPayment.ColumnNames.CustomerPaid]);
input.Payment = Utilities.ToBool(reader[Mimosa.Apartment.Common.BookingPayment.ColumnNames.Payment]);
input.MoneyLeft = input.TotalPrice - input.CustomerPaid;
input.SiteId = Utilities.ToInt(reader[Mimosa.Apartment.Common.BookingPayment.ColumnNames.SiteId]);
input.SiteName = Utilities.ToString(reader[Mimosa.Apartment.Common.BookingPayment.ColumnNames.SiteName]);
input.RoomId = Utilities.ToInt(reader[Mimosa.Apartment.Common.BookingPayment.ColumnNames.RoomId]);
input.RoomName = Utilities.ToString(reader[Mimosa.Apartment.Common.BookingPayment.ColumnNames.RoomName]);
input.CustomerId = Utilities.ToInt(reader[Mimosa.Apartment.Common.BookingPayment.ColumnNames.CustomerId]);
input.CustomerName = Utilities.ToString(reader[Mimosa.Apartment.Common.BookingPayment.ColumnNames.CustomerName]);
input.Customer2Id = Utilities.ToNInt(reader[Mimosa.Apartment.Common.BookingPayment.ColumnNames.Customer2Id]);
input.Customer2Name = Utilities.ToString(reader[Mimosa.Apartment.Common.BookingPayment.ColumnNames.Customer2Name]);
if (input.RecordId > 0)
{
input.BookingPaymentId = Convert.ToInt32(input.RecordId.Value);
}
}
private void BuildPaymentContent(BookingPayment paymentItem, StringBuilder strBuilder, string strFormat)
{
List<string> lstFields = new List<string>();
lstFields.Add(ReportHelper.FormatField("Site:", strFormat));
lstFields.Add(ReportHelper.FormatField(paymentItem.SiteName, strFormat));
ReportHelper.BuildStringOfRow(strBuilder, lstFields, strFormat);
lstFields.Clear();
lstFields.Add(ReportHelper.FormatField(lblRoom.Text, strFormat));
lstFields.Add(ReportHelper.FormatField(paymentItem.RoomName, strFormat));
ReportHelper.BuildStringOfRow(strBuilder, lstFields, strFormat);
lstFields.Clear();
lstFields.Add(ReportHelper.FormatField(lblCustomer1.Text, strFormat));
lstFields.Add(ReportHelper.FormatField(paymentItem.CustomerName, strFormat));
ReportHelper.BuildStringOfRow(strBuilder, lstFields, strFormat);
lstFields.Clear();
lstFields.Add(ReportHelper.FormatField(lblCustomer2.Text, strFormat));
lstFields.Add(ReportHelper.FormatField(paymentItem.Customer2Name, strFormat));
ReportHelper.BuildStringOfRow(strBuilder, lstFields, strFormat);
lstFields.Clear();
lstFields.Add(ReportHelper.FormatField(lblRoomPrice.Text, strFormat));
lstFields.Add(ReportHelper.FormatValueColumn(paymentItem.RoomPrice, "0.0", strFormat));
ReportHelper.BuildStringOfRow(strBuilder, lstFields, strFormat);
lstFields.Clear();
lstFields.Add(ReportHelper.FormatField(lblEquipmentPrice.Text, strFormat));
lstFields.Add(ReportHelper.FormatValueColumn(paymentItem.EquipmentPrice, "0.0", strFormat));
ReportHelper.BuildStringOfRow(strBuilder, lstFields, strFormat);
lstFields.Clear();
List<BookingRoomEquipmentDetail> equipmentDetails = gvwEquipmentDetails.ItemsSource as List<BookingRoomEquipmentDetail>;
if (equipmentDetails != null && equipmentDetails.Count > 0)
{
ReportHelper.AddEmptyColumn(lstFields, 1, strFormat);
lstFields.Add(ReportHelper.FormatField(gvwEquipmentDetails.Columns[0].Header.ToString(), strFormat));
lstFields.Add(ReportHelper.FormatField(gvwEquipmentDetails.Columns[1].Header.ToString(), strFormat));
lstFields.Add(ReportHelper.FormatField(gvwEquipmentDetails.Columns[2].Header.ToString(), strFormat));
lstFields.Add(ReportHelper.FormatField(gvwEquipmentDetails.Columns[3].Header.ToString(), strFormat));
lstFields.Add(ReportHelper.FormatField(gvwEquipmentDetails.Columns[4].Header.ToString(), strFormat));
lstFields.Add(ReportHelper.FormatField(gvwEquipmentDetails.Columns[5].Header.ToString(), strFormat));
lstFields.Add(ReportHelper.FormatField(gvwEquipmentDetails.Columns[6].Header.ToString(), strFormat));
lstFields.Add(ReportHelper.FormatField(gvwEquipmentDetails.Columns[7].Header.ToString(), strFormat));
ReportHelper.BuildStringOfRow(strBuilder, lstFields, strFormat);
lstFields.Clear();
foreach (BookingRoomEquipmentDetail item in equipmentDetails)
{
ReportHelper.AddEmptyColumn(lstFields, 1, strFormat);
lstFields.Add(ReportHelper.FormatField(item.Equipment, strFormat));
lstFields.Add(ReportHelper.FormatField(item.DateStart.Value.ToString("dd-MMM-yyyy"), strFormat));
lstFields.Add(ReportHelper.FormatField(item.DateEnd.Value.ToString("dd-MMM-yyyy"), strFormat));
lstFields.Add(ReportHelper.FormatField(item.Unit, strFormat));
lstFields.Add(ReportHelper.FormatValueColumn(item.Quantity, "0.0", strFormat));
lstFields.Add(ReportHelper.FormatValueColumn(item.Price, "0.0", strFormat));
lstFields.Add(ReportHelper.FormatValueColumn(item.TotalPrice, "0.0", strFormat));
lstFields.Add(ReportHelper.FormatField(item.Description, strFormat));
ReportHelper.BuildStringOfRow(strBuilder, lstFields, strFormat);
lstFields.Clear();
}
}
lstFields.Add(ReportHelper.FormatField(lblServicePrice.Text, strFormat));
lstFields.Add(ReportHelper.FormatValueColumn(paymentItem.ServicePrice, "0.0", strFormat));
ReportHelper.BuildStringOfRow(strBuilder, lstFields, strFormat);
lstFields.Clear();
List<BookingRoomServiceDetail> serviceDetails = gvwServiceDetails.ItemsSource as List<BookingRoomServiceDetail>;
if (serviceDetails != null && serviceDetails.Count > 0)
{
ReportHelper.AddEmptyColumn(lstFields, 1, strFormat);
lstFields.Add(ReportHelper.FormatField(gvwServiceDetails.Columns[0].Header.ToString(), strFormat));
lstFields.Add(ReportHelper.FormatField(gvwServiceDetails.Columns[1].Header.ToString(), strFormat));
lstFields.Add(ReportHelper.FormatField(gvwServiceDetails.Columns[2].Header.ToString(), strFormat));
lstFields.Add(ReportHelper.FormatField(gvwServiceDetails.Columns[3].Header.ToString(), strFormat));
lstFields.Add(ReportHelper.FormatField(gvwServiceDetails.Columns[4].Header.ToString(), strFormat));
lstFields.Add(ReportHelper.FormatField(gvwServiceDetails.Columns[5].Header.ToString(), strFormat));
lstFields.Add(ReportHelper.FormatField(gvwServiceDetails.Columns[6].Header.ToString(), strFormat));
lstFields.Add(ReportHelper.FormatField(gvwServiceDetails.Columns[7].Header.ToString(), strFormat));
ReportHelper.BuildStringOfRow(strBuilder, lstFields, strFormat);
lstFields.Clear();
foreach (BookingRoomServiceDetail item in serviceDetails)
{
ReportHelper.AddEmptyColumn(lstFields, 1, strFormat);
lstFields.Add(ReportHelper.FormatField(item.Service, strFormat));
lstFields.Add(ReportHelper.FormatField(item.DateStart.Value.ToString("dd-MMM-yyyy"), strFormat));
lstFields.Add(ReportHelper.FormatField(item.DateEnd.Value.ToString("dd-MMM-yyyy"), strFormat));
lstFields.Add(ReportHelper.FormatField(item.Unit, strFormat));
lstFields.Add(ReportHelper.FormatValueColumn(item.Quantity, "0.0", strFormat));
lstFields.Add(ReportHelper.FormatValueColumn(item.Price, "0.0", strFormat));
lstFields.Add(ReportHelper.FormatValueColumn(item.TotalPrice, "0.0", strFormat));
lstFields.Add(ReportHelper.FormatField(item.Description, strFormat));
ReportHelper.BuildStringOfRow(strBuilder, lstFields, strFormat);
lstFields.Clear();
}
}
lstFields.Add(ReportHelper.FormatField(lblTotalPrice.Text, strFormat));
lstFields.Add(ReportHelper.FormatValueColumn(paymentItem.TotalPrice, "0.0", strFormat));
ReportHelper.BuildStringOfRow(strBuilder, lstFields, strFormat);
lstFields.Clear();
lstFields.Add(ReportHelper.FormatField(lblTotalLeft.Text, strFormat));
lstFields.Add(ReportHelper.FormatValueColumn(paymentItem.MoneyLeft, "0.0", strFormat));
ReportHelper.BuildStringOfRow(strBuilder, lstFields, strFormat);
lstFields.Clear();
}
public void BindData(BookingPayment paymentItem)
{
this.DataContext = paymentItem;
DataServiceHelper.ListBookingRoomEquipmentDetailAsync(null, null, paymentItem.BookingId, paymentItem.DateStart, paymentItem.DateEnd, ListBookingRoomEquipmentDetailCompleted);
DataServiceHelper.ListBookingRoomServiceDetailAsync(null, null, paymentItem.BookingId, paymentItem.DateStart, paymentItem.DateEnd, ListBookingRoomServiceDetailCompleted);
}
private void SendOnePaymentMail(SmtpClient smtpClient, BookingPayment paymentItem)
{
MailMessage message = new MailMessage();
List<Customer> customers = ApartmentMethods.ListCustomer(null, paymentItem.CustomerId, null, null, null, false, null, null, true);
string email = string.Empty;
if (customers.Count > 0 && customers[0].ContactInformation != null && !string.IsNullOrEmpty(customers[0].ContactInformation.Email))
{
email = customers[0].ContactInformation.Email;
}
if (!string.IsNullOrEmpty(email))
{
string dateFormat = "dd-MMM-yyyy";
string moneyFormat = "C0";
message.To.Add(new MailAddress(email));
string subject = string.Format("Payment Details from {0} to {1}", paymentItem.DateStart.ToString(dateFormat), paymentItem.DateEnd.ToString(dateFormat));
message.Subject = subject;
message.IsBodyHtml = true;
using (FileStream stream = File.OpenRead(HttpContext.Current.Server.MapPath("/EmailTemplates/MonthlyPayment.htm")))
{
StringBuilder strb = new StringBuilder();
byte[] b = new byte[stream.Length];
UTF8Encoding temp = new UTF8Encoding(true);
while (stream.Read(b, 0, b.Length) > 0)
{
strb.Append(temp.GetString(b));
}
string content = strb.ToString();
CultureInfo customCultureInfo = new CultureInfo(MimosaSettings.GloblaCulture());
customCultureInfo.NumberFormat = (new CultureInfo(MimosaSettings.NumberFormatCulture())).NumberFormat;
customCultureInfo.DateTimeFormat = (new CultureInfo(MimosaSettings.DateTimeFormatCulture())).DateTimeFormat;
Thread.CurrentThread.CurrentCulture = customCultureInfo;
content = string.Format(content, paymentItem.CustomerName, subject, paymentItem.SiteName, paymentItem.RoomName,
paymentItem.DateStart.ToString(dateFormat), paymentItem.DateEnd.ToString(dateFormat),
paymentItem.RoomPrice.ToString(moneyFormat),
paymentItem.EquipmentPrice.ToString(moneyFormat),
paymentItem.ServicePrice.ToString(moneyFormat),
paymentItem.TotalPrice.ToString(moneyFormat),
paymentItem.CustomerPaid.ToString(moneyFormat),
paymentItem.MoneyLeft.ToString(moneyFormat));
message.Body = content;
smtpClient.Send(message);
}
}
}
private string BuildBookingPaymentContent(BookingPayment paymentItem)
{
StringBuilder strBuilder = new StringBuilder();
return strBuilder.ToString();
}
