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