/// <summary>
/// Formato para el reporte Premanifest de Hosts e Inhouse
/// </summary>
/// <returns> List of ColumnFormat</returns>
/// <history>
/// [edgrodriguez] 21/Jun/2016 Created
/// </history>
public static ColumnFormatList RptPremanifest()
{
ColumnFormatList lst = new ColumnFormatList();
lst.Add("SR", "srN", EnumFormatTypeExcel.General, isGroup: true, isVisible: false);
lst.Add("LS", "loN", EnumFormatTypeExcel.General, isGroup: true, isVisible: false);
lst.Add("GUID", "guID", EnumFormatTypeExcel.Id);
lst.Add("Hotel", "guHotel", EnumFormatTypeExcel.General);
lst.Add("Room", "guRoomNum", EnumFormatTypeExcel.General);
lst.Add("LastName", "guLastName1", EnumFormatTypeExcel.General);
lst.Add("Pax", "guPax", EnumFormatTypeExcel.DecimalNumber);
lst.Add("Check-In", "guCheckInD", EnumFormatTypeExcel.Date);
lst.Add("Check-Out", "guCheckOutD", EnumFormatTypeExcel.Date);
lst.Add("Country ID", "guco", EnumFormatTypeExcel.General);
lst.Add("Country", "coN", EnumFormatTypeExcel.General);
lst.Add("Agency ID", "guag", EnumFormatTypeExcel.General);
lst.Add("Agency", "agN", EnumFormatTypeExcel.General);
lst.Add("Invit D", "guInvitD", EnumFormatTypeExcel.Date);
lst.Add("Invit T", "guInvitT", EnumFormatTypeExcel.Time);
lst.Add("Book T", "guBookT", EnumFormatTypeExcel.Time);
lst.Add("PR B", "guPRInvit1", EnumFormatTypeExcel.General);
lst.Add("Clxd", "guBookCanc", EnumFormatTypeExcel.Boolean);
lst.Add("Rsc", "guResch", EnumFormatTypeExcel.Boolean);
lst.Add("Sh", "guShow", EnumFormatTypeExcel.Boolean);
lst.Add("Sale", "guSale", EnumFormatTypeExcel.General);
lst.Add("InvitType", "InvitType", EnumFormatTypeExcel.General);
lst.Add("Deposits_Comments", "guComments", EnumFormatTypeExcel.General);
return(lst);
}
/// <summary>
/// Formato para el reporte Premanifest With Gifts de Host e Inhouse
/// </summary>
/// <returns> List of ColumnFormat</returns>
/// <history>
/// [edgrodriguez] 21/Jun/2016 Created
/// </history>
public static ColumnFormatList RptPremanifestWithGifts()
{
ColumnFormatList lst = new ColumnFormatList();
lst.Add("Sales Room", "srN", EnumFormatTypeExcel.General, isGroup: true, isVisible: false);
lst.Add("Location", "loN", EnumFormatTypeExcel.General, isGroup: true, isVisible: false);
lst.Add("GUID", "guID", EnumFormatTypeExcel.Id);
lst.Add("LS", "guls", EnumFormatTypeExcel.General);
lst.Add("Room", "guRoomNum", EnumFormatTypeExcel.General);
lst.Add("Last Name", "guLastName1", EnumFormatTypeExcel.General);
lst.Add("County ID", "guco", EnumFormatTypeExcel.General);
lst.Add("County", "coN", EnumFormatTypeExcel.General);
lst.Add("Hotel", "guHotel", EnumFormatTypeExcel.General);
lst.Add("Pax", "guPax", EnumFormatTypeExcel.DecimalNumber);
lst.Add("Invit D", "guInvitD", EnumFormatTypeExcel.Date);
lst.Add("Invit T", "guInvitT", EnumFormatTypeExcel.Time);
lst.Add("Resch", "guReschDT", EnumFormatTypeExcel.Date);
lst.Add("CheckIn", "guCheckInD", EnumFormatTypeExcel.Date);
lst.Add("CheckOut", "guCheckOutD", EnumFormatTypeExcel.Date);
lst.Add("Agency ID", "guag", EnumFormatTypeExcel.General);
lst.Add("Agency", "agN", EnumFormatTypeExcel.General);
lst.Add("Comments", "guComments", EnumFormatTypeExcel.General);
lst.Add("Book T", "guBookT", EnumFormatTypeExcel.Time);
lst.Add("PR", "guPRInvit1", EnumFormatTypeExcel.General);
lst.Add("G.T./CC", "guO2", EnumFormatTypeExcel.General);
lst.Add("CCType", "guCCType", EnumFormatTypeExcel.General);
lst.Add("Sh", "guShow", EnumFormatTypeExcel.General);
lst.Add("Sa", "guSale", EnumFormatTypeExcel.General);
lst.Add("Canc Book", "guBookCanc", EnumFormatTypeExcel.General);
lst.Add("Gifts", "Gifts", EnumFormatTypeExcel.General);
return(lst);
}
/// <summary>
/// Genera las columnas que necesito en el reporte Sales by PR
/// </summary>
/// <returns>List<ColumnFormatList></returns>
/// <history>
/// [erosado] 23/Mar/2016 Created
/// </history>
public static ColumnFormatList getExcelFormatTable()
{
ColumnFormatList formatColumns = new ColumnFormatList();
formatColumns.Add("Sale ID", "saID");
formatColumns.Add("LS", "sals");
formatColumns.Add("SR", "sasr");
formatColumns.Add("Member. #", "saMembershipNum");
formatColumns.Add("Sale Type", "stN");
formatColumns.Add("Date", "saD", format: EnumFormatTypeExcel.Date); //Date
formatColumns.Add("Proc Date", "saProcD", format: EnumFormatTypeExcel.Date); //Date
formatColumns.Add("Last Name", "saLastName1");
formatColumns.Add("Chk-Out D", "guCheckOutD", format: EnumFormatTypeExcel.Date); //Date
formatColumns.Add("Agency ID", "guag");
formatColumns.Add("Agency", "agN");
formatColumns.Add("PR", "saPR1");
formatColumns.Add("PR Name", "PR1N");
formatColumns.Add("PR2", "saPR2");
formatColumns.Add("PR2 Name", "PR2N");
formatColumns.Add("PR3", "saPR3");
formatColumns.Add("PR3 Name", "PR3N");
formatColumns.Add("Q", "guQ", format: EnumFormatTypeExcel.Boolean); //Boolean
formatColumns.Add("Amount", "saGrossAmount", format: EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum); //Currency
formatColumns.Add("Cxld", "saCancel", format: EnumFormatTypeExcel.Boolean); //Boolean
formatColumns.Add("Cancel D", "saCancelD", format: EnumFormatTypeExcel.Date); //Date
return(formatColumns);
}
/// <summary>
/// Obtiene Un reporte de Arrivals en formato de Excel
/// </summary>
/// <param name="arrivlas">Lista de Arrivals para hacer el excel</param>}
/// <history>
/// [ecanul] 19/04/2016 Created
/// [jorcanche] se agrego para abrir el archivo despues de guardar
/// </history>
public async static void ArrivalsToExcel(List <RptArrivals> arrivlas, DateTime date, Window window)
{
filters = new List <Tuple <string, string> >();
dt = new DataTable();
filters.Add(Tuple.Create("Lead Source", Context.User.LeadSource.lsID));
if (arrivlas.Count > 0)
{
dt = TableHelper.GetDataTableFromList(arrivlas, true);
rptName = "Arrivals ";
string dateRange = DateHelper.DateRangeFileName(date, date);
ColumnFormatList format = new ColumnFormatList();
format.Add("GUID", "guID", width: 7);
format.Add("Reserv.#", "guHReservID", width: 8);
format.Add("Room", "guRoomNum", width: 7);
format.Add("LastName", "guLastName1", width: 20);
format.Add("In", "guCheckIn", format: EnumFormatTypeExcel.Boolean, width: 4, aligment: OfficeOpenXml.Style.ExcelHorizontalAlignment.Center);
format.Add("Pax", "guPax", format: EnumFormatTypeExcel.DecimalNumber, width: 6, aligment: OfficeOpenXml.Style.ExcelHorizontalAlignment.Center);
format.Add("Check-Out", "guCheckOutD", format: EnumFormatTypeExcel.Date, width: 10);
format.Add("Country", "coN", width: 13);
format.Add("Agency", "agN", width: 15, wordWrap: true);
format.Add("Av", "guAvail", format: EnumFormatTypeExcel.Boolean, width: 4, aligment: OfficeOpenXml.Style.ExcelHorizontalAlignment.Center);
format.Add("Info", "guInfo", format: EnumFormatTypeExcel.Boolean, width: 4, aligment: OfficeOpenXml.Style.ExcelHorizontalAlignment.Center);
format.Add("Inv", "guInvit", format: EnumFormatTypeExcel.Boolean, width: 4, aligment: OfficeOpenXml.Style.ExcelHorizontalAlignment.Center);
format.Add("PR B", "guPRInvit1", width: 15);
format.Add("Comments", "guComments", width: 40, wordWrap: true);
format.Add("County ID", "guco", isVisible: false);
format.Add("Agency ID", "guag", isVisible: false);
OpenFile(await ReportBuilder.CreateCustomExcelAsync(dt, filters, rptName, dateRange, format, addEnumeration: true, autoFit: false, numColumnsForApplicationName: 4), window);
}
}
/// <summary>
/// Obtiene un reporte de Aviables en formato Excel
/// </summary>
/// <param name="aviables">Lista de Aviables</param>
/// <history>
/// [ecanul] 19/04/2016 Created
/// [jorcanche] se agrego para abrir el archivo despues de guardar
/// </history>
public async static void AvailablesToExcel(List <RptAvailables> aviables, Window window)
{
filters = new List <Tuple <string, string> >();
dt = new DataTable();
filters.Add(Tuple.Create("Lead Source", Context.User.LeadSource.lsID));
DateTime date = BRHelpers.GetServerDate();
if (aviables.Count > 0)
{
dt = TableHelper.GetDataTableFromList(aviables, true);
rptName = "Availables";
string dateRange = DateHelper.DateRangeFileName(date, date);
ColumnFormatList format = new ColumnFormatList();
format.Add("GUID", "guID");
format.Add("Reserv.#", "guHReservID");
format.Add("Room", "guRoomNum");
format.Add("LastName", "guLastName1");
format.Add("Pax", "guPax", format: EnumFormatTypeExcel.DecimalNumber);
format.Add("Check-In", "guCheckInD", format: EnumFormatTypeExcel.Date);
format.Add("Check-Out", "guCheckOutD", format: EnumFormatTypeExcel.Date);
format.Add("Country ID", "guco");
format.Add("Country", "coN");
format.Add("Agency ID", "guag");
format.Add("Agency", "agN");
format.Add("Av", "guAvail", format: EnumFormatTypeExcel.Boolean);
format.Add("Info", "guInfo", format: EnumFormatTypeExcel.Boolean);
format.Add("Inv", "guInvit", format: EnumFormatTypeExcel.Boolean);
format.Add("PR B", "guPRInvit1");
format.Add("Comments", "guComments");
OpenFile(await ReportBuilder.CreateCustomExcelAsync(dt, filters, rptName, dateRange, format, addEnumeration: true), window);
}
}
/// <summary>
/// Formato para el reporte Gifts Receipts Log
/// </summary>
/// <returns> List of ColumnFormat</returns>
/// <history>
/// [edgrodriguez] 08/Jun/2016 Created
/// </history>
public static ColumnFormatList RptGiftReceiptsLog()
{
ColumnFormatList lst = new ColumnFormatList();
lst.Add("Sales man", "goChangedBy");
lst.Add("Name", "ChangedByN");
lst.Add("Update Date/Time", "goID", format: EnumFormatTypeExcel.DateTime);
lst.Add("Receipt D", "goD", format: EnumFormatTypeExcel.Date);
lst.Add("Offered By", "gope");
lst.Add("Offered By Name", "OfferedByN");
lst.Add("Host", "goHost");
lst.Add("Host Name", "HostN");
lst.Add("Deposit", "goDeposit", format: EnumFormatTypeExcel.Currency);
lst.Add("Burned", "goBurned", format: EnumFormatTypeExcel.Currency);
lst.Add("Currency", "gocu");
lst.Add("Payment Type", "ptN");
lst.Add("CxC PR Dep", "goCXCPRDeposit", format: EnumFormatTypeExcel.Currency);
lst.Add("Taxit Out", "goTaxiOut", format: EnumFormatTypeExcel.Currency);
lst.Add("Total Gifts", "goTotalGifts", format: EnumFormatTypeExcel.DecimalNumber);
lst.Add("Charge To", "goct");
lst.Add("CxC Gifts", "goCXCGifts", format: EnumFormatTypeExcel.Currency);
lst.Add("CxC Adj.", "goCXCAdj", format: EnumFormatTypeExcel.Currency);
lst.Add("Re-Printed", "goReimpresion");
lst.Add("Re-Printed Motive", "rmN");
lst.Add("Authorized By", "goAuthorizedBy");
lst.Add("Authorized By Name", "AuthorizedByN");
lst.Add("Paid", "goAmountPaid", format: EnumFormatTypeExcel.Currency);
lst.Add("Under Pay Motive", "upN");
lst.Add("Cancelled Date", "goCancelD", format: EnumFormatTypeExcel.Date);
return(lst);
}
/// <summary>
/// Genera las columnas que necesito en el reporte RPTStatistics
/// </summary>
/// <returns>List<ColumnFormat></returns>
/// <history>
/// [erosado] 23/Mar/2016 Created
/// </history>
public static ColumnFormatList getExcelFormatTable()
{
ColumnFormatList formatColumns = new ColumnFormatList();
formatColumns.Add("Sale ID", "saID");
formatColumns.Add("LS", "sals");
formatColumns.Add("SR", "sasr");
formatColumns.Add("Member. #", "saMembershipNum");
formatColumns.Add("Sale Type", "stN");
formatColumns.Add("Date", "saD", format: EnumFormatTypeExcel.Date); //Date
formatColumns.Add("Proc Date", "saProcD", format: EnumFormatTypeExcel.Date); //Date
formatColumns.Add("Last Name", "saLastName1");
formatColumns.Add("Closer", "saCloser1");
formatColumns.Add("Closer Name", "Closer1N");
formatColumns.Add("Closer 2", "saCloser2");
formatColumns.Add("Closer 2 Name", "Closer2N");
formatColumns.Add("Closer 3", "saCloser3");
formatColumns.Add("Closer 3 Name", "Closer3N");
formatColumns.Add("Exit", "saExit1");
formatColumns.Add("Exit Name", "Exit1N");
formatColumns.Add("Exit 2", "saExit2");
formatColumns.Add("Exit 2 Name", "Exit2N");
formatColumns.Add("Amount", "saGrossAmount", format: EnumFormatTypeExcel.Currency); //Currency
formatColumns.Add("Cxld", "saCancel", format: EnumFormatTypeExcel.Boolean); //Boolean
formatColumns.Add("Cancel D", "saCancelD", format: EnumFormatTypeExcel.Date); //Date
return(formatColumns);
}
/// <summary>
/// Formato para el reporte Guest Manifest Range de Host y Processor General
/// </summary>
/// <history>
/// [edgrodriguez] 13/Jun/2016 Created
/// </history>
public static ColumnFormatList RptManifestRangeByLs_Bookings()
{
ColumnFormatList lst = new ColumnFormatList();
lst.Add("guloInvit", "guloInvit", isVisible: false);
lst.Add("LocationN", "LocationN", axis: ePivotFieldAxis.Row);
lst.Add("guBookT", "guBookT", axis: ePivotFieldAxis.Column, sort: eSortType.Ascending);
lst.Add("guBookTime", "guBookTime", axis: ePivotFieldAxis.Values);
lst.Add("Bookings", "Bookings", EnumFormatTypeExcel.Number, axis: ePivotFieldAxis.Values);
return(lst);
}
/// <summary>
/// Formato para el reporte Exchange Rates Log
/// </summary>
/// <returns> List of ColumnFormat</returns>
/// <history>
/// [edgrodriguez] 08/Jul/2016 Created
/// </history>
public static ColumnFormatList RptExchangeRatesLog()
{
ColumnFormatList lst = new ColumnFormatList();
lst.Add("By", "elChangedBy");
lst.Add("Name", "ChangedByN");
lst.Add("Update Date/Time", "elID", format: EnumFormatTypeExcel.DateTime);
lst.Add("Currency", "elcu");
lst.Add("Exch. Rate", "elExchangeRate", format: EnumFormatTypeExcel.DecimalNumber);
return(lst);
}
/// <summary>
/// Formato para el reporte de Guest Movements
/// </summary>
/// <history>
/// [jorcanche] created 07072016
/// </history>
public static ColumnFormatList RptGuestMovements()
{
ColumnFormatList lst = new ColumnFormatList();
lst.Add("By", "gmpe");
lst.Add("Name", "peN");
lst.Add("Date/Time", "gmDT");
lst.Add("Movement", "gnN");
lst.Add("Computer", "gmcp");
lst.Add("Computer name", "cpN");
lst.Add("IP Address", "gmIpAddress");
return(lst);
}
/// <summary>
/// Formato para el reporte Gifts Receipts Log
/// </summary>
/// <returns> List of ColumnFormat</returns>
/// <history>
/// [edgrodriguez] 08/Jun/2016 Created
/// </history>
public static ColumnFormatList RptCloseSalesRoomLog()
{
ColumnFormatList lst = new ColumnFormatList();
lst.Add("By", "sqChangedBy");
lst.Add("Name", "ChangedByN");
lst.Add("Update Date/Time", "sqID", format: EnumFormatTypeExcel.DateTime);
lst.Add("Shows Close D", "sqShowsCloseD", format: EnumFormatTypeExcel.Date);
lst.Add("Meal T Close D", "sqMealTicketsCloseD", format: EnumFormatTypeExcel.Date);
lst.Add("Sales Close D", "sqSalesCloseD", format: EnumFormatTypeExcel.Date);
lst.Add("Gifts Rcpt Close D", "sqGiftsRcptCloseD", format: EnumFormatTypeExcel.Date);
lst.Add("CxC Close D", "sqCxCCloseD", format: EnumFormatTypeExcel.Date);
return(lst);
}
/// <summary>
/// Genera las columnas que necesito en el reporte RPTStatistics
/// </summary>
/// <returns>List<ColumnFormat></returns>
/// <history>
/// [erosado] 14/Mar/2016 Created
/// </history>
public static ColumnFormatList getExcelFormatTable()
{
ColumnFormatList formatColumns = new ColumnFormatList();
formatColumns.Add("GUID", "guID");
formatColumns.Add("Last Name", "guLastName1");
formatColumns.Add("First Name", "guFirstName1");
formatColumns.Add("LS", "guls");
formatColumns.Add("SR", "gusr");
formatColumns.Add("Agency ID", "guag");
formatColumns.Add("Agency", "agN");
formatColumns.Add("Market ID", "gumk");
formatColumns.Add("Market", "mkN");
formatColumns.Add("Ext", "External", format: EnumFormatTypeExcel.Boolean);
formatColumns.Add("Rbk", "Rebook", format: EnumFormatTypeExcel.Boolean);
formatColumns.Add("Check-In D", "guCheckInD", format: EnumFormatTypeExcel.Date);// date
formatColumns.Add("PR A", "guPRAssign");
formatColumns.Add("Avl", "guAvail", format: EnumFormatTypeExcel.Boolean);
formatColumns.Add("O.Avl", "guOriginAvail", format: EnumFormatTypeExcel.Boolean);
formatColumns.Add("Info D", "guInfo", format: EnumFormatTypeExcel.Boolean);
formatColumns.Add("guInfoD", "guInfoD", format: EnumFormatTypeExcel.Date);//date
formatColumns.Add("PR Info", "guPRInfo");
formatColumns.Add("PR Info Name", "PRInfoN");
formatColumns.Add("FU", "guFollow", format: EnumFormatTypeExcel.Boolean);
formatColumns.Add("Follow D", "guFollowD", format: EnumFormatTypeExcel.Date);//date
formatColumns.Add("PR Follow", "guPRFollow");
formatColumns.Add("PR Follow Name", "PRFollowN");
formatColumns.Add("Invit", "guInvit", format: EnumFormatTypeExcel.Boolean);
formatColumns.Add("Book D", "guBookD", format: EnumFormatTypeExcel.Date);//date
formatColumns.Add("PR", "guPRInvit1");
formatColumns.Add("PR Name", "PR1N");
formatColumns.Add("PR 2", "guPRInvit2");
formatColumns.Add("PR 2 Name", "PR2N");
formatColumns.Add("PR 3", "guPRInvit3");
formatColumns.Add("PR 3 Name", "PR3N");
formatColumns.Add("Qui", "guQuinella", format: EnumFormatTypeExcel.Boolean);
formatColumns.Add("Books", "guRoomsQty", format: EnumFormatTypeExcel.Number);
formatColumns.Add("SH", "guShow", format: EnumFormatTypeExcel.Boolean);
formatColumns.Add("Show D", "guShowD", format: EnumFormatTypeExcel.Date);//date
formatColumns.Add("Tour", "guTour", format: EnumFormatTypeExcel.Boolean);
formatColumns.Add("IO", "guInOut", format: EnumFormatTypeExcel.Boolean);
formatColumns.Add("WO", "guWalkOut", format: EnumFormatTypeExcel.Boolean);
formatColumns.Add("QS", "guQuinellaSplit", format: EnumFormatTypeExcel.Boolean);
formatColumns.Add("Shows", "guShowsQty", format: EnumFormatTypeExcel.Number);
formatColumns.Add("Sale", "guSale", format: EnumFormatTypeExcel.Boolean);
formatColumns.Add("Sales", "Sales", format: EnumFormatTypeExcel.Number);
formatColumns.Add("Amount", "SalesAmount", format: EnumFormatTypeExcel.Currency);
return(formatColumns);
}
/// <summary>
/// Formato para el reporte Up List Start o Up List End
/// </summary>
/// <returns> List of ColumnFormat</returns>
/// <history>
/// [edgrodriguez] 21/Jun/2016 Created
/// [edgrodriguez] 05/09/2016 Modified. Se cambio el formato.
/// </history>
public static ColumnFormatList RptUpList()
{
ColumnFormatList lst = new ColumnFormatList();
lst.Add("Post Name", "SalesmanPostN", isGroup: true, isVisible: false);
lst.Add("ID", "Salesman", axis: ePivotFieldAxis.Row);
lst.Add("Salesman Name", "SalesmanN", axis: ePivotFieldAxis.Row);
lst.Add("Off", "DayOffList", axis: ePivotFieldAxis.Row);
lst.Add("Lang", "Language", axis: ePivotFieldAxis.Values);
lst.Add("Location", "Location", axis: ePivotFieldAxis.Values);
lst.Add("Time", "Time", format: EnumFormatTypeExcel.Time, axis: ePivotFieldAxis.Values);
lst.Add("TimeN", "TimeN", format: EnumFormatTypeExcel.General, axis: ePivotFieldAxis.Column, sort: eSortType.Ascending);
lst.Add("Vol Ytd", "AmountYtd", format: EnumFormatTypeExcel.Currency, axis: ePivotFieldAxis.Row);
lst.Add("Vol Month", "AmountM", format: EnumFormatTypeExcel.Currency, axis: ePivotFieldAxis.Row);
lst.Add("Post", "SalesmanPost", isVisible: false);
return(lst);
}
/// <summary>
/// Formato para el reporte de Sales Log
/// </summary>
/// <history>
/// [jorcanche] created 03102016
/// </history>
public static ColumnFormatList RptSalesmenChanges()
{
ColumnFormatList lst = new ColumnFormatList();
lst.Add("Date / Time", "schDT", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Authorized By", "schAuthorizedBy", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Authorized By Name", "AuthorizedByN", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Made By", "schMadeBy", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Made By Name", "MadeByN", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Role", "roN", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Position", "schPosition", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Old Salesman", "schOldSalesman", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Old Salesman Name", "OldSalesmanN", aligment: ExcelHorizontalAlignment.Left);
lst.Add("New Salesman", "schNewSalesman", aligment: ExcelHorizontalAlignment.Left);
lst.Add("New Salesman Name", "NewSalesmanN", aligment: ExcelHorizontalAlignment.Left);
return(lst);
}
/// <summary>
/// Crea el formato para crear el reporte de Assistencias
/// </summary>
/// <history>
/// [ecanul] 13/09/2016 Created
/// </history>
private static ColumnFormatList RptAssistanceFormat()
{
ColumnFormatList format = new ColumnFormatList();
format.Add("Place Type", "asPlaceType");
format.Add("Place ID", "asPlaceID");
format.Add("Date Start", "asStartD", format: EnumFormatTypeExcel.Date);
format.Add("Date End", "asEndD", format: EnumFormatTypeExcel.Date);
format.Add("ID", "aspe");
format.Add("Name", "peN");
format.Add("Monday", "asMonday");
format.Add("Tuesday", "asTuesday");
format.Add("Wednesday", "asWednesday");
format.Add("Thursday", "asThursday");
format.Add("Friday", "asFriday");
format.Add("Saturday", "asSaturday");
format.Add("Sunday", "asSunday");
format.Add("#Assistence", "asNum");
return(format);
}
/// <summary>
/// Formato para el reporte de llegadas y asignacion
/// </summary>
/// <history>
/// [vku] 31/Mar/2016 Created
/// </history>
public static ColumnFormatList getExcelFormatTableGenAsignyArvls()
{
ColumnFormatList lst = new ColumnFormatList();
lst.Add("ID", "guID", format: EnumFormatTypeExcel.Id);
lst.Add("Check In D", "guCheckInD", format: EnumFormatTypeExcel.Date);
lst.Add("In", "guCheckIn", format: EnumFormatTypeExcel.Boolean);
lst.Add("Room", "guRoomNum", format: EnumFormatTypeExcel.Id);
lst.Add("Last Name", "guLastName1");
lst.Add("First Name", "guFirstName1");
lst.Add("PR ID", "guPRAssign");
lst.Add("PR N Assigned", "peN");
lst.Add("Agency ID", "guag", format: EnumFormatTypeExcel.Id);
lst.Add("Agency", "agN");
lst.Add("Member #", "guMemberShipNum");
lst.Add("Amount", "Gross");
lst.Add("PR", "PR");
lst.Add("Liner", "Liner");
lst.Add("Closer", "Closer");
return(lst);
}
/// <summary>
/// Formato para el reporte Deposit By PR
/// </summary>
/// <history>
/// [edgrodriguez] 19/Abr/2016 Created
/// [jorcanche] 19/ago/2016 modified se cambio de lugar de IM.ProcessorGeneral.Classes a IM.Base.Reports
/// [edgrodriguez] 05/Sep/2016 Modified. Se cambio el formato.
/// </history>
public static ColumnFormatList RptDepositByPr()
{
ColumnFormatList lst = new ColumnFormatList();
lst.Add("PR", "guPRInvit1", axis: ePivotFieldAxis.Row, isGroup: true, isVisible: false);
lst.Add("GUID", "guID", axis: ePivotFieldAxis.Row);
lst.Add("Out Invit", "guOutInvitNum", axis: ePivotFieldAxis.Row);
lst.Add("Guest", "Guest", axis: ePivotFieldAxis.Row);
lst.Add("Hotel", "guHotel", axis: ePivotFieldAxis.Row);
lst.Add("LS", "guls", axis: ePivotFieldAxis.Row);
lst.Add("SR", "gusr", axis: ePivotFieldAxis.Row);
lst.Add("Book Date", "guBookD", EnumFormatTypeExcel.Date, axis: ePivotFieldAxis.Row);
lst.Add("Deposited", "guDeposit", EnumFormatTypeExcel.Currency, axis: ePivotFieldAxis.Values, function: DataFieldFunctions.Sum);
lst.Add("Received", "guDepositReceived", EnumFormatTypeExcel.Currency, axis: ePivotFieldAxis.Values, function: DataFieldFunctions.Sum);
lst.Add("CxC", "CxC", EnumFormatTypeExcel.Currency, axis: ePivotFieldAxis.Values, isCalculated: true, formula: "[guDeposit]-[guDepositReceived]");
lst.Add("Currency", "gucu", axis: ePivotFieldAxis.Column, sort: eSortType.Ascending);
lst.Add("Payment Type", "gupt", axis: ePivotFieldAxis.Column, sort: eSortType.Descending);
lst.Add("guInvitD", "guInvitD", isVisible: false);
lst.Add("PR Name", "peN", isVisible: false);
return(lst);
}
/// <summary>
/// Genera las columnas que necesito en el reporte RPTStatistics
/// </summary>
/// <returns>List<ColumnFormat></returns>
/// <history>
/// [erosado] 14/Mar/2016 Created
/// </history>
public static ColumnFormatList getExcelFormatTable()
{
ColumnFormatList formatColumns = new ColumnFormatList();
formatColumns.Add("PR Id", "PR_ID");
formatColumns.Add("PR Name", "PR_NAME");
formatColumns.Add("PR Status", "P_Status", isGroup: true, isVisible: false);
formatColumns.Add("Assign", "Assign", format: EnumFormatTypeExcel.Number, function: DataFieldFunctions.Sum);
formatColumns.Add("Conts", "Conts", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum);
formatColumns.Add("C%", "C_Factor", format: EnumFormatTypeExcel.Percent, isCalculated: true, formula: "IF([Assign]=0,0,[Conts]/[Assign])");
formatColumns.Add("Avails", "Avails", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum);
formatColumns.Add("A%", "A_Factor", format: EnumFormatTypeExcel.Percent, isCalculated: true, formula: "IF([Conts]=0,0,[Avails]/[Conts])");
formatColumns.Add("Bk", "Bk", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum);
formatColumns.Add("Bk%", "Bk_Factor", format: EnumFormatTypeExcel.Percent, isCalculated: true, formula: "IF([Avails]=0,0,[T_Books]/[Avails])");
formatColumns.Add("TBooks", "T_Books", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum);
formatColumns.Add("Dep", "Dep", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum);
formatColumns.Add("Dir", "Dir", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum);
formatColumns.Add("Sh", "Sh", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum);
formatColumns.Add("IO", "IO", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum);
formatColumns.Add("Sh%", "Sh_Factor", format: EnumFormatTypeExcel.Percent, isCalculated: true, formula: "IF([Bk]=0,0,[TSh]/[Bk])");
formatColumns.Add("T Sh", "TSh", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum);
formatColumns.Add("SG", "SG", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum);
formatColumns.Add("Proc #", "Proc_Number", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum);
formatColumns.Add("Processable", "Processable", format: EnumFormatTypeExcel.Currency, isCalculated: true, formula: "[Total] - [Out_Pending]");
formatColumns.Add("Out Pending #", "OutP_Number", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum);
formatColumns.Add("Out Pending", "Out_Pending", format: EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum);
formatColumns.Add("C #", "C_Number", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum);
formatColumns.Add("Cancelled", "Cancelled", format: EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum);
formatColumns.Add("Total #", "Total_Number", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum);
formatColumns.Add("Total", "Total", format: EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum);
formatColumns.Add("Proc PR #", "Proc_PR_Number", isCalculated: true, formula: "[Proc_Number]-[Proc_SG_Number]");
formatColumns.Add("Proc PR", "Proc_PR", format: EnumFormatTypeExcel.Currency, isCalculated: true, formula: "[Total]-[Proc_SG]");
formatColumns.Add("Proc SG #", "Proc_SG_Number", function: DataFieldFunctions.Sum);
formatColumns.Add("Proc SG", "Proc_SG", format: EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum);
formatColumns.Add("Eff", "Eff", format: EnumFormatTypeExcel.DecimalNumber, isCalculated: true, formula: "IF([TSh]=0,0,[Total]/[TSh])");
formatColumns.Add("Cl %", "Cl_Factor", format: EnumFormatTypeExcel.Percent, isCalculated: true, formula: "IF([TSh]=0,0,[Proc_Number]/[TSh])");
formatColumns.Add("Ca %", "Ca_Factor", format: EnumFormatTypeExcel.Percent, isCalculated: true, formula: "IF([Total]=0,0,[Cancelled]/[Total])");
formatColumns.Add("Avg Sale", "Avg_Sale", format: EnumFormatTypeExcel.Currency, isCalculated: true, formula: "IF([Proc_Number]=0,0,[Total]/[Proc_Number])");
return(formatColumns);
}
/// <summary>
/// Formato para el excel de Personnel Log
/// </summary>
/// <returns> List of ColumnFormat</returns>
/// <history>
/// [emoguel] 17/10/2016 created
/// </history>
public static ColumnFormatList RptPersonnelLog()
{
ColumnFormatList lst = new ColumnFormatList();
lst.Add("Changed By", "plgChangedBy", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Changed By Name", "ChangedByN", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Update Date/Time", "plgDT", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Personnel", "plgpe", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Personnel Name", "peN", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Department", "plgde", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Department Name", "deN", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Post", "plgpo", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Post Name", "poN", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Sales Room", "plgsr", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Sales Room Name", "srN", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Location", "plglo", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Location Name", "loN", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Roles", "Roles", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Sales Rooms", "SalesRooms", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Lead Sources", "LeadSources", aligment: ExcelHorizontalAlignment.Left);
return(lst);
}
/// <summary>
/// Formato para el excel de GiftLog
/// </summary>
/// <returns> List of ColumnFormat</returns>
/// <history>
/// [emoguel] modified 06/07/2016
/// </history>
public static ColumnFormatList RptGiftLog()
{
ColumnFormatList lst = new ColumnFormatList();
lst.Add("Name", "ChangedByN", aligment: ExcelHorizontalAlignment.Left);
lst.Add("By", "ggChangedBy", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Update Date/Time", "ggID", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.DateTime);
lst.Add("Cost Adults", "ggPrice1", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.DecimalNumberWithCero);
lst.Add("Cost Minors", "ggPrice2", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.DecimalNumberWithCero);
lst.Add("CxC Adults", "ggPrice3", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.DecimalNumberWithCero);
lst.Add("CxC Minors", "ggPrice4", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.DecimalNumberWithCero);
lst.Add("Price Adults", "ggPriceAdults", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.DecimalNumberWithCero);
lst.Add("Price Minors", "ggPriceMinors", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.DecimalNumberWithCero);
lst.Add("P.E. Adults", "ggPriceExtraAdults", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.DecimalNumberWithCero);
lst.Add("Category", "gcN", aligment: ExcelHorizontalAlignment.Left);
lst.Add("Package", "ggPack", aligment: ExcelHorizontalAlignment.Center, format: EnumFormatTypeExcel.Boolean);
lst.Add("Inventory", "ggInven", aligment: ExcelHorizontalAlignment.Center, format: EnumFormatTypeExcel.Boolean);
lst.Add("Active", "ggA", aligment: ExcelHorizontalAlignment.Center, format: EnumFormatTypeExcel.Boolean);
lst.Add("With Folio", "ggWFolio", aligment: ExcelHorizontalAlignment.Center, format: EnumFormatTypeExcel.Boolean);
lst.Add("With Pax", "ggWPax", aligment: ExcelHorizontalAlignment.Center, format: EnumFormatTypeExcel.Boolean);
lst.Add("Order", "ggO", aligment: ExcelHorizontalAlignment.Left);
return(lst);
}
/// <summary>
/// Formato para el reporte de asignacion po PR
/// </summary>
/// <history>
/// [vku] 31/Mar/2016 Created
/// [vku] 20/Jul/2016 Modified. Elimine las columnas PR ID, PR N Assigned
/// Se corrigio el orden de las columnas
/// </history>
public static ColumnFormatList getExcelFormatTableAssignByPR()
{
ColumnFormatList lst = new ColumnFormatList();
lst.Add("In", "guCheckInD", format: EnumFormatTypeExcel.Date);
lst.Add("Out", "guCheckOutD", format: EnumFormatTypeExcel.Date);
lst.Add("Room", "guRoomNum", format: EnumFormatTypeExcel.Id);
lst.Add("Last Name", "guLastName1");
lst.Add("First Name", "guFirstName1");
lst.Add("Agency ID", "guag", format: EnumFormatTypeExcel.Id);
lst.Add("Agency", "agN");
lst.Add("Member #", "guMemberShipNum");
lst.Add("Pax", "guPax", format: EnumFormatTypeExcel.DecimalNumberWithCero);
lst.Add("Comments", "guComments");
lst.Add("Contract", "guO1");
lst.Add("Monday", "monday", format: EnumFormatTypeExcel.DecimalNumberWithCero);
lst.Add("Tuesday", "tuesday");
lst.Add("Wednesday", "wednesday");
lst.Add("Thursday", "thursday", format: EnumFormatTypeExcel.DecimalNumberWithCero);
lst.Add("Friday", "friday");
lst.Add("Saturday", "saturday");
lst.Add("Sunday", "sunday");
return(lst);
}
/// <summary>
/// Formato para el reporte Guest Manifest Range de Host y Processor General
/// </summary>
/// <param name="module">Modulo desde donde se genera el reporte</param>
/// <history>
/// [edgrodriguez] 13/Jun/2016 Created
/// [wtorres] 30/Sep/2016 Modified. Agregue el parametro module
/// </history>
public static ColumnFormatList RptManifestRangeByLs(EnumModule module)
{
//Hay columnas que no se deben desplegar en el manifiesto del modulo Host para ahorrar espacio
bool isVisible = (module == EnumModule.ProcessorGeneral);
ColumnFormatList lst = new ColumnFormatList();
lst.Add("Date", "DateManifest", EnumFormatTypeExcel.Date, isVisible: isVisible);
lst.Add("Group", "SaleTypeN", isGroup: true, isVisible: isVisible);
lst.Add("LocationN", "LocationN", isGroup: true, isVisible: false);
lst.Add("ShowProgram", "ShowProgramN", isGroup: true, isVisible: false);
lst.Add("SR", "SalesRoom", isVisible: isVisible);
lst.Add("LS", "LeadSource", isVisible: isVisible);
lst.Add("GUID", "guID", width: 7);
lst.Add("Last Name", "LastName", width: 12, wordWrap: true);
lst.Add("First Name", "FirstName", width: 12, wordWrap: true);
lst.Add("Country", "CountryD", width: 18, fontSize: 6, wordWrap: true);
lst.Add("Show D", "ShowD", EnumFormatTypeExcel.Date, isVisible: isVisible);
lst.Add("Hotel", "Hotel", width: 11, fontSize: 6, wordWrap: true);
lst.Add("Room", "Room", width: 8);
lst.Add("Agency", "AgencyN", fontSize: 6, wordWrap: true);
lst.Add("Pax", "Pax", EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum, width: 7);
lst.Add("In", "TimeInT", EnumFormatTypeExcel.Time, width: 8);
lst.Add("Out", "TimeOutT", EnumFormatTypeExcel.Time, width: 8);
lst.Add("Host", "Hostess", width: 6);
lst.Add("Sh", "Show", EnumFormatTypeExcel.Boolean, function: DataFieldFunctions.Count, width: 4);
lst.Add("Tour", "Tour", EnumFormatTypeExcel.Boolean, function: DataFieldFunctions.Count, width: 6);
lst.Add("IO", "IO", EnumFormatTypeExcel.Boolean, function: DataFieldFunctions.Count, width: 4);
lst.Add("WO", "WO", EnumFormatTypeExcel.Boolean, function: DataFieldFunctions.Count, width: 4);
lst.Add("CT", "CTour", EnumFormatTypeExcel.Boolean, function: DataFieldFunctions.Count, width: 4);
lst.Add("Sv", "STour", EnumFormatTypeExcel.Boolean, function: DataFieldFunctions.Count, width: 4);
lst.Add("D", "Direct", EnumFormatTypeExcel.Boolean, function: DataFieldFunctions.Count, width: 4);
lst.Add("R", "Resch", EnumFormatTypeExcel.Boolean, function: DataFieldFunctions.Count, width: 4);
lst.Add("N°", "PR1", width: 8);
lst.Add("PR/SG", "PR1N", fontSize: 6, wordWrap: true);
lst.Add("N°", "Liner1", width: 8);
lst.Add("Sales R.", "Liner1N", fontSize: 6, wordWrap: true);
lst.Add("N°", "Closer1", width: 8);
lst.Add("FM1", "Closer1N", fontSize: 6, wordWrap: true);
lst.Add("N°", "Closer2", width: 8);
lst.Add("FM2", "Closer2N", fontSize: 6, wordWrap: true);
lst.Add("N°", "Exit1", width: 8);
lst.Add("JRFM", "Exit1N", fontSize: 6, wordWrap: true);
lst.Add("Aff", "saMembershipNum", width: 7);
lst.Add("Sale", "ProcSales", EnumFormatTypeExcel.Number, function: DataFieldFunctions.Sum, width: 6);
lst.Add("Proc Orig", "ProcOriginal", EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum, width: 13);
lst.Add("Proc New", "ProcNew", EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum, width: 13);
lst.Add("Proc Gross", "ProcGross", EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum, width: 13);
lst.Add("Sale", "PendSales", EnumFormatTypeExcel.Number, function: DataFieldFunctions.Sum, width: 6);
lst.Add("Pend Original", "PendOriginal", EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum, width: 13);
lst.Add("Pend New", "PendNew", EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum, width: 13);
lst.Add("Pend Gross", "PendGross", EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum, width: 13);
lst.Add("$ DP", "saDownPayment", EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum, width: 13);
lst.Add("% DP", "saDownPaymentPercentage", EnumFormatTypeExcel.Percent, isCalculated: true, formula: "IF([ProcGross]=0,IF([PendGross]=0,0,[saDownPayment]/[PendGross]),[saDownPayment]/[ProcGross])", width: 6);
lst.Add("$ EDP", "saDownPaymentPaid", EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum, width: 13);
lst.Add("% EDP", "saDownPaymentPaidPercentage", EnumFormatTypeExcel.Percent, isCalculated: true, formula: "IF([ProcGross]=0,IF([PendGross]=0,0,[saDownPaymentPaid]/[PendGross]),[saDownPaymentPaid]/[ProcGross])", width: 7);
lst.Add("Deposit Sale", "DepositSale", EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum, width: 13);
lst.Add("Deposit #", "DepositSaleNum", width: 10);
lst.Add("CC", "CC", width: 5, fontSize: 6, wordWrap: true);
lst.Add("Comments", "Comments", width: 15, fontSize: 6, wordWrap: true);
lst.Add("SaleType", "SaleType", isVisible: false);
lst.Add("Location", "Location", isVisible: false);
lst.Add("Sequency", "Sequency", isVisible: false);
lst.Add("Agency ID", "Agency", isVisible: false);
lst.Add("Country ID", "Country", isVisible: false);
lst.Add("PR 2", "PR2", isVisible: false);
lst.Add("PR 2 Name", "PR2N", isVisible: false);
lst.Add("PR 3", "PR3", isVisible: false);
lst.Add("PR 3 Name", "PR3N", isVisible: false);
lst.Add("Liner 2", "Liner2", isVisible: false);
lst.Add("Liner 2 Name", "Liner2N", isVisible: false);
lst.Add("Closer 3", "Closer3", isVisible: false);
lst.Add("Closer 3 Name", "Closer3N", isVisible: false);
lst.Add("Exit 2", "Exit2", isVisible: false);
lst.Add("Exit 2 Name", "Exit2N", isVisible: false);
return(lst);
}
public async static void PremanifestToExcel(List <RptPremanifestOuthouse> lstpremanifest, Window window)
{
_filters = new List <Tuple <string, string> > {
Tuple.Create("Lead Source", Context.User.LeadSource.lsID)
};
var date = BRHelpers.GetServerDate();
if (lstpremanifest.Count > 0)
{
var premanifestAux = lstpremanifest.Select(c => new
{
c.srN,
c.guID,
c.guOutInvitNum,
c.Deposit,
c.guHotel,
c.guRoomNum,
c.guLastName1,
c.guFirstName1,
c.guco,
c.coN,
c.guBookD,
c.guBookT,
c.guPRInvit1,
guShow = c.guShow ? "✓" : "",
guSale = c.guSale ? "✓" : "",
c.guComments,
}).ToList();
var dt = TableHelper.GetDataTableFromList(premanifestAux, true);
_rptName = "Premanifest Outhouse " + Context.User.LeadSource.lsN;
var dateRange = DateHelper.DateRangeFileName(date, date);
var format = new ColumnFormatList();
format.Add("SR", "srN", isGroup: true, isVisible: false);
format.Add("Deposit", "Deposit", isGroup: true, isVisible: false);
format.Add("GUID", "guID");
format.Add("Out Invit", "guOutInvitNum");
format.Add("Hotel", "guHotel");
format.Add("Room", "guRoomNum");
format.Add("Last Name", "guLastName1");
format.Add("Firs tName", "guFirstName1");
format.Add("Country ID", "guco");
format.Add("Country", "coN");
format.Add("Book D", "guBookD", format: EnumFormatTypeExcel.Date);
format.Add("Book T", "guBookT", format: EnumFormatTypeExcel.Time);
format.Add("PR B", "guPRInvit1");
format.Add("Sh", "guShow", axis: ePivotFieldAxis.Values, aligment: ExcelHorizontalAlignment.Center, function: DataFieldFunctions.Count);
format.Add("Sale", "guSale", axis: ePivotFieldAxis.Values, aligment: ExcelHorizontalAlignment.Center, function: DataFieldFunctions.Count);
format.Add("Deposits / Comments", "guComments");
var info = await ReportBuilder.CreateCustomExcelAsync(dt, _filters, _rptName, dateRange, format, blnShowSubtotal : true, blnRowGrandTotal : true, addEnumeration : true);
if (info != null)
{
frmDocumentViewer documentViewer = new frmDocumentViewer(info, Context.User.HasPermission(EnumPermission.RptExcel, EnumPermisionLevel.ReadOnly), false);
documentViewer.Owner = window;
documentViewer.ShowDialog();
}
}
}
/// <summary>
/// Formato para el reporte de Guest Log
/// </summary>
/// <history>
/// [jorcanche] created 07072016
/// [emoguel] 08/10/2016 Modified--->Se agregaron las columnas para Liner3,Closer4, Exit 3, Front To back 1 y 2, Front To Middle 1 y 2
/// </history>
public static ColumnFormatList RptGuestLog()
{
ColumnFormatList lst = new ColumnFormatList();
lst.Add("By", "glChangedBy");
lst.Add("Name", "ChangedByN");
lst.Add("Update Date/Time", "glID", EnumFormatTypeExcel.DateTime);
lst.Add("SR", "glsr");
lst.Add("Last Name", "glLastName1");
lst.Add("First Name", "glFirstName1");
lst.Add("Last Name 2", "glLastName2");
lst.Add("First Name 2", "glFirstName2");
lst.Add("Reserv. #", "glHReservID");
lst.Add("Avl Sys", "glAvailBySystem");
lst.Add("Orig Avl", "glOriginAvail");
lst.Add("Avl", "glAvail");
lst.Add("Unavailable Motive", "umN");
lst.Add("PR Avail", "glPRAvail");
lst.Add("PR Avail Name", "PRAvailN");
lst.Add("Info D", "glInfoD", EnumFormatTypeExcel.Date);
lst.Add("PR Info", "glPRInfo");
lst.Add("PR Info Name", "PRInfoN");
lst.Add("Follow D", "glFollowD", EnumFormatTypeExcel.Date);
lst.Add("PR Follow", "glPRFollow");
lst.Add("PR Follow Name", "PRFollowN");
lst.Add("Book D", "glBookD", EnumFormatTypeExcel.Date);
lst.Add("Book T", "glBookT", EnumFormatTypeExcel.Time);
lst.Add("Resch D", "glReschD", EnumFormatTypeExcel.Date);
lst.Add("Resch T", "glReschT", EnumFormatTypeExcel.Time);
lst.Add("PR B", "glPRInvit1");
lst.Add("PR Booking Name", "PRInvit1N");
lst.Add("PR B 2", "glPRInvit2");
lst.Add("PR Booking 2 Name", "PRInvit2N");
lst.Add("C.Bk", "glBookCanc");
lst.Add("Liner 1", "glLiner1");
lst.Add("Liner 1 Name", "Liner1N");
lst.Add("Liner 2", "glLiner2");
lst.Add("Liner 2 Name", "Liner2N");
lst.Add("Liner 3", "glLiner3");
lst.Add("Liner 3 Name", "Liner3N");
lst.Add("Front To Middle 1", "glFTM1");
lst.Add("Frint To Middle 1 Name", "FTM1N");
lst.Add("Front To Middle 2", "glFTM2");
lst.Add("Frint To Middle 2 Name", "FTM2N");
lst.Add("Front To Back 1", "glFTB1");
lst.Add("Frint To Back 1 Name", "FTB1N");
lst.Add("Front To Back 2", "glFTB2");
lst.Add("Frint To Back 2 Name", "FTB2N");
lst.Add("Closer 1", "glCloser1");
lst.Add("Closer 1 Name", "Closer1N");
lst.Add("Closer 2", "glCloser2");
lst.Add("Closer 2 Name", "Closer2N");
lst.Add("Closer 3'", "glCloser3");
lst.Add("Closer 3 Name", "Closer3N");
lst.Add("Closer 4'", "glCloser4");
lst.Add("Closer 4 Name", "Closer4N");
lst.Add("Exit1", "glExit1");
lst.Add("Exit 1 Name", "Exit1N");
lst.Add("Exit2", "glExit2");
lst.Add("Exit 2 Name", "Exit2N");
lst.Add("Exit 3", "glExit3");
lst.Add("Exit 3 Name", "Exit3N");
lst.Add("Podium", "glPodium");
lst.Add("Podium Name", "PodiumN");
lst.Add("VLO", "glVLO");
lst.Add("VLO Name", "VLON");
lst.Add("Sh", "glShow");
lst.Add("Show D", "glShowD", EnumFormatTypeExcel.Date);
lst.Add("Q", "glQ");
lst.Add("IO", "glInOut");
lst.Add("WO", "glWalkOut");
lst.Add("CT", "glCTour");
lst.Add("Re-Printed", "glReimpresion");
lst.Add("Re-Print Motive", "rmN");
return(lst);
}
/// <summary>
/// Formato para el reporte de Sales Log
/// </summary>
/// <history>
/// [jorcanche] created 07072016
/// </history>
public static ColumnFormatList RptSaleLog()
{
ColumnFormatList lst = new ColumnFormatList();
lst.Add("By", "slChangedBy");
lst.Add("Name", "ChangedByN");
lst.Add("Update Date/Time", "slID", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.DateTime);
lst.Add("GUID", "slgu");
lst.Add("Guest Name", "GuestName");
lst.Add("Sale D", "slD", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.Date);
lst.Add("Proc D", "slProcD", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.Date);
lst.Add("Cancel D", "slCancelD", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.Date);
lst.Add("Member #", "slMembershipNum");
lst.Add("Sale Type", "stN");
lst.Add("Reference", "slReference");
lst.Add("M Type', 'Membership Type", "mtN");
lst.Add("O Amount", "slOriginalAmount", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.Currency);
lst.Add("N Amount", "slNewAmount", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.Currency);
lst.Add("G Amount", "slGrossAmount", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.Currency);
lst.Add("Loc", "sllo");
lst.Add("LS", "slls");
lst.Add("SR", "slsr");
lst.Add("SG", "slSelfGen");
lst.Add("PR 1", "slPR1");
lst.Add("PR Name", "PR1N");
lst.Add("PR 2", "slPR2");
lst.Add("PR 2 Name", "PR2N");
lst.Add("PR 3", "slPR3");
lst.Add("PR 3 Name", "PR3N");
lst.Add("Liner1 T", "slLiner1Type");
lst.Add("Liner 1", "slLiner1");
lst.Add("Liner 1 Name", "Liner1N");
lst.Add("Liner 2", "slLiner2");
lst.Add("Liner 2 Name", "Liner2N");
lst.Add("Liner 3", "slLiner3");
lst.Add("Liner 3 Name", "Liner3N");
lst.Add("FTM1", "slFTM1");
lst.Add("FTM1 Name", "FTM1N");
lst.Add("FTM2", "slFTM2");
lst.Add("FTM2 Name", "FTM2N");
lst.Add("FTB1", "slFTB1");
lst.Add("FTB1 Name", "FTB1N");
lst.Add("FTB2", "slFTB2");
lst.Add("FTB2 Name", "FTB2N");
lst.Add("Closer 1", "slCloser1");
lst.Add("Closer 1 Name", "Closer1N");
lst.Add("Closer 2", "slCloser2");
lst.Add("Closer 2 Name", "Closer2N");
lst.Add("Closer 3", "slCloser3");
lst.Add("Closer 3 Name", "Closer3N");
lst.Add("Closer 4", "slCloser4");
lst.Add("Closer 4 Name", "Closer4N");
lst.Add("Exit 1", "slExit1");
lst.Add("Exit 1 Name", "Exit1N");
lst.Add("Exit 2", "slExit2");
lst.Add("Exit 2 Name", "Exit2N");
lst.Add("Exit 3", "slExit3");
lst.Add("Exit 3 Name", "Exit3N");
lst.Add("Podium", "slPodium");
lst.Add("Podium Name", "PodiumN");
lst.Add("VLO", "slVLO");
lst.Add("VLO Name", "VLON");
lst.Add("PR Cptn", "slPRCaptain1");
lst.Add("PR Captain Name", "PR1CaptainN");
lst.Add("PR Cptn 2", "slPRCaptain2");
lst.Add("PR Captain 2 Name", "PR2CaptainN");
lst.Add("Liner Cptn", "slLinerCaptain1");
lst.Add("Liner Captain Name", "LinerCaptainN");
lst.Add("Closer Cptn", "slCloserCaptain1");
lst.Add("Closer Captain Name", "CloserCaptainN");
lst.Add("CL1 %", "slCloser1P");
lst.Add("CL2 %", "slCloser2P");
lst.Add("CL3 %", "slCloser3P");
lst.Add("Exit1 %", "slExit1P");
lst.Add("Exit2 %", "slExit2P");
lst.Add("C. Cost", "slClosingCost");
lst.Add("O. Pack", "slOverPack");
return(lst);
}
