public override List <Category> Search(string search) { SqlProvider provider = new SqlProvider("Pr_CategorySearch", true); provider.AddParameter("@CategoryName", search); SqlDataReader reader = provider.ExecuteReader(); List <Category> categoryList = new List <Category>(); if (reader.HasRows) { while (reader.Read()) { Category category = new Category() { CategoryID = Convert.ToInt32(reader["CategoryID"]), CategoryName = reader["CategoryName"].ToString(), Description = reader["Description"].ToString() }; categoryList.Add(category); } } reader.Close(); return(categoryList); }
public override List <Product> Search(string search) { SqlProvider provider = new SqlProvider("Pr_ProductSearch", true); provider.AddParameter("@ProductName", search); SqlDataReader reader = provider.ExecuteReader(); List <Product> productList = new List <Product>(); if (reader.HasRows) { while (reader.Read()) { Product product = new Product() { ProductID = Convert.ToInt32(reader["ProductID"].ToString()), ProductName = reader["ProductName"].ToString(), CategoryID = Convert.ToInt32(reader["CategoryID"].ToString()), UnitPrice = Convert.ToDecimal(reader["UnitPrice"].ToString()), UnitsInStock = Convert.ToInt32(reader["UnitsInStock"].ToString()) }; productList.Add(product); } } reader.Close(); return(productList); }
public static List <MODEL.AdetSecimleri> Uretim_AdetSecimAlternatifleri(int stokid, string alanadi = "ADET") { /*_sqlProvider = new SqlProvider( * " SELECT ARTETIKETDETAY.*, STOK.BIRIM " + * " FROM ARTETIKETDETAY INNER JOIN STOK ON ARTETIKETDETAY.STOKID = STOK.STOKID " + * " WHERE ARTETIKETDETAY.STOKID = @STOKID " * ); * _sqlProvider.AddParameter("STOKID", stokid);*/ var dt = new DataTable(); dt.Load(_sqlProvider.ExecuteReader()); List <MODEL.AdetSecimleri> list = new List <MODEL.AdetSecimleri>(); if (dt.Rows.Count > 0) { for (int i = 1; i < 10; i++) { if (dt.Rows[0][alanadi + i.ToString()].ToString() != "") { if (dt.Rows[0][alanadi + i.ToString()].ToString() != "0") { MODEL.AdetSecimleri a = new MODEL.AdetSecimleri(); a.Aciklama = (((dt.Rows[0]["BIRIM"].ToString().ToUpper() == "LT") && (alanadi == "ADET")) ? "Kap" : "Tepsi") + " No " + i.ToString(); a.Adet = Convert.ToInt32(dt.Rows[0][alanadi + i.ToString()].ToString()); a.Tur = ((dt.Rows[0]["BIRIM"].ToString().ToUpper() == "LT") && (alanadi == "ADET")) ? "LT" : alanadi; list.Add(a); } } } } return(list); }