private void update() { if (this.txtNewName.TextLength <= 0 || MessageBox.Show("Güncellenicektir!!! Emin misiniz?", "Uyarı", MessageBoxButtons.YesNo) != DialogResult.Yes) return; ProductType productType = (ProductType)this.cbValues.SelectedItem; if (productType == null) { productType = new ProductType(); productType.ID = 0; } ProductType.ProductTypes_Update(productType.ID, this.txtNewName.Text, this.txtUnit.Text); this.Fill(); }
public static List<ProductType> ProductTypes_GetAll() { string query = "ProductTypes_GetAll"; DataTable dt = Connection.runQuery(query, new SqlParameter[0]); List<ProductType> res = new List<ProductType>(); for (int i = 0; i < dt.Rows.Count; i++) { ProductType tmp = new ProductType(); tmp.ID = Convert.ToInt32(dt.Rows[i]["ID"].ToString()); tmp.Name = dt.Rows[i]["Name"].ToString(); tmp.UnitType = dt.Rows[i]["UnitType"].ToString(); res.Add(tmp); } return res; }
public static ProductType ProductTypes_getByID(int id) { string query = "ProductTypes_getByID"; List<SqlParameter> prms = new List<SqlParameter>(); prms.Add(new SqlParameter("@ID", id)); DataTable dt = Connection.runQuery(query, prms.ToArray()); ProductType res = new ProductType(); for (int i = 0; i < dt.Rows.Count; i++) { ProductType tmp = new ProductType(); tmp.ID = Convert.ToInt32(dt.Rows[i]["ID"].ToString()); tmp.Name = dt.Rows[i]["Name"].ToString(); tmp.UnitType = dt.Rows[i]["UnitType"].ToString(); res = tmp; } return res; }