protected void btn_update_Click(object sender, EventArgs e)
{
try
{
tbl_voluntar_team_BAL objbal = new tbl_voluntar_team_BAL();
tbl_voluntar_team_DAL objdal = new tbl_voluntar_team_DAL();
objdal.int_voluntar_team_id = Convert.ToInt16(ViewState["id"]);
objdal.str_voluntar_team_name = txt_voluntar_team_name.Text;
objdal.date_voluntar_date = Convert.ToDateTime(txt_cal.Text);
objdal.bit_active = chk_active.Checked;
objdal.int_member_id = Convert.ToInt16(ddl_member.SelectedItem.Value);
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)
{
}
}
protected void btn_add_Click1(object sender, EventArgs e)
{
try
{
tbl_voluntar_team_BAL objbal = new tbl_voluntar_team_BAL();
tbl_voluntar_team_DAL objdal = new tbl_voluntar_team_DAL();
objdal.str_voluntar_team_name = txt_voluntar_team_name.Text;
objdal.date_voluntar_date = Convert.ToDateTime(txt_cal.Text);
objdal.bit_active = chk_active.Checked;
objdal.int_member_id = Convert.ToInt16(ddl_member.SelectedItem.Value);
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 not allowed";
lblmsg.ForeColor = System.Drawing.Color.Red;
}
changepanel(1, 0);
}
catch (Exception ex)
{
}
}
public void binddata(string query)
{
try
{
tbl_voluntar_team_BAL objbal = new tbl_voluntar_team_BAL();
DataSet ds = objbal.getdata(query);
gvlist.DataSource = ds;
gvlist.DataBind();
}
catch (Exception ex)
{
}
}
private void bindddlvoluntarteam()
{
tbl_voluntar_team_BAL objbal = new tbl_voluntar_team_BAL();
DataSet ds = objbal.getdata("");
ddl_voluntar_team_name.DataValueField = "int_voluntar_team_id";
ddl_voluntar_team_name.DataTextField = "str_voluntar_team_name";
ddl_voluntar_team_name.DataSource = ds;
ddl_voluntar_team_name.DataBind();
ddl_voluntar_team_name.Items.Insert(0, new ListItem("---select---", "0"));
}
protected void btn_select_delete_Click(object sender, EventArgs e)
{
try
{
tbl_voluntar_team_BAL objbal = new tbl_voluntar_team_BAL();
tbl_voluntar_team_DAL objdal = new tbl_voluntar_team_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_voluntar_team_id = Convert.ToInt16(id.Value);
objbal.delete_data(objdal);
binddata("");
}
}
}
catch (Exception ex)
{
}
}
