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