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