public ActionResult Download(int[] reportID)
{
csvdata = "Title;Added;Modified;State;Assigned to;Number of activities\n";
List<IssueViewModel> issueViewModels = new List<IssueViewModel>();
int al = reportID.Length;
for (int i = 0; i < al; i++)
{
var view = new IssueViewModel
{
cissue = db.Issues.Find(reportID[i]),
cactivities = db.Activities.SqlQuery("SELECT * FROM Activity WHERE IssueID='" + reportID[i] + "'")
};
issueViewModels.Add(view);
}
foreach (IssueViewModel item in issueViewModels)
{
csvdata = csvdata + item.cissue.Title + ";" + item.cissue.Added + ";" + item.cissue.Modiefied + ";" + item.cissue.State + ";" + item.cissue.Employee + ";" + item.cactivities.Count() + "\n";
}
var data = Encoding.UTF8.GetBytes(csvdata);
string filename = "reports"+DateTime.Today.ToString("dd-MM-yy")+".csv";
return File(data, "text/csv", filename);
}
public ActionResult GetReport(int[] reportID)
{
List<IssueViewModel> issueViewModels = new List<IssueViewModel>();
int al = reportID.Length;
for(int i = 0; i<al; i++){
var view = new IssueViewModel {
cissue = db.Issues.Find(reportID[i]),
cactivities = db.Activities.SqlQuery("SELECT * FROM Activity WHERE IssueID='"+reportID[i]+"'")
};
issueViewModels.Add(view);
}
var viewModel = new ReportIssueViewModel
{
report_issues = issueViewModels
};
return View(viewModel);
}
public ActionResult Details(int id)
{
Issue issue = db.Issues.Find(id);
//check that customer cannot read other issues
if (System.Web.HttpContext.Current.User.IsInRole("Customer"))
{
if (issue.Writer != System.Web.HttpContext.Current.User.Identity.Name)
{
return RedirectToAction("Index", "Issue");
}
}
string current_state;
switch (issue.State)
{
case 0:
current_state = "Not started";
break;
case 1:
current_state = "Started";
break;
case 2:
current_state = "Waiting";
break;
case 3:
current_state = "Resolved";
break;
case 4:
current_state = "Closed";
break;
default:
current_state = "Error";
break;
}
var viewModel = new IssueViewModel
{
cissue = issue,
cstate = current_state,
cactivities = db.Activities.SqlQuery("SELECT * FROM Activity WHERE IssueID='"+id+"'")
};
return View(viewModel);
}