private void buttonUpdate_Click(object sender, EventArgs e)
{
//Get the Data from textboxes
m.ID = int.Parse(textBoxNID.Text);
m.Room = comboBoxRoom.Text;
m.Day = comboBoxDay.Text;
m.Time = textBoxTime.Text;
//Update Data in Databse
bool success = m.Update(m);
if (success == true)
{
//Updated successfully
MessageBox.Show("Data Updated Successfully");
//Load Data on DataGridVeiw
DataTable dt = m.Select();
dataGridView3.DataSource = dt;
//Call the clear method
Clear();
}
else
{
//Failed to Update
MessageBox.Show("Failed to update Try again....");
}
}
public location location_update(int ID)
{
location = location.Select(ID);
location.Location_ID = Convert.ToInt32(Update_Location_ID_txt.Text);
location.type = Update_type_txt.Text;
location.city = Update_city_txt.Text;
location.state = Update_state_txt.Text;
location.zip = Convert.ToInt32(Update_zip_txt.Text);
location.county = Update_county_txt.Text;
location.location_desc = Update_location_desc_txt.Text;
location.n_long = Convert.ToDecimal(Update_n_long_txt.Text);
location.s_long = Convert.ToDecimal(Update_s_long_txt.Text);
location.e_long = Convert.ToDecimal(Update_e_long_txt.Text);
location.w_long = Convert.ToDecimal(Update_w_long_txt.Text);
location.n_lat = Convert.ToDecimal(Update_n_lat_txt.Text);
location.s_lat = Convert.ToDecimal(Update_s_lat_txt.Text);
location.e_lat = Convert.ToDecimal(Update_e_lat_txt.Text);
location.w_lat = Convert.ToDecimal(Update_w_lat_txt.Text);
location.Update(location);
Insert_location_GridView.DataBind();
Update_location_GridView.DataBind();
Delete_location_GridView.DataBind();
return(location);
}
public location location_update(int ID)
{
location = location.Select(ID);
location.Location_ID = Convert.ToInt32(Update_Location_ID_txt.Text);
location.type = Update_type_txt.Text;
location.city = Update_city_txt.Text;
location.state = Update_state_txt.Text;
location.zip = Convert.ToInt32(Update_zip_txt.Text);
location.county = Update_county_txt.Text;
location.location_desc = Update_location_desc_txt.Text;
location.n_long = Convert.ToDecimal(Update_n_long_txt.Text);
location.s_long = Convert.ToDecimal(Update_s_long_txt.Text);
location.e_long = Convert.ToDecimal(Update_e_long_txt.Text);
location.w_long = Convert.ToDecimal(Update_w_long_txt.Text);
location.n_lat = Convert.ToDecimal(Update_n_lat_txt.Text);
location.s_lat = Convert.ToDecimal(Update_s_lat_txt.Text);
location.e_lat = Convert.ToDecimal(Update_e_lat_txt.Text);
location.w_lat = Convert.ToDecimal(Update_w_lat_txt.Text);
location.Update(location);
Insert_location_GridView.DataBind();
Update_location_GridView.DataBind();
Delete_location_GridView.DataBind();
return location;
}
