static public bool AddViolation(Violation violation)
{
string query = "INSERT INTO ViolationTable(ViolationUID, DepartmentUID, StenerSetUID, Severity, ViolatedDate, ViolationDescription)VALUES('"
+ violation.ViolationUID.ToString() + "','" + violation.DepartmentUID.ToString() + "','"
+ violation.StenerSetUID.ToString() + "','" + violation.Severity.ToString() + "','"
+ violation.ViolationDate.ToString() + "','" + violation.ViolationDescription + "')";
bool passed = NonQueryDatabase(query);
return(passed);
}
public static bool AddViolation(Violation violation)
{
var query =
"INSERT INTO ViolationTable(ViolationUid, DepartmentUid, StenerSetUid, Severity, ViolatedDate, ViolationDescription)VALUES('"
+ violation.ViolationUid + "','" + violation.DepartmentUid + "','"
+ violation.StenerSetUid + "','" + violation.Severity + "','"
+ violation.ViolationDate.ToString("MM/dd/yyyy hh:mm:ss tt") + "','" + violation.ViolationDescription +
"')";
var passed = NonQueryDatabase(query);
return(passed);
}
public static List <Violation> GetAllViolations()
{
var query = "SELECT * FROM ViolationTable";
var violationTable = QueryDatabase(query);
var violations = new List <Violation>();
if (violationTable.Rows.Count != 0)
{
foreach (DataRow row in violationTable.Rows)
{
var violation = new Violation();
violation.ViolationUid = row.Field <int>("ViolationUid");
violation.DepartmentUid = row.Field <int>("DepartmentUid");
violation.StenerSetUid = row.Field <int>("StenerSetUid");
violation.Severity = row.Field <int>("Severity");
if (row.Field <string>("ViolatedDate") != null)
{
//test
var test = row.Field <string>("ViolatedDate");
violation.ViolationDate = DateTime.ParseExact(row.Field <string>("ViolatedDate"),
"MM/dd/yyyy hh:mm:ss tt", null);
}
if (row.Field <string>("ViolationDescription") != null)
{
violation.ViolationDescription = row.Field <string>("ViolationDescription");
}
violations.Add(violation);
}
return(violations);
}
return(null);
}
static public List <Violation> GetDepartmentViolations(int departmentUID)
{
string query = "SELECT * FROM ViolationTable WHERE DepartmentUID = " + departmentUID.ToString();
DataTable violationTable = QueryDatabase(query);
List <Violation> violations = new List <Violation>();
if (violationTable.Rows.Count != 0)
{
foreach (DataRow row in violationTable.Rows)
{
Violation violation = new Violation();
violation.ViolationUID = row.Field <int>("ViolationUID");
violation.DepartmentUID = row.Field <int>("DepartmentUID");
violation.StenerSetUID = row.Field <int>("StenerSetUID");
violation.Severity = row.Field <int>("Severity");
if (row.Field <string>("ViolatedDate") != null)
{
violation.ViolationDate = DateTime.ParseExact(row.Field <string>("ViolatedDate"), "MM/dd/yyyy hh:mm:ss tt", null);
}
if (row.Field <string>("ViolationDescription") != null)
{
violation.ViolationDescription = row.Field <string>("ViolationDescription");
}
violations.Add(violation);
}
return(violations);
}
else
{
return(null);
}
}
