public static void SetNew(String[] vals) { String connString = Properties.Settings.Default.HQ; DataTable dt = new DataTable(); SqlConnection con = new SqlConnection(connString); MOpReg o = new MOpReg(); String id = GetNewHQID(); con.Open(); SqlCommand command = new SqlCommand("INSERT INTO Operational_Region VALUES ("+ id +",'" + vals[1] + "'," + vals[2] + "," + vals[3] + "," + vals[4] +" )", con); command.ExecuteNonQuery(); con.Close(); }
public static void SetNew(String[] vals) { String connString = Properties.Settings.Default.HQ; DataTable dt = new DataTable(); SqlConnection con = new SqlConnection(connString); MOpReg o = new MOpReg(); String id = GetNewHQID(); con.Open(); SqlCommand command = new SqlCommand("INSERT INTO Operational_Region VALUES (" + id + ",'" + vals[1] + "'," + vals[2] + "," + vals[3] + "," + vals[4] + " )", con); command.ExecuteNonQuery(); con.Close(); }
public void DeleteRegionBtn_Click(object sender, EventArgs e) { String id = _hqForm.GetSelectedRegion(); if (id == "NULL") { return; } else { if (MOpReg.hasFranchise(id)) { MessageBox.Show("Cannot Delete a Region that Has a Franchise\n Delete the franchisee first."); return; } else { MOpReg.Delete(id); _hqForm.LoadOpRegions(); } } }
public void LoadOpRegions() { DataTable dt = MOpReg.GetRegions(); DataTable regs = new DataTable(); regs.Columns.Add("ID", typeof(string)); regs.Columns.Add("Display", typeof(string)); regs.Rows.Add(new String[] { "NULL", "<All>" }); foreach (DataRow r in dt.Rows) { regs.Rows.Add(r["zone_id"].ToString(), r["zone_Title"].ToString() + " ( " + MCity.GetName(r["city_id"].ToString()) + ", " + MProvState.GetName(r["province_id"].ToString()) + ", " + MCountry.GetName(r["country_id"].ToString()) + ")"); } OpRegionCombo.DataSource = regs; OpRegionCombo.ValueMember = regs.Columns["ID"].ToString(); OpRegionCombo.DisplayMember = regs.Columns["Display"].ToString(); OpRegionCombo.SelectedValue = "NULL"; }
public void AddRegionBtn_Click(object sender, EventArgs e) { String[] values = _hqForm.getNewRegion(); MOpReg.SetNew(values); _hqForm.LoadOpRegions(); }