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