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