private void txt_NewStreet_KeyUp(object sender, KeyEventArgs e)
{
StreetArr addressArr = new StreetArr();
addressArr.Fill();
addressArr = addressArr.Filter(txt_NewAddrees.Text);
listbox_Streets.DataSource = addressArr;
}
public int GetStreet()
{
StreetArr addressArr = new StreetArr();
if (txt_NewAddrees.Text != "")
{
return(addressArr.GetId(txt_NewAddrees.Text));
}
else
{
return(-1);
}
}
private void StreetArrToForm(Street street)
{
StreetArr addressArr = new StreetArr();
addressArr.Fill();
listbox_Streets.DataSource = addressArr;
listbox_Streets.ValueMember = "Id";
listbox_Streets.DisplayMember = "Name";
if (street != null)
{
listbox_Streets.SelectedValue = street.Id;
}
}
public void StreetArrToForm(Street street)
{
StreetArr streetArr = new StreetArr();
streetArr.Fill();
cmb_Street.DataSource = streetArr;
cmb_Street.ValueMember = "Id";
cmb_Street.DisplayMember = "Name";
if (street != null)
{
cmb_Street.SelectedValue = street.Id;
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
if (CheckForm())
{
Street street = new Street();
street = FormToStreet();
StreetArr oldStreetArr = new StreetArr();
oldStreetArr.Fill();
if (!oldStreetArr.IsContain(street.Name))
{
if (street.Id == 0)
{
if (street.Insert())
{
MessageBox.Show("Data saved successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearForm();
StreetArr streetArr = new StreetArr();
streetArr.Fill();
street = streetArr.GetStreetWithMaxId();
StreetArrToForm(street);
}
}
else
{
if (street.Update())
{
MessageBox.Show("Data updated successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearForm();
StreetArr streetArr = new StreetArr();
streetArr.Fill();
street = streetArr.GetStreetWithMaxId();
StreetArrToForm(street);
}
}
}
else
{
MessageBox.Show("Street already exsits", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
ClearForm();
}
}
}
