/// <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."); } }