public ActionResult Index()
{
LedgerTransactionSummaryModel model = new LedgerTransactionSummaryModel();
var ts = SessionStore.GetTravelSession();
model.DateFrom = DateTime.Now.AddDays(-15);
model.DateTo = DateTime.Now;
model.ProductsOption = ledgerTransactionSummaryProvider.GetProductOption();
model.CurrencyOption = ledgerTransactionSummaryProvider.GetCurrencyOption();
model.LedgerOfOption = ledgerTransactionSummaryProvider.GetLedgerOfOption();
model.FilterTypeOption = ledgerTransactionSummaryProvider.GerFilterTypeoption();
return(View(model));
}
public List <LedgerTransactionSummaryModel> GetSummeryOfLedgerTransactionList(int?ProductId, int CurrencyId, int Type, DateTime DateFrom, DateTime DateTo, int?FilterType, float FilterValue)
{
var Data = entity.GL_GetSummeryOfLedgerTransaction(ProductId, CurrencyId, Type, DateFrom, DateTo, FilterType, FilterValue);
List <LedgerTransactionSummaryModel> Listcollection = new List <LedgerTransactionSummaryModel>();
foreach (var item in Data)
{
LedgerTransactionSummaryModel singleone = new LedgerTransactionSummaryModel()
{
ClosingBalance = item.ClosingBalance,
Cr = item.Cr,
Dr = item.Dr,
LedgerId = item.LedgerId,
LedgerName = item.LedgerName,
OpeningBalance = item.OpeningBalance
};
Listcollection.Add(singleone);
}
return(Listcollection);
}
public ActionResult Index(ATLTravelPortal.Areas.Airline.Models.ExportModel Expmodel, LedgerTransactionSummaryModel model, FormCollection frm)
{
model.LedgerTransactionList = ledgerTransactionSummaryProvider.GetSummeryOfLedgerTransactionList(model.ProductId, model.CurrencyId, model.LedgerOf, model.DateFrom, model.DateTo, model.FilterType, model.FilterValue);
BookedTicketReportController crtBKT = new BookedTicketReportController();
crtBKT.GetExportTypeClicked(Expmodel, frm);
if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null))
{
try
{
if (Expmodel.ExportTypeExcel != null)
{
Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel;
}
else if (Expmodel.ExportTypeWord != null)
{
Expmodel.ExportTypeWord = Expmodel.ExportTypeWord;
}
else if (Expmodel.ExportTypePdf != null)
{
Expmodel.ExportTypePdf = Expmodel.ExportTypePdf;
}
int counter = 1;
var exportData = model.LedgerTransactionList.Select(m => new
{
SN = counter++,
Ledger_Id = m.LedgerId,
Ledger_Name = m.LedgerName,
Opening_Balance = m.OpeningBalance,
Dr = m.Dr,
Cr = m.Cr,
Closing_Balance = m.ClosingBalance
});
App_Class.AppCollection.Export(Expmodel, exportData, "Ledger Transaction");
}
catch
{
}
}
model.ProductsOption = ledgerTransactionSummaryProvider.GetProductOption();
model.CurrencyOption = ledgerTransactionSummaryProvider.GetCurrencyOption();
model.LedgerOfOption = ledgerTransactionSummaryProvider.GetLedgerOfOption();
model.FilterTypeOption = ledgerTransactionSummaryProvider.GerFilterTypeoption();
return(View(model));
}