public DataTable GetAllCarInfo()
{
SqlHelper helper = new SqlHelper();
DataTable dt=new DataTable();
helper.FillDataset("P_CarInfo_S", dt);
return dt;
}
private List<ViolationModel> GetViolation(string carNumber, string carFrame, string ViolationStatus)
{
List<ViolationModel> listModel = new List<ViolationModel>();
SqlHelper helper = new SqlHelper();
DataSet ds = new DataSet();
ds.Tables.Add("Violation");
helper.FillDataset("P_TrafficViolation_Get_By_CarNum", ds.Tables["Violation"], carNumber, carFrame, ViolationStatus);
for (int i = 0; i < ds.Tables["Violation"].Rows.Count; i++)
{
listModel.Add(new ViolationModel
{
CarNumber = ds.Tables["Violation"].Rows[i]["CarNumber"].ToString(),
ViolationAddress = ds.Tables["Violation"].Rows[i]["ViolationAddress"].ToString(),
ViolationDateTime = ds.Tables["Violation"].Rows[i]["ViolationDateTime"].ToString(),
ViolationAmount = int.Parse(ds.Tables["Violation"].Rows[i]["ViolationAmount"].ToString()),
ViolationScore = int.Parse(ds.Tables["Violation"].Rows[i]["ViolationScore"].ToString()),
ViolationContent = ds.Tables["Violation"].Rows[i]["ViolationContent"].ToString(),
ViolationStatus = ds.Tables["Violation"].Rows[i]["ViolationStatus"].ToString(),
Created_Time = DateTime.Parse(ds.Tables["Violation"].Rows[i]["Created_Time"].ToString()),
});
}
return listModel;
}