public ActionResult OceanExport()
{
CheckAccess();
OceanReportMasterModel model = new OceanReportMasterModel();
bool forwardToPrint = false;
string TypeName = "";
foreach (string typeName in GridViewExportHelper.ExportTypes.Keys)
{
if (Request.Params[typeName] != null)
{
TypeName = typeName;
forwardToPrint = true;
}
}
if (forwardToPrint)
{
return(RedirectToAction("ExportTo", new { Operation = "OceanExport", typeName = TypeName }));
}
if (Request["PeriodBegin"] == null || Request["ReSelect"] != null)
{
Session["OceanExportMasterReportData"] = null;
ViewBag.IsSelected = false;
}
else
{
ReportSelection ReportSelection = new ReportSelection();
CultureInfo ci = new CultureInfo("en-US");
ReportSelection.PeriodBegin = Convert.ToDateTime(Request["PeriodBegin"], ci);
ReportSelection.PeriodEnd = Convert.ToDateTime(Request["PeriodEnd"], ci);
ReportSelection.CategorizeBy = Convert.ToString(Request["CategorizeBy"]);
ReportSelection.WeightScale = Convert.ToString(Request["WeightScale"]);
ReportSelection.AnalysisOn = Convert.ToString(Request["chkAnalysisOn"]);
Session["OceanExportReportSelection"] = ReportSelection;
model = GetOceanExportMasterModel();
model.PeriodBegin = ReportSelection.PeriodBegin;
model.PeriodEnd = ReportSelection.PeriodEnd;
model.CategorizeBy = ReportSelection.CategorizeBy;
model.WeightScale = ReportSelection.WeightScale;
model.AnalysisOn = ReportSelection.AnalysisOn;
ViewBag.IsSelected = true;
}
return(View(model));
}
private AirReportMasterModel GetAirExportMasterModel()
{
ReportSelection selection = (ReportSelection)Session["AirExportReportSelection"];
string KeyFieldName = selection.CategorizeBy;
Session["KeyFieldName"] = selection.CategorizeBy;
AirReportMasterModel model = new AirReportMasterModel()
{
KeyFieldName = KeyFieldName
};
var data = GetAirExportTransactionalData();
if (KeyFieldName == "Agent")
{
model.Elements = data.GroupBy(d => d.Agent).Select(grp => grp.First()).ToList();
}
if (KeyFieldName == "Shipper")
{
model.Elements = data.GroupBy(d => d.Shipper).Select(grp => grp.First()).ToList();
}
if (KeyFieldName == "Carrier")
{
model.Elements = data.GroupBy(d => d.Carrier).Select(grp => grp.First()).ToList();
}
if (KeyFieldName == "Consignee")
{
model.Elements = data.GroupBy(d => d.Consignee).Select(grp => grp.First()).ToList();
}
if (KeyFieldName == "Origin")
{
model.Elements = data.GroupBy(d => d.Origin).Select(grp => grp.First()).ToList();
}
if (KeyFieldName == "Destination")
{
model.Elements = data.GroupBy(d => d.Destination).Select(grp => grp.First()).ToList();
}
if (KeyFieldName == "Sale_Rep")
{
model.Elements = data.GroupBy(d => d.Sale_Rep).Select(grp => grp.First()).ToList();
}
return(model);
}
private List <OceanTransactionItem> GetOceanExportTransactionalData()
{
ReportSelection selection = (ReportSelection)Session["OceanExportReportSelection"];
ELT.BL.ReportingBL ReportBL = new ReportingBL();
if (Session["OceanExportMasterReportData"] == null)
{
var user = GetCurrentELTUser();
string ELT_account_number = user.elt_account_number;
if (ELT_account_number == null)
{
Response.Redirect("~/Account/Login", true);
}
Session["OceanExportMasterReportData"]
= ReportBL.GetOceanExportTransItems(ELT_account_number, selection);
}
var model = (List <OceanTransactionItem>)Session["OceanExportMasterReportData"];
return(model);
}
