public DataTable GetCartData(string userId, string customerId, string teratmentID)
{
sql_class sql = new sql_class();
sql.Where("CustomerID", customerId);
sql.Where("teratmentID", teratmentID);
sql.Where("GaragID", userId);
return(sql.Get("CartModel"));
}
public List <RepairJobl> AllHistory(string Id)
{
List <RepairJobl> list = new List <RepairJobl>();
sql_class sql = new sql_class();
sql.Where("GaragID", Id);
DataTable data = sql.Get("RepairJob");
for (int i = 0; i < data.Rows.Count; i++)
{
RepairJobl Teratment = new RepairJobl(Convert.ToInt32(data.Rows[i]["teratmentID"]));
list.Add(Teratment);
}
return(list);
}
public static DataTable GetParts(string id, params string[] fields)
{
sql_class sql_ = new sql_class();
if (fields.Length > 0)
{
foreach (string fiald in fields)
{
if (!string.IsNullOrEmpty(fiald))
{
sql_.OrWhere("ProdectGroup", fiald);
}
}
}
sql_.Where("GaragID", id);
DataTable data = sql_.Get("PartModel");
return(data);
}