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