protected void btn_add_Click1(object sender, EventArgs e) { try { tbl_disaster_master_BAL objbal = new tbl_disaster_master_BAL(); tbl_disaster_master_DAL objdal = new tbl_disaster_master_DAL(); objdal.str_disaster_name = txt_disaster_master_name.Text; objdal.date_active_date = Convert.ToDateTime(txt_active_date.Text); objdal.date_end_date = Convert.ToDateTime(txt_end_date.Text); objdal.bit_status = chk_active.Checked; objdal.str_place = txt_place.Text; objdal.str_longitude = txt_longitude.Text; objdal.str_latitude = txt_latitude.Text; objdal.int_disaster_type_id = Convert.ToInt16(ddl_disaster_type.SelectedItem.Value); objdal.str_img = fu_img.FileName; if (fu_img.HasFile) { //if (fu_img.PostedFile.ContentLength <= 250000) //{ string path = Server.MapPath("~/upload/disaster/"); fu_img.SaveAs(path + fu_img.FileName); //} } lblmsg.Visible = true; int val = objbal.insert_data(objdal); if (val > 0) { binddata(""); lblmsg.Text = "successfully inserted"; lblmsg.ForeColor = System.Drawing.Color.Green; } else if (val == -1) { lblmsg.Text = "name duplicate is dot allowed"; lblmsg.ForeColor = System.Drawing.Color.Red; } changepanel(1, 0); } catch (Exception ex) { } }
public void binddata(string query) { try { tbl_disaster_master_BAL objbal = new tbl_disaster_master_BAL(); DataSet ds = objbal.getdata(query); gvlist.DataSource = ds; gvlist.DataBind(); } catch (Exception ex) { } }
private void bindlost(string query) { try { tbl_disaster_master_BAL objbal = new tbl_disaster_master_BAL(); DataSet ds = objbal.getdata(query); ddl_place.DataSource = ds; ddl_place.DataBind(); } catch (Exception ex) { } }
private void bindddldisastermaster() { try { tbl_disaster_master_BAL objbal = new tbl_disaster_master_BAL(); DataSet ds = objbal.getdata(""); ddl_disaster_master.DataValueField = "int_disaster_id"; ddl_disaster_master.DataTextField = "str_disaster_name"; ddl_disaster_master.DataSource = ds; ddl_disaster_master.DataBind(); ddl_disaster_master.Items.Insert(0, new ListItem("---select---", "0")); } catch (Exception ex) { } }
private void bindplace(string query) { try { tbl_disaster_master_BAL objbal = new tbl_disaster_master_BAL(); DataSet ds = objbal.getdata(query); hid_lat.Value = ds.Tables[0].Rows[0]["str_latitude"].ToString(); hid_lang.Value = ds.Tables[0].Rows[0]["str_longitude"].ToString(); dv_list.DataSource = ds; dv_list.DataBind(); } catch (Exception ex) { } }
protected void btn_select_delete_Click(object sender, EventArgs e) { try { tbl_disaster_master_BAL objbal = new tbl_disaster_master_BAL(); tbl_disaster_master_DAL objdal = new tbl_disaster_master_DAL(); foreach (GridViewRow row in gvlist.Rows) { var check = row.FindControl("chkselect") as CheckBox; if (check.Checked) { var id = row.FindControl("Hiddenid") as HiddenField; objdal.int_disaster_id = Convert.ToInt16(id.Value); objbal.delete_data(objdal); binddata(""); } } } catch (Exception ex) { } }