public IEnumerable <PurchaseSalesReportOfMEModel> GetPurchaseSalesReportOfME(PurchaseSalesReportOfMEModel model)
{
var Data = entity.Air_GetPurchseSalesOfMEs(model.MEsNameID, model.FromDate, model.ToDate, model.CurrencyID);
List <PurchaseSalesReportOfMEModel> collection = new List <PurchaseSalesReportOfMEModel>();
double PurchaseTotal = 0;
double SalesTotal = 0;
double RecieptTotal = 0;
foreach (var item in Data)
{
PurchaseSalesReportOfMEModel single = new PurchaseSalesReportOfMEModel()
{
AgentName = item.AgentName,
Purchase = item.Pruchase,
Sales = item.Sales,
Receipt = item.Receipt
};
collection.Add(single);
PurchaseTotal += item.Pruchase ?? 0;
SalesTotal += item.Sales ?? 0;
RecieptTotal += item.Receipt;
}
PurchaseSalesReportOfMEModel add = new PurchaseSalesReportOfMEModel();
add.Purchase = PurchaseTotal;
add.Sales = SalesTotal;
add.Receipt = RecieptTotal;
collection.Add(add);
return(collection);
}
public ActionResult Index(ExportModel Expmodel, FormCollection frm, PurchaseSalesReportOfMEModel model)
{
model.PurchaseSalesReportOfMElist = PurchaseSalesReportOfMERepository.GetPurchaseSalesReportOfME(model);
ctrlBKT.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;
}
var count = 1;
var exportData = model.PurchaseSalesReportOfMElist.Select(m => new
{
SNo = count++,
Agent_Name = m.AgentName,
Purchase = m.Purchase,
Sales = m.Sales,
Receipt = m.Receipt
});
App_Class.AppCollection.Export(Expmodel, exportData, "Purchase Sales Report Of ME's");
}
catch (Exception ex)
{
TempData["ActionResponse"] = ex.Message;
}
}
model.MENameList = PurchaseSalesReportOfMERepository.GetMEName();
model.CurrencyList = PurchaseSalesReportOfMERepository.GetCurrency();
return(View(model));
}
public ActionResult Index()
{
TravelSession obj = (TravelSession)Session["TravelPortalSessionInfo"];
PurchaseSalesReportOfMEModel model = new PurchaseSalesReportOfMEModel();
model.AppUserId = obj.AppUserId;
model.UserTypeId = obj.UserTypeId;
if (obj.UserTypeId == 4)
{
model.MENameList = PurchaseSalesReportOfMERepository.GetMENameOnly(model.AppUserId, model.UserTypeId);
}
else
{
model.MENameList = PurchaseSalesReportOfMERepository.GetMEName();
}
model.CurrencyList = PurchaseSalesReportOfMERepository.GetCurrency();
return(View(model));
}
