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