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