public List <FixPaperDTO> GetFixPaper(int user_id)
{
VehicleQuery vehicleQuery = new VehicleQuery(language);
System.Data.DataTable dataTable = conn_db.ReadTable(vehicleQuery.GetObjectByColname("fixPaper_v", "user_id", user_id));
FixPaperDTO fixPaper = new FixPaperDTO();
List <FixPaperDTO> listPapers = new List <FixPaperDTO>();
if (dataTable.Rows.Count == 0)
{
throw new EmptyViewException(language);
}
foreach (System.Data.DataRow row in dataTable.Rows)
{
fixPaper = new FixPaperDTO();
fixPaper.id = Convert.ToInt32(row["ID"].ToString());
fixPaper.paper_id = row["PAPER_ID"].ToString();
fixPaper.issueDate = Convert.ToDateTime(row["ISSUEDATE"].ToString()).ToString("dd-MM-yyyy");
fixPaper.expiryDate = Convert.ToDateTime(row["EXPIRYDATE"].ToString()).ToString("dd-MM-yyyy");
fixPaper.status = Convert.ToInt32(row["status"].ToString());
fixPaper.car_plateNumber = row["CAR_PLATENUMBER"].ToString();
listPapers.Add(fixPaper);
}
return(listPapers);
}
public List <Brand> GetBrands(string lang)
{
VehicleQuery vehicleQuery = new VehicleQuery(language);
System.Data.DataTable dataTable = conn_db.ReadTable(vehicleQuery.GetObjectByColname("car_brand", "isactive", 1));
if (dataTable.Rows.Count == 0)
{
throw new EmptyViewException(language);
}
Brand brand;
List <Brand> Brands = new List <Brand>();
foreach (System.Data.DataRow row in dataTable.Rows)
{
brand = new Brand();
brand.brand_id = Convert.ToInt32(row["id"].ToString());
if (lang == "ar")
{
brand.brandName = row["BRANDNAME_AR"].ToString();
}
else
{
brand.brandName = row["BRANDNAME_EN"].ToString();
}
brand.Logo = row["LOGO"].ToString();
Brands.Add(brand);
}
return(Brands);
}
public List <string> GetCarImages(int order_id, int ordertype)
{
VehicleQuery vehicleQuery = new VehicleQuery(language);
string modelImage = "";
System.Data.DataTable dataTable = conn_db.ReadTable(vehicleQuery.GetObjectByColname("car_images_v", "order_id", order_id));
if (dataTable.Rows.Count == 0)
{
if (ordertype == 6)
{
modelImage = new Enums().APP_DIRECTORY + "images/OrderImages/satha.png";
}
else
{
throw new EmptyViewException(language, Messages.GetMessage(language, TypeM.VEHICLE, vehicleM.IMAGE_NOT_FOUND));
}
}
List <string> listCarImages = new List <string>();
foreach (System.Data.DataRow row in dataTable.Rows)
{
listCarImages.Add(row["Pic_url"].ToString());
}
if (listCarImages.Count == 0)
{
listCarImages.Add(modelImage);
}
return(listCarImages);
}
