protected void btn_add_Click1(object sender, EventArgs e)
    {
        try
        {
            tbl_rescue_BAL objbal = new tbl_rescue_BAL();
            tbl_rescue_DAL objdal = new tbl_rescue_DAL();


            objdal.int_voluntar_team_id = Convert.ToInt16(ddl_voluntar_team_name.SelectedItem.Value);
            objdal.str_rescue_place     = txt_rescue_place.Text;
            objdal.date_rescue_date     = Convert.ToDateTime(txt_rescue_date.Text);
            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 bot allowed";
                lblmsg.ForeColor = System.Drawing.Color.Red;
            }



            changepanel(1, 0);
        }
        catch (Exception ex)
        {
        }
    }
    protected void btn_update_Click(object sender, EventArgs e)
    {
        try
        {
            tbl_rescue_BAL objbal = new tbl_rescue_BAL();
            tbl_rescue_DAL objdal = new tbl_rescue_DAL();

            objdal.int_rescue_id        = Convert.ToInt16(ViewState["id"]);
            objdal.int_voluntar_team_id = Convert.ToInt16(ddl_voluntar_team_name.SelectedItem.Value);
            objdal.str_rescue_place     = txt_rescue_place.Text;
            objdal.date_rescue_date     = Convert.ToDateTime(txt_rescue_date.Text);

            lblmsg.Visible = true;
            int val = objbal.update_data(objdal);
            objbal.update_data(objdal);
            binddata("");
            changepanel(1, 0);
            if (val > 0)
            {
                lblmsg.Text      = "Data Update";
                lblmsg.ForeColor = System.Drawing.Color.Green;
            }
            else
            {
                lblmsg.Text      = "Error in Process,try again";
                lblmsg.ForeColor = System.Drawing.Color.Red;
            }
        }
        catch (Exception ex)
        {
        }
    }
示例#3
0
 public void binddata(string query)
 {
     try
     {
         tbl_rescue_BAL objbal = new tbl_rescue_BAL();
         DataSet        ds     = objbal.getdata(query);
         gvlist.DataSource = ds;
         gvlist.DataBind();
     }
     catch (Exception ex)
     {
     }
 }
    protected void btn_select_delete_Click(object sender, EventArgs e)
    {
        try
        {
            tbl_rescue_BAL objbal = new tbl_rescue_BAL();
            tbl_rescue_DAL objdal = new tbl_rescue_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_rescue_id = Convert.ToInt16(id.Value);
                    objbal.delete_data(objdal);
                    binddata("");
                }
            }
        }
        catch (Exception ex)
        {
        }
    }