private void buttonAdd_Click(object sender, EventArgs e)
{
//Get the value from the input feilds
m.Room = comboBoxRoom.Text;
m.Day = comboBoxDay.Text;
m.Time = textBoxTime.Text;
//inserting Data into Databse using the method we creted in pervious episode
bool success = m.Insert(m);
if (success == true)
{
//successfully Inserted
MessageBox.Show("Data is added successfully");
//call the clear method here
Clear();
}
else
{
//Failed to insert data
MessageBox.Show("Failed to add data. Please try again.....");
}
//Load Data on DataGridVeiw
DataTable dt = m.Select();
dataGridView3.DataSource = dt;
}
protected void Insert_Click(object sender, EventArgs e)
{
if (city_txt.Text == "" ||
state_txt.Text == "" ||
zip_txt.Text == "" ||
county_txt.Text == "" ||
Nlat_txt.Text == "" ||
Nlong_txt.Text == "" ||
Slat_txt.Text == "" ||
Slong_txt.Text == "" ||
Elat_txt.Text == "" ||
Elong_txt.Text == "" ||
Wlat_txt.Text == "" ||
Wlong_txt.Text == "" ||
LocationDiscription_txt.Text == ""
)
{
Error.Text = "Please fill out every text-box with '*' accordingly to continue.";
}
else
{
//Location
Location.Location_ID = GlobalVariables.Location_ID;
Location.type = "E";
Location.city = city_txt.Text;
Location.state = state_txt.Text;
Location.zip = Convert.ToInt32(zip_txt.Text);
Location.county = county_txt.Text;
Location.location_desc = LocationDiscription_txt.Text;
Location.n_long = Convert.ToDecimal(Nlong_txt.Text);
Location.s_long = Convert.ToDecimal(Slong_txt.Text);
Location.e_long = Convert.ToDecimal(Elong_txt.Text);
Location.w_long = Convert.ToDecimal(Wlong_txt.Text);
Location.n_lat = Convert.ToDecimal(Nlat_txt.Text);
Location.s_lat = Convert.ToDecimal(Slat_txt.Text);
Location.e_lat = Convert.ToDecimal(Elat_txt.Text);
Location.w_lat = Convert.ToDecimal(Wlat_txt.Text);
location newloc = Location.Insert(Location);
DMCS.Evacuation_Area EvacObj = new DMCS.Evacuation_Area();
EvacObj.Evacuation_Area_ID = GlobalVariables.Evacuation_Area_ID;
EvacObj.Location_ID = newloc.Location_ID;
EvacObj.Insert(EvacObj);
Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowMessage", string.Format("<script type='text/javascript'>alert('Evacuation Area Inserted Successfully!'); location.href = location.href;</script>", true));
}
}
public location location_insert()
{
location.type = Insert_type_txt.Text;
location.city = Insert_city_txt.Text;
location.state = Insert_state_txt.Text;
location.zip = Convert.ToInt32(Insert_zip_txt.Text);
location.county = Insert_county_txt.Text;
location.location_desc = Insert_location_desc_txt.Text;
location.n_long = Convert.ToDecimal(Insert_n_long_txt.Text);
location.s_long = Convert.ToDecimal(Insert_s_long_txt.Text);
location.e_long = Convert.ToDecimal(Insert_e_long_txt.Text);
location.w_long = Convert.ToDecimal(Insert_w_long_txt.Text);
location.n_lat = Convert.ToDecimal(Insert_n_lat_txt.Text);
location.s_lat = Convert.ToDecimal(Insert_s_lat_txt.Text);
location.e_lat = Convert.ToDecimal(Insert_e_lat_txt.Text);
location.w_lat = Convert.ToDecimal(Insert_w_lat_txt.Text);
location = location.Insert(location);
Insert_location_GridView.DataBind();
Update_location_GridView.DataBind();
Delete_location_GridView.DataBind();
return(location);
}
