private void update() { if (this.txtName.TextLength <= 0 || MessageBox.Show("Güncellenicektir!!! Emin misiniz?", "Uyarı", MessageBoxButtons.YesNo) != DialogResult.Yes) return; Product product = (Product)this.cbProducts.SelectedItem; ProductType productType = (ProductType)this.cbProTypes.SelectedItem; if (product.Name == "Yeni") { product = new Product(); product.ID = 0; } int status = 2; if (!this.cbStatus.Checked) status = 1; Decimal price = Convert.ToDecimal(this.txtPrice.Text); Product.Products_Update(product.ID, this.txtName.Text, productType.ID, status, price); this.Fill(); }
public static List<Product> Products_GetAll() { string query = "Products_GetAll"; DataTable dt = Connection.runQuery(query, new SqlParameter[0]); List<Product> res = new List<Product>(); for (int i = 0; i < dt.Rows.Count; i++) { Product tmp = new Product(); tmp.ID = Convert.ToInt32(dt.Rows[i]["ID"].ToString()); tmp.Name = dt.Rows[i]["Name"].ToString(); tmp.Type = Convert.ToInt32(dt.Rows[i]["Type"].ToString()); tmp.Status = Convert.ToInt32(dt.Rows[i]["Status"].ToString()); tmp.Price = Convert.ToDecimal(dt.Rows[i]["Price"].ToString()); res.Add(tmp); } return res; }
public static Product Products_GetByID(int id) { string query = "Products_GetByID"; List<SqlParameter> prms = new List<SqlParameter>(); prms.Add(new SqlParameter("@ID", id)); DataTable dt = Connection.runQuery(query, prms.ToArray()); Product res = new Product(); for (int i = 0; i < dt.Rows.Count; i++) { Product tmp = new Product(); tmp.ID = Convert.ToInt32(dt.Rows[i]["ID"].ToString()); tmp.Name = dt.Rows[i]["Name"].ToString(); tmp.Type = Convert.ToInt32(dt.Rows[i]["Type"].ToString()); tmp.Status = Convert.ToInt32(dt.Rows[i]["Status"].ToString()); tmp.Price = Convert.ToDecimal(dt.Rows[i]["Price"].ToString()); res=tmp; } return res; }