public ActionResult List(string project, string severity, string datediscovered,
string timediscovered, int projectedmanhours, string shortdescription,
string location, string description)
{
List <string> newArgs = new List <string>();
MySqlTableModel issueTable = SqlTables.Issues;
//projectedmanhours
string pmh = projectedmanhours.ToString();
//projectedcost
float tempPc = projectedmanhours * 20;
string pc = tempPc.ToString();
newArgs = new List <string>()
{
"DEFAULT",
project,
severity,
datediscovered,
timediscovered,
pmh,
pc,
shortdescription,
location,
"DEFAULT",
description
};
MySqlCrud.InsertRow(SqlConnections.IssueWebsite, issueTable.Table,
issueTable.Collumns, newArgs);
return(RedirectToAction("List"));
}
public ActionResult List()
{
List <Issue> issues = new List <Issue>();
List <string>[] values;
MySqlTableModel issueTable = SqlTables.Issues;
values = MySqlCrud.SelectAllRows(SqlConnections.IssueWebsite, issueTable.Table, issueTable.Collumns);
/*
* idIssues DEFAULT(int)
* project name
* severity string
* datediscovered string XX/XX/XXXX
* time discovered string XX:XX:XX
* projectedmanhours float
* projectedcost float
* shortdescription string
* location string
* popularity int
* description string
*/
int r = 0;
foreach (var i in values[0])
{
int issueId;
Int32.TryParse(values[0][r], out issueId);
string project = values[1][r]; //100 MaxChars
string severity = values[2][r]; //45 MaxChars
string datediscovered = values[3][r]; //45 MaxChars
string timediscovered = values[4][r]; //45 MaxChars
int pmhTemp;
Int32.TryParse(values[5][r], out pmhTemp);
float projectedmanhours = (float)pmhTemp;
int pcTemp;
Int32.TryParse(values[6][r], out pcTemp);
float projectedcost = (float)pcTemp;
string shortdescription = values[7][r]; //100 MaxChars
string location = values[8][r]; //45 MaxChars
int popularity;
Int32.TryParse(values[9][r], out popularity);
string description = values[10][r]; //300 MaxChars
Issue ish = new Issue()
{
Project = project,
Severity = severity,
DateDiscovered = datediscovered,
TimeDiscovered = timediscovered,
ProjectedManHours = projectedmanhours,
ProjectedCost = projectedcost,
ShortDescription = shortdescription,
Location = location,
Popularity = popularity,
Description = description
};
issues.Add(ish);
r++;
}
IssueListModel IssueListModel = new IssueListModel()
{
Issues = issues
};
return(View(IssueListModel));
}
