private void getPlaceAddress(TextBox tb, ComboBox cb)
{
var selected = cb.SelectedValue.ToString();
var data = new IDataPlace().Get().FirstOrDefault(x => x.id == int.Parse(selected));
tb.Text = data.place_address;
}
private void btnDelete_Click(object sender, EventArgs e)
{
var fields = new Dictionary <string, object>();
fields.Add("@id", id_place);
var result = new IDataPlace().Delete(fields);
MessageBox.Show(result.GetType().GetProperty("Message").GetValue(result, null));
loadGrid();
}
private void loadCb()
{
cbRoute1.DataSource = new IDataPlace().Get().ToList();
cbRoute1.DisplayMember = "place_name";
cbRoute1.ValueMember = "id";
getPlaceAddress(tbRoute1, cbRoute1);
cbRoute2.DataSource = new IDataPlace().Get().ToList();
cbRoute2.DisplayMember = "place_name";
cbRoute2.ValueMember = "id";
getPlaceAddress(tbRoute2, cbRoute2);
cbRoute3.DataSource = new IDataPlace().Get().ToList();
cbRoute3.DisplayMember = "place_name";
cbRoute3.ValueMember = "id";
getPlaceAddress(tbRoute3, cbRoute3);
cbRoute4.DataSource = new IDataPlace().Get().ToList();
cbRoute4.DisplayMember = "place_name";
cbRoute4.ValueMember = "id";
getPlaceAddress(tbRoute4, cbRoute4);
cbRoute5.DataSource = new IDataPlace().Get().ToList();
cbRoute5.DisplayMember = "place_name";
cbRoute5.ValueMember = "id";
getPlaceAddress(tbRoute5, cbRoute5);
var count = new IDataPlace().Get().Count() - 1;
place = new int[count];
route = new float[count, count];
var datas = new IManageRoute().Get().ToArray();
for (int row = 0; row < route.GetLength(0); row++)
{
for (int col = 0; col < route.GetLength(1); col++)
{
if (row == col)
{
route[row, col] = 0;
}
else
{
route[row, col] = datas[col + row].distance;
}
}
}
var a = route;
}
private void btnSave_Click(object sender, EventArgs e)
{
var fields = new Dictionary <string, object>();
fields.Add("@place_name", tbPlaceName.Text);
fields.Add("@place_address", tbPlaceAddress.Text);
if (btnSave.Text == "Update")
{
fields.Add("@id", id_place);
var result = new IDataPlace().Update(fields);
MessageBox.Show(result.GetType().GetProperty("Message").GetValue(result, null));
}
else
{
var result = new IDataPlace().Insert(fields);
MessageBox.Show(result.GetType().GetProperty("Message").GetValue(result, null));
}
loadGrid();
reset();
}
