/// <summary> /// Configuracion de controles del formulario. /// </summary> /// <history> /// [edgrodriguez] 03/Mar/2016 Created /// [emoguel] 29/09/2016 Modified--->Se agregó un parametro para saber si mostrará el combo de "DateBasedOn" y el nombre del reporte /// </history> public void ConfigurarFomulario(bool blnSalesRoom = false, bool blnAllSalesRoom = false, bool blnGifts = false, bool blnAllGifts = false, bool blnCategories = false, bool blnAllCategories = false, bool blnPrograms = false, bool blnAllPrograms = false, bool blnRatetypes = false, bool blnAllRatetypes = false, bool blnLeadSources = false, bool blnAllLeadSources = false, bool blnWarehouse = false, bool blnAllWarehouse = false, bool blnOneDate = false, bool blnOnlyOneRegister = false, EnumPeriod enumPeriod = EnumPeriod.None, EnumProgram enumPrograms = EnumProgram.All, bool blnOnePeriod = false, EnumBasedOnArrival enumBasedOnArrival = EnumBasedOnArrival.NoBasedOnArrival, EnumQuinellas enumQuinellas = EnumQuinellas.NoQuinellas, EnumDetailGifts enumDetailGifts = EnumDetailGifts.NoDetailGifts, EnumSaveCourtesyTours?enumSaveCourtesyTours = null, EnumSalesByMemberShipType enumSalesByMemberShipType = EnumSalesByMemberShipType.NoDetail, EnumBasedOnBooking enumBasedOnBooking = EnumBasedOnBooking.NoBasedOnBooking, EnumExternalInvitation?enumExternalInvitation = null, bool blncbStatus = false, bool blnGiftReceiptType = false, bool blnGuestId = false, bool blnGiftSale = false, bool blnDateRange = true, bool blnDateBaseOn = false, string strReportName = "") { ConfigureDates(blnOneDate, enumPeriod, blnDateRange); ConfigureFilters(enumBasedOnArrival, enumQuinellas, enumDetailGifts, enumSaveCourtesyTours, enumSalesByMemberShipType, enumBasedOnBooking, enumExternalInvitation, blncbStatus, blnGiftReceiptType, blnGuestId, blnGiftSale, blnDateBaseOn); LoadCombos(); #region Configuracion de Grids. LoadSalesRooms(blnOnlyOneRegister, blnSalesRoom, blnAllSalesRoom); LoadCategories(blnOnlyOneRegister, blnCategories, blnAllCategories); LoadGifts(blnOnlyOneRegister, blnGifts, blnAllGifts); LoadLeadSources(blnOnlyOneRegister, blnLeadSources, blnAllLeadSources); LoadPrograms(blnOnlyOneRegister, blnPrograms, blnAllPrograms); LoadRateTypes(blnOnlyOneRegister, blnRatetypes, blnAllRatetypes); LoadWarehouses(blnOnlyOneRegister, blnWarehouse, blnAllWarehouse); #endregion Configuracion de Grids. LoadDateBasedOn(strReportName); LoadUserFilters(blnOneDate); }
/// <summary> /// Configura los controles del formulario /// </summary> /// <history> /// [vku] 22/Mar/2016 Created /// </history> public void ConfigureForm(bool blnLeadSource = false, bool blnLeadSourcesPaymentComm = false, bool blnAllLeadSource = false, bool blnAllLeadSourcePaymentComm = false, bool blnPaymentTypes = false, bool blnAllPaymentTypes = false, bool blnPRs = false, bool blnAllPRs = false, bool blnChargeTo = false, bool blnAllChargeTo = false, bool blnGifts = false, bool blnAllGifts = false, bool blnGiftProdGift = false, bool blnAllGiftProdGift = false, bool blnRangeFolios = false, bool blnAllRangeFolios = false, bool blnOneDate = false, bool blnOnlyOneRegister = false, bool blnChkUsedate = false, EnumPeriod enumPeriod = EnumPeriod.None, EnumProgram enumPrograms = EnumProgram.Outhouse, bool blnOnePeriod = false, EnumBasedOnArrival enumBasedOnArrival = EnumBasedOnArrival.NoBasedOnArrival, EnumQuinellas enumQuinellas = EnumQuinellas.NoQuinellas, EnumDetailGifts enumDetailGifts = EnumDetailGifts.NoDetailGifts, EnumSaveCourtesyTours?enumSaveCourtesyTours = null, EnumSalesByMemberShipType enumSalesByMemberShipType = EnumSalesByMemberShipType.NoDetail, EnumBasedOnBooking enumBasedOnBooking = EnumBasedOnBooking.NoBasedOnBooking, EnumExternalInvitation?enumExternalInvitation = null, bool blnFolSeries = false, bool blnFolFrom = false, bool blnFolTo = false, bool blnUseDates = false, bool blnAllFolios = false) { ConfigureDates(blnOneDate, enumPeriod); ConfigureFilters(enumBasedOnArrival, enumQuinellas, enumDetailGifts, enumSaveCourtesyTours, enumSalesByMemberShipType, enumBasedOnBooking, enumExternalInvitation, blnFolSeries, blnFolFrom, blnFolTo, blnUseDates, blnAllFolios); LoadCombos(); #region Configuracion de grids LoadLeadSources(blnOnlyOneRegister, blnLeadSource, blnAllLeadSource, enumPrograms); LoadLeadSourcesPaymentCoom(blnOnlyOneRegister, blnLeadSourcesPaymentComm, blnAllLeadSourcePaymentComm); LoadPaymentTypes(blnOnlyOneRegister, blnPaymentTypes, blnAllPaymentTypes); LoadPRs(blnOnlyOneRegister, blnPRs, blnAllPRs); LoadChargeTo(blnOnlyOneRegister, blnChargeTo, blnAllChargeTo); LoadGifts(blnOnlyOneRegister, blnGifts, blnAllGifts); LoadGiftsProdGift(blnOnlyOneRegister, blnGiftProdGift, blnAllGiftProdGift); #endregion LoadUserFilters(); }
/// <summary> /// Configura los controles que sirven para filtrar los reportes. /// </summary> /// <history> /// [edgrodriguez] 07/03/2016 Created /// [emoguel] 29/09/2016 Modified--->Ahora se muestra u oculta el combobox de DateBasedOn /// </history> private void ConfigureFilters(EnumBasedOnArrival enumBasedOnArrival, EnumQuinellas enumQuinellas, EnumDetailGifts enumDetailGifts, EnumSaveCourtesyTours?enumSaveCourtesyTours, EnumSalesByMemberShipType?enumSalesMemberShipType, EnumBasedOnBooking enumBasedOnBooking, EnumExternalInvitation?enumExternalInvitation, bool blncbStatus, bool blnGiftReceiptType, bool blnGuestId, bool blnGiftSale, bool blnDateBasedOn) { chkDetailGifts.Visibility = (enumDetailGifts == EnumDetailGifts.DetailGifts) ? Visibility.Visible : Visibility.Collapsed; chkBasedOnArrival.Visibility = (enumBasedOnArrival == EnumBasedOnArrival.BasedOnArrival) ? Visibility.Visible : Visibility.Collapsed; chkQuinellas.Visibility = (enumQuinellas == EnumQuinellas.Quinellas) ? Visibility.Visible : Visibility.Collapsed; cboSaveCourtesyTours.Visibility = (enumSaveCourtesyTours != null) ? Visibility.Visible : Visibility.Collapsed; chkSalesByMembershipType.Visibility = (enumSalesMemberShipType == EnumSalesByMemberShipType.Detail) ? Visibility.Visible : Visibility.Collapsed; chkBasedOnBooking.Visibility = (enumBasedOnBooking == EnumBasedOnBooking.BasedOnBooking) ? Visibility.Visible : Visibility.Collapsed; cboExternal.Visibility = (enumExternalInvitation != null) ? Visibility.Visible : Visibility.Collapsed; cboStatus.Visibility = lblStatus.Visibility = (blncbStatus) ? Visibility.Visible : Visibility.Collapsed; cboGiftsReceiptType.Visibility = lblGiftReceiptType.Visibility = (blnGiftReceiptType) ? Visibility.Visible : Visibility.Collapsed; txtGuestID.Visibility = lblGuestID.Visibility = (blnGuestId) ? Visibility.Visible : Visibility.Collapsed; cboGiftSale.Visibility = lblGiftSale.Visibility = (blnGiftSale) ? Visibility.Visible : Visibility.Collapsed; cboSaveCourtesyTours.Visibility = (enumSaveCourtesyTours != null) ? Visibility.Visible : Visibility.Collapsed; cboExternal.Visibility = (enumExternalInvitation != null) ? Visibility.Visible : Visibility.Collapsed; txbDateBO.Visibility = (blnDateBasedOn) ? Visibility.Visible : Visibility.Collapsed; cmbDateBO.Visibility = (blnDateBasedOn) ? Visibility.Visible : Visibility.Collapsed; }
/// <summary> /// Configura los controles para los filtros de los reportes /// </summary> /// <history> /// [vku] 22/Mar/2016 Created /// </history> private void ConfigureFilters(EnumBasedOnArrival enumBasedOnArrival, EnumQuinellas enumQuinellas, EnumDetailGifts enumDetailGifts, EnumSaveCourtesyTours?enumSaveCourtesyTours, EnumSalesByMemberShipType?enumSalesMemberShipType, EnumBasedOnBooking enumBasedOnBooking, EnumExternalInvitation?enumExternalInvitation, bool blnFolSeries, bool blnFolFrom, bool blnFolTo, bool blnUseDates, bool blnAllFolios) { chkDetailGifts.Visibility = (enumDetailGifts == EnumDetailGifts.DetailGifts) ? Visibility.Visible : Visibility.Collapsed; chkBasedOnArrival.Visibility = (enumBasedOnArrival == EnumBasedOnArrival.BasedOnArrival) ? Visibility.Visible : Visibility.Collapsed; chkQuinellas.Visibility = (enumQuinellas == EnumQuinellas.Quinellas) ? Visibility.Visible : Visibility.Collapsed; cboSaveCourtesyTours.Visibility = (enumSaveCourtesyTours != null) ? Visibility.Visible : Visibility.Collapsed; chkSalesByMembershipType.Visibility = (enumSalesMemberShipType == EnumSalesByMemberShipType.Detail) ? Visibility.Visible : Visibility.Collapsed; chkBasedOnBooking.Visibility = (enumBasedOnBooking == EnumBasedOnBooking.BasedOnBooking) ? Visibility.Visible : Visibility.Collapsed; cboExternal.Visibility = (enumExternalInvitation != null) ? Visibility.Visible : Visibility.Collapsed; txtFolFrom.Visibility = lblFolFrom.Visibility = (blnFolFrom) ? Visibility.Visible : Visibility.Collapsed; txtFolTo.Visibility = lblFolTo.Visibility = (blnFolTo) ? Visibility.Visible : Visibility.Collapsed; chkUseDates.Visibility = (blnUseDates) ? Visibility.Visible : Visibility.Collapsed; chkUseDates.IsChecked = chkUseDates.IsChecked = (blnUseDates) ? true : false; chkAllFolios.Visibility = (blnAllFolios) ? Visibility.Visible : Visibility.Collapsed; cboSaveCourtesyTours.Visibility = (enumSaveCourtesyTours != null) ? Visibility.Visible : Visibility.Collapsed; cboExternal.Visibility = (enumExternalInvitation != null) ? Visibility.Visible : Visibility.Collapsed; cboFolSeries.Visibility = lblFolSeries.Visibility = (blnFolSeries) ? Visibility.Visible : Visibility.Collapsed; }
/// <summary> /// Devuelve los datos para el reporte de produccion por membresia /// </summary> /// <param name="dtmStart">Fecha desde</param> /// <param name="dtmEnd">Fecha hasta</param> /// <param name="leadSources">Claves de Lead Sources</param> /// <param name="pRs">Claves de PRs</param> /// <param name="program">Clave de programa</param> /// <param name="aplication">Clave de membresia</param> /// <param name="company">Clave de compania</param> /// <param name="club">Clave de club</param> /// <param name="onlyWholesalers">Indica si se desean solo mayoristas</param> /// <param name="considerQuinellas">Indica si se debe considerar quinielas</param> /// <param name="basedOnArrival">Indica si se debe basar en la fecha de llegada</param> /// <returns><list type="RptProductionByMember"></list></returns> /// <history> /// [aalcocer] 03/05/2016 Created /// [aalcocer] 24/05/2016 Modified. Se agregó asincronía /// </history> public static async Task <List <RptProductionByMember> > GetRptProductionByMembers(DateTime dtmStart, DateTime dtmEnd, IEnumerable <string> leadSources, IEnumerable <string> pRs = null, EnumProgram program = EnumProgram.All, string aplication = "", int company = 0, Club club = null, EnumOnlyWholesalers onlyWholesalers = EnumOnlyWholesalers.NoOnlyWholesalers, EnumQuinellas considerQuinellas = EnumQuinellas.NoQuinellas, EnumBasedOnArrival basedOnArrival = EnumBasedOnArrival.NoBasedOnArrival) { var result = new List <RptProductionByMember>(); if (pRs == null || !pRs.Any()) { pRs = new[] { "ALL" } } ; await Task.Run(() => { using (var dbContext = new IMEntities(ConnectionHelper.ConnectionString())) { dbContext.Database.CommandTimeout = Settings.Default.USP_OR_RptProductionByMember_Timeout; result = dbContext.USP_OR_RptProductionByMember(dtmStart, dtmEnd, string.Join(",", leadSources), string.Join(",", pRs), EnumToListHelper.GetEnumDescription(program), string.IsNullOrWhiteSpace(aplication) ? "ALL" : aplication, company, club?.clID, Convert.ToBoolean(onlyWholesalers), Convert.ToBoolean(considerQuinellas), Convert.ToBoolean(basedOnArrival)).ToList(); } }); return(result); }
/// <summary> /// Devuelve los datos para el reporte de porcentaje de show por fecha de booking /// </summary> /// <param name="dtmStart">Fecha desde</param> /// <param name="dtmEnd">Fecha hasta</param> /// <param name="agencies">Claves de agencias</param> /// <param name="considerQuinellas">Indica si se debe considerar quinielas</param> /// <param name="basedOnArrival">Indica si se debe basar en la fecha de llegada</param> /// <returns><list type="RptProductionByAgencyMonthly"></list></returns> /// <history> /// [aalcocer] 21/04/2016 Created /// [aalcocer] 24/05/2016 Modified. Se agregó asincronía /// </history> public static async Task <List <RptProductionByAgencyMonthly> > GetRptProductionByAgencyMonthly(DateTime dtmStart, DateTime dtmEnd, IEnumerable <string> agencies, EnumQuinellas considerQuinellas = EnumQuinellas.NoQuinellas, EnumBasedOnArrival basedOnArrival = EnumBasedOnArrival.NoBasedOnArrival) { var result = new List <RptProductionByAgencyMonthly>(); await Task.Run(() => { using (var dbContext = new IMEntities(ConnectionHelper.ConnectionString())) { dbContext.Database.CommandTimeout = Settings.Default.USP_OR_RptProductionByAgencyMonthly_Timeout; result = dbContext.USP_OR_RptProductionByAgencyMonthly(dtmStart, dtmEnd, string.Join(",", agencies), Convert.ToBoolean(considerQuinellas), Convert.ToBoolean(basedOnArrival)).ToList(); } }); return(result); }
/// <summary> /// Obtiene el reporte Production By Lead Source & Market(Monthly). /// </summary> /// <returns>List of RptProductionByLeadSourceMarketMonthly</returns> /// <history> /// [edgrodriguez] 21/Abr/2016 Created /// </history> public static async Task <List <RptProductionByLeadSourceMarketMonthly> > GetRptProductionByLeadSourceMarketMonthly(DateTime?dtmStart, DateTime?dtmEnd, EnumQuinellas quinellas, EnumExternalInvitation external, EnumBasedOnArrival basedOnArrival, string leadSources = "ALL", EnumProgram program = EnumProgram.All) { return(await Task.Run(() => { using (var dbContext = new IMEntities(ConnectionHelper.ConnectionString())) { return dbContext.USP_OR_RptProductionByLeadSourceMarketMonthly(dtmStart, dtmEnd, leadSources, EnumToListHelper.GetEnumDescription(program), Convert.ToBoolean(quinellas), Convert.ToInt32(external), Convert.ToBoolean(basedOnArrival)).ToList(); } })); }