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