protected void btn_login_Click(object sender, EventArgs e) { try { tbl_member_BAL objbal = new tbl_member_BAL(); cryptography objcrypt = new cryptography(); string query = "where str_email='" + txt_member_name.Text + "'"; DataSet ds = objbal.getdata(query); if (ds.Tables[0].Rows.Count > 0) { string str = objcrypt.Decrypt(ds.Tables[0].Rows[0]["str_password"].ToString()); if (str.Equals(txt_password.Text)) { Session["vname"] = txt_member_name.Text; Session["vtype"] = "m"; Response.Redirect("inquiry_reply_page.aspx"); } } } catch (Exception ex) { } }
public void binddata(string query) { try { tbl_member_BAL objbal = new tbl_member_BAL(); DataSet ds = objbal.getdata(query); gvlist.DataSource = ds; gvlist.DataBind(); } catch (Exception ex) { } }
private void bindddlmember() { try { tbl_member_BAL objbal = new tbl_member_BAL(); DataSet ds = objbal.getdata(""); ddl_member.DataValueField = "int_member_id"; ddl_member.DataTextField = "str_member_name"; ddl_member.DataSource = ds; ddl_member.DataBind(); ddl_member.Items.Insert(0, new ListItem("---select---", "0")); } catch (Exception ex) { } }
protected void btn_add_Click(object sender, EventArgs e) { try { tbl_member_BAL objbal = new tbl_member_BAL(); tbl_member_DAL objdal = new tbl_member_DAL(); cryptography objcrypt = new cryptography(); string str = objcrypt.Encrypt(txt_password.Text); objdal.int_disaster_id = Convert.ToInt16(ddl_disaster_master.SelectedItem.Value); objdal.str_member_name = txt_member_name.Text; objdal.int_designation_id = Convert.ToInt16(ddl_designation_name.SelectedItem.Value); objdal.str_current_working = txt_currentworking.Text; objdal.str_address = txt_address.Text; objdal.int_contact = Convert.ToInt64(txt_contact.Text); objdal.str_email = txt_email.Text; objdal.str_password = str; int val = objbal.insert_data(objdal); if (val > 0) { lblmsg.Text = "Data successfully inserted"; lblmsg.ForeColor = System.Drawing.Color.Green; ddl_disaster_master.ClearSelection(); txt_member_name.Text = string.Empty; ddl_designation_name.ClearSelection(); txt_currentworking.Text = string.Empty; txt_address.Text = string.Empty; txt_contact.Text = string.Empty; txt_email.Text = string.Empty; } } catch (Exception ex) { } }
protected void btn_select_delete_Click(object sender, EventArgs e) { try { tbl_member_BAL objbal = new tbl_member_BAL(); tbl_member_DAL objdal = new tbl_member_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_member_id = Convert.ToInt16(id.Value); objbal.delete_data(objdal); binddata(""); } } } catch (Exception ex) { } }