/// <summary>
/// Carga los datos de deposits refund en el grid
/// </summary>
/// <history>
/// [vipacheco] 07/Junio/2016 Created
/// </history>
private async Task Load_Refund()
{
int Guest = 0, RefundID = 0;
string Folio = "", Name = "", Reservation = "", OutInv = "", PR = "";
DateTime?dateFrom = null, dateTo = null;
// Si no esta asociado a un Guest
if (!HasGuest())
{
// Criterio de busqueda
Guest = string.IsNullOrEmpty(txtguID.Text) ? 0 : Convert.ToInt32(txtguID.Text);
RefundID = string.IsNullOrEmpty(txtRefundID.Text) ? 0 : Convert.ToInt32(txtRefundID.Text);
Folio = string.IsNullOrEmpty(txtRefundFolio.Text) ? "" : txtRefundFolio.Text;
Name = string.IsNullOrEmpty(txtName.Text) ? "" : txtName.Text;
Reservation = string.IsNullOrEmpty(txtReservation.Text) ? "" : txtReservation.Text;
OutInv = string.IsNullOrEmpty(txtOutInvt.Text) ? "" : txtOutInvt.Text;
PR = string.IsNullOrEmpty(txtPR.Text) ? "" : txtPR.Text;
dateFrom = dtpStart.Value.Value.Date;
dateTo = dtpEnd.Value.Value.Date;
}
else
{
Guest = _GuestID;
}
// Ejecutamos el procedimiento
_lstRefund = await BRDepositsRefund.GetDepositsRefund(Guest, RefundID, Folio, Name, Reservation, OutInv, PR, dateFrom, dateTo);
// Asignamos el resultado al grid
CollectionViewSource _dsDepositsRefund = ((CollectionViewSource)(this.FindResource("dsRefund")));
_dsDepositsRefund.Source = _lstRefund;
Load_BookingDeposits();
}
/// <summary>
/// Realiza el guardado total del proceso
/// Actualiza los booking deposits, genera el depositrefund y lo asocia a los bookingdeposits
/// Aumenta el contados de folios
/// </summary>
/// <param name="pDeposits"></param>
/// <history>
/// [vipacheco] 21/Junio/2016 Created
/// </history>
private async Task Save(string pDeposits)
{
// Obtenemos el folio a crear
int folio = await BRRefundTypeFolios.GetRefundFolio(cborefundType.SelectedValue.ToString());
// guardamos la devolucion de depositos y marcamos los depositos como devueltos
await BRDepositsRefund.SaveDepositsRefund(Convert.ToInt32(txtID.Text), folio, cborefundType.SelectedValue.ToString(), pDeposits);
// actualizamos el folio usado
await BRRefundTypeFolios.UpdateRefundFolio(cborefundType.SelectedValue.ToString(), folio);
HasRefund = true;
}
/// <summary>
/// Imprime el reporte RefundsLetter
/// </summary>
/// <history>
/// [edgrodriguez] 15/Jul/2016 Created
/// </history>
private async void btnPrint_Click(object sender, RoutedEventArgs e)
{
var Refund = grdRefund.SelectedItem as DepositsRefund;
if (Refund != null)
{
var RptRefundLetter = await BRDepositsRefund.GetRptRefundLetter(Refund.drID);
if (RptRefundLetter.Any())
{
var objRptRefundletter = RptRefundLetter[0].Cast <RptRefundLetter>().FirstOrDefault();
var reportText = await BRReportsTexts.GetReportTexts("RefundLetter", objRptRefundletter.gula);
var header = reportText[0].reText
.Replace("[SaleRoom]", objRptRefundletter.SaleRoom)
.Replace("[RefundDate]", objRptRefundletter.RefundDate.ToString())
.Replace("[RefundID]", objRptRefundletter.RefundID.ToString())
.Replace("[RefundFolio]", objRptRefundletter.RefundFolio.ToString())
.Replace("[GuestID]", objRptRefundletter.GuestID.ToString())
.Replace("[OutInvt]", objRptRefundletter.OutInvt)
.Replace("[GuestNames]", objRptRefundletter.GuestNames)
.Replace("[TotalAmount]", objRptRefundletter.TotalAmount.ToString("#,##0.00"))
.Replace("[PRName]", objRptRefundletter.PRName);
var footer = reportText[1].reText;
var crptRefundLetter = new Reports.rptRefundLetter();
crptRefundLetter.Database.Tables["depositRefund"].SetDataSource(ObjectHelper.ObjectToList(objRptRefundletter));
crptRefundLetter.Database.Tables["reportText"].SetDataSource(ObjectHelper.ObjectToList(new Classes.objReportText {
Header = header, Footer = footer
}));
crptRefundLetter.Subreports["RptBookingDeposits.rpt"].SetDataSource(TableHelper.GetDataTableFromList(RptRefundLetter[1].Cast <RptRefundLetter_BookingDeposit>().ToList()));
CrystalReportHelper.SetLanguage(crptRefundLetter, objRptRefundletter.gula);
//(crptRefundLetter.ReportDefinition.ReportObjects["txtHeader"] as FieldObject).ObjectFormat. = header;
//(crptRefundLetter.ReportDefinition.ReportObjects["txtFooter"] as FieldObject).Text = footer;
var frmReportViewer = new frmViewer(crptRefundLetter);
frmReportViewer.Show();
}
}
else
{
UIHelper.ShowMessage("Select a Refund from the list.");
}
}
