public ActionResult HipVsNoHopDetails(string branchCode, double date, string day = "7")
{
var reportDate = DateTime.FromOADate(date);
ViewBag.Branches = m_enttContext.GetBranchInfo(branchCode).Select(w => new SelectListItem {
Text = w.Name, Value = w.Code
});
ViewBag.ReportDays = ApplicationHelper.GetReportDays().Select(w => new SelectListItem {
Text = w.Value, Value = w.Key.ToString()
});
var reportViewer = ReportEngine.Create();
var dataset = m_enttContext.GetHipVsNoHopDetailsReportDataSet(reportDate.Date, int.Parse(day), branchCode);
reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\Versus\HipVsNoHopDetails.rdlc";
var parameters = new List <ReportParameter>
{
new ReportParameter("reportDate", reportDate.ToShortDateString()),
new ReportParameter("day", day),
new ReportParameter("branchCode", branchCode)
};
reportViewer.LocalReport.EnableHyperlinks = true;
reportViewer.LocalReport.SetParameters(parameters);
reportViewer.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dataset.Tables[0]));
ViewBag.TotalRows = dataset.Tables[0].Rows.Count;
ViewBag.ReportViewer = reportViewer;
var model = new PrefixReportViewModel {
ReportDate = reportDate, ReportDay = day, SelectedBranch = branchCode
};
return(View(model));
}
public ActionResult NoAcceptanceDetailsReport(string branchCode, double date)
{
var reportDate = DateTime.FromOADate(date);
ViewBag.Branches = m_enttContext.GetBranchInfo(branchCode).Select(w => new SelectListItem {
Text = w.Name, Value = w.Code
});
var reportViewer = ReportEngine.Create();
var dataset = m_enttContext.NoAcceptanceDetailsReportDataSet(reportDate.Date, branchCode);
reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\Versus\NoAcceptanceDetails.rdlc";
var parameters = new List <ReportParameter>
{
new ReportParameter("reportDate", reportDate.ToShortDateString()),
new ReportParameter("branchCode", branchCode)
};
reportViewer.LocalReport.SetParameters(parameters);
reportViewer.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dataset.Tables[0]));
ViewBag.TotalRows = dataset.Tables[0].Rows.Count;
ViewBag.ReportViewer = reportViewer;
var model = new PrefixReportViewModel {
ReportDate = reportDate, SelectedBranch = branchCode
};
return(View(model));
}
public ActionResult HipVsHop(PrefixReportViewModel model)
{
var reportViewer = ReportEngine.Create();
if (ModelState.IsValid)
{
var day = int.Parse(model.ReportDay);
DataSet dataset;
dataset = model.SelectedBranch == "All" ?
m_enttContext.GetHipVsHopReportDataSet(model.ReportDate, day) :
m_enttContext.GetHipVsHopBranchReportDataSet(model.ReportDate, day, model.SelectedBranch);
reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\Versus\HipVsHop.rdlc";
var parameters = new List <ReportParameter>
{
new ReportParameter("reportDate", model.ReportDate.ToShortDateString()),
new ReportParameter("day", model.ReportDay)
};
reportViewer.LocalReport.EnableHyperlinks = true;
reportViewer.LocalReport.SetParameters(parameters);
reportViewer.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dataset.Tables[0]));
}
ViewBag.ReportViewer = reportViewer;
ViewBag.Branches = GetUserViewBranches().Select(w => new SelectListItem {
Text = w.Name, Value = w.Code
});
ViewBag.ReportDays = ApplicationHelper.GetReportDays().Select(w => new SelectListItem {
Text = w.Value, Value = w.Key.ToString()
});
return(View(model));
}
public ActionResult HipVsHop()
{
var reportViewer = ReportEngine.Create();
ViewBag.Branches = GetUserViewBranches().Select(w => new SelectListItem {
Text = w.Name, Value = w.Code
});
ViewBag.ReportViewer = reportViewer;
ViewBag.ReportDays = ApplicationHelper.GetReportDays().Select(w => new SelectListItem {
Text = w.Value, Value = w.Key.ToString()
});
var model = new PrefixReportViewModel {
ReportDate = DateTime.Today, ReportDay = 7.ToString()
};
return(View(model));
}
public ActionResult SopVsSipDetails(string branchCode, double date, string day = "7")
{
var user = m_dbContext.Users.Single(u => u.UserName == User.Identity.Name);
if (null != user && !string.IsNullOrEmpty(user.BranchCode) && user.BranchCode != branchCode)
{
if (!User.IsInRole("VersusHQ"))
{
return(new HttpStatusCodeResult(403, "You are not allow to view the data"));
}
}
var reportDate = DateTime.FromOADate(date);
ViewBag.Branches = m_enttContext.GetBranchInfo(branchCode).Select(w => new SelectListItem {
Text = w.Name, Value = w.Code
});
ViewBag.ReportDays = ApplicationHelper.GetReportDays().Select(w => new SelectListItem {
Text = w.Value, Value = w.Key.ToString()
});
var reportViewer = ReportEngine.Create();
var dataset = m_enttContext.GetSopVsSipDetailsReportDataSet(reportDate.Date, int.Parse(day), branchCode);
reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\Versus\SopVsSipDetails.rdlc";
var parameters = new List <ReportParameter>
{
new ReportParameter("reportDate", reportDate.ToShortDateString()),
new ReportParameter("day", day),
new ReportParameter("branchCode", branchCode)
};
reportViewer.LocalReport.EnableHyperlinks = true;
reportViewer.LocalReport.SetParameters(parameters);
reportViewer.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dataset.Tables[0]));
ViewBag.TotalRows = dataset.Tables[0].Rows.Count;
ViewBag.ReportViewer = reportViewer;
var model = new PrefixReportViewModel {
ReportDate = reportDate, ReportDay = day, SelectedBranch = branchCode
};
return(View(model));
}
public ActionResult DeliveryExceptionReport(PrefixReportViewModel model)
{
var reportViewer = new ReportViewer()
{
KeepSessionAlive = false,
ProcessingMode = ProcessingMode.Local,
SizeToReportContent = true,
Width = Unit.Percentage(100),
Height = Unit.Percentage(100)
};
if (ModelState.IsValid)
{
var day = int.Parse(model.ReportDay);
DataSet dataset;
dataset = model.SelectedBranch == "All" ?
m_enttContext.GetDeliveryExceptionReportDataSet(model.ReportDate, day) :
m_enttContext.GetDeliveryExceptionBranchReportDataSet(model.ReportDate, day, model.SelectedBranch);
reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\Versus\DeliveryExceptionVsPod.rdlc";
var parameters = new List <ReportParameter>
{
new ReportParameter("reportDate", model.ReportDate.ToShortDateString()),
new ReportParameter("day", model.ReportDay)
};
reportViewer.LocalReport.EnableHyperlinks = true;
reportViewer.LocalReport.SetParameters(parameters);
reportViewer.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dataset.Tables[0]));
}
ViewBag.ReportViewer = reportViewer;
ViewBag.ReportDays = ApplicationHelper.GetReportDays().Select(w => new SelectListItem {
Text = w.Value, Value = w.Key.ToString()
});
ViewBag.Branches = GetUserViewBranches().Select(w => new SelectListItem {
Text = w.Name, Value = w.Code
});
return(View(model));
}
public ActionResult DeliveryExceptionReport()
{
var reportViewer = new ReportViewer()
{
KeepSessionAlive = false,
ProcessingMode = ProcessingMode.Local,
SizeToReportContent = true,
Width = Unit.Percentage(100),
Height = Unit.Percentage(100)
};
ViewBag.ReportViewer = reportViewer;
ViewBag.ReportDays = ApplicationHelper.GetReportDays().Select(w => new SelectListItem {
Text = w.Value, Value = w.Key.ToString()
});
ViewBag.Branches = GetUserViewBranches().Select(w => new SelectListItem {
Text = w.Name, Value = w.Code
});
var model = new PrefixReportViewModel {
ReportDate = DateTime.Today, ReportDay = 7.ToString()
};
return(View(model));
}
public ActionResult IoExceptionVsNoPackageDetails(string branchCode, double date, string day = "7")
{
var reportDate = DateTime.FromOADate(date);
ViewBag.Branches = m_enttContext.GetBranchInfo(branchCode).Select(w => new SelectListItem {
Text = w.Name, Value = w.Code
});
ViewBag.ReportDays = ApplicationHelper.GetReportDays().Select(w => new SelectListItem {
Text = w.Value, Value = w.Key.ToString()
});
var reportViewer = ReportEngine.Create();
//
//TODO: queries
reportViewer.LocalReport.EnableHyperlinks = true;
ViewBag.ReportViewer = reportViewer;
var model = new PrefixReportViewModel {
ReportDate = reportDate, ReportDay = day, SelectedBranch = branchCode
};
return(View(model));
}
