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); } }