public ActionResult getUserList(int reportPeriodId, int customerId, int projectId)
{
CReportPeriod crp = new CReportPeriod();
List <CUser> userList = crp.getUserListForReportPeriod(reportPeriodId, customerId, projectId);
SelectList sl = new SelectList(userList, "userId", "userName");
ViewBag.userlist = sl;
return(PartialView("getUserList"));
}
public ActionResult getCustList(int reportPeriodId)
{
CReportPeriod crp = new CReportPeriod();
List <CCustomer> custList = crp.getCustListForReportPeriod(reportPeriodId);
SelectList sl = new SelectList(custList, "customerID", "custName");
ViewBag.custList = sl;
return(PartialView("getCustList"));
}
public ActionResult getProjectList(int reportPeriodId, int customerId)
{
CReportPeriod crp = new CReportPeriod();
List <CProject> projList = crp.getProjListForReportPeriod(reportPeriodId, customerId);
SelectList sl = new SelectList(projList, "projectID", "projectName");
ViewBag.projlist = sl;
return(PartialView("getProjectList"));
}
public ActionResult reportProperties()
{
CReportPeriod crp = new CReportPeriod();
List <CReportPeriod> periodList = crp.getReportPeriods();
SelectList sl = new SelectList(periodList, "reportPeriodId", "reportPeriodDescr");
ViewBag.periodList = sl;
return(View());
}
public ActionResult getReportPeriodHours(int periodId, int customerId, int projectId, int datePeriod, int showActivity, int userId)
{
CReportPeriod crp = new CReportPeriod();
string error = "";
List <CReportPeriodHours> repHours = crp.getReportPeriodHours(periodId, customerId, projectId, datePeriod == 1, showActivity == 1, userId, ref error);
CReportPeriodHours rh = repHours.FirstOrDefault(x => x.projectName == "Summa timmar");
ViewBag.sumHours = rh.hours.ToString();
repHours.Remove(rh);
ViewBag.datePeriod = datePeriod;
ViewBag.showActivity = showActivity;
return(PartialView("getReportPeriodHours", repHours));
}
// GET: Report
public ActionResult Index()
{
CReportPeriod crp = new CReportPeriod();
CDateParameters cdp = new CDateParameters();
cdp.dFrom = crp.getFirstReportDate();
cdp.dTo = crp.getLastReportDate();
if (cdp.dFrom > cdp.dTo)
{
cdp.dFrom = cdp.dTo;
}
ViewBag.dFromStr = cdp.dFrom.ToShortDateString();
return(View(cdp));
}
public JsonResult getReportPeridHoursPDF(int periodId, int customerId, int projectId, int datePeriod, int showActivity, int userId)
{
string errStr = "";
CReportPeriod crp = new CReportPeriod();
string path = Server.MapPath("~/pdf");
path += "\\" + periodId.ToString() + ".pdf";
string relativePath = crp.generatePDFReport(path, periodId, customerId, projectId, datePeriod, showActivity, userId, ref errStr);
//return File(path, "application/pdf");
return(Json(new
{
relativePath,
errStr
}, JsonRequestBehavior.AllowGet));
}
public ActionResult reportInterval()
{
pdsTidRedLiveEntities db = new pdsTidRedLiveEntities();
ViewBag.dFrom = DateTime.Today;
ViewBag.dTo = DateTime.Today.AddDays(-30);
List <customer> custList = db.customer.Where(x => x.active == true).OrderBy(x => x.custName).ToList();
ViewBag.custList = new SelectList(custList, "customerID", "custName");
List <userTbl> userList = db.userTbl.OrderBy(x => x.userName).ToList();
ViewBag.userList = new SelectList(userList, "userId", "userName");
CReportPeriod crp = new CReportPeriod();
List <CReportPeriod> periodList = crp.getReportPeriods();
SelectList sl = new SelectList(periodList, "reportPeriodId", "reportPeriodDescr");
ViewBag.periodList = sl;
return(View());
}
public JsonResult createReportPeriod(DateTime dFrom, DateTime dTo)
{
string errMess = "";
int cnt = 0;
try
{
CReportPeriod crp = new CReportPeriod();
int userId = Convert.ToInt32(Session["userId"]);
cnt = crp.createReportPeriod(dFrom, dTo, userId);
}
catch (Exception ex)
{
errMess = ex.Message;
}
return(Json(new
{
errMess,
cnt
}, JsonRequestBehavior.AllowGet));
}
