protected void btn_Submit_Click(object sender, EventArgs e)
{
if (lbl_Message.Text == "Edit Data")
{
using (SqlConnection con = new SqlConnection(IGTMAIN.CS))
{
string cmdText = "UPDATE User_Details SET User_Type=@User_Type, User_Status = @User_Status, User_pass = @User_pass ,User_Name=@User_Name, User_Email=@User_Email,User_Phno=@User_Phno WHERE User_ID=@Id";
SqlCommand cmd = new SqlCommand(cmdText, con);
cmd.Parameters.AddWithValue("@User_Type", ddl_User_Type.Text);
cmd.Parameters.AddWithValue("@User_Status", ddl_Status.Text);
cmd.Parameters.AddWithValue("@User_Code", txt_User_Code.Text);
cmd.Parameters.AddWithValue("@User_pass", IGTMAIN.Encryptdata(txt_User_pass.Text));
cmd.Parameters.AddWithValue("@User_Name", txt_User_Name.Text);
cmd.Parameters.AddWithValue("@User_Email", txt_User_Email.Text);
cmd.Parameters.AddWithValue("@User_Phno", txt_User_Phno.Text);
cmd.Parameters.AddWithValue("@Id", Convert.ToInt32(hfSelectedRecord.Value));
con.Open();
cmd.ExecuteNonQuery();
}
clearInputControls();
bindDetailsToListView();
hfSelectedRecord.Value = string.Empty;
lbl_Message.Text = "Record is Updated Successfully.";
}
else
{
DataRow[] dr = IGTMAIN.dtlp.Select("User_Code = '" + txt_User_Code.Text + "'");
if (dr.Length == 0)
{
using (SqlConnection con = new SqlConnection(IGTMAIN.CS))
{
string cmdText = "INSERT INTO User_Details (User_Type, User_Status, User_Code,User_Name,User_pass,User_Email,User_Phno) VALUES (@User_Type, @User_Status, @User_Code,@User_Name,@User_pass,@User_Email,@User_Phno)";
SqlCommand cmd = new SqlCommand(cmdText, con);
cmd.Parameters.AddWithValue("@User_Type", ddl_User_Type.Text);
cmd.Parameters.AddWithValue("@User_Status", ddl_Status.Text);
cmd.Parameters.AddWithValue("@User_Code", txt_User_Email.Text);
cmd.Parameters.AddWithValue("@User_pass", IGTMAIN.Encryptdata(txt_User_pass.Text));
cmd.Parameters.AddWithValue("@User_Name", txt_User_Name.Text);
cmd.Parameters.AddWithValue("@User_Email", txt_User_Email.Text);
cmd.Parameters.AddWithValue("@User_Phno", txt_User_Phno.Text);
con.Open();
cmd.ExecuteNonQuery();
}
clearInputControls();
bindDetailsToListView();
lbl_Message.Text = "New Record is Added Successfully.";
}
else
{
string script = "alert(\"User Already Exist.\");";
ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true);
}
}
btn_Submit.Text = "Submit";
}
protected void updatepassword()
{
using (SqlConnection con = new SqlConnection(IGTMAIN.CS))
{
string cmdText = "UPDATE User_Details SET User_pass =@User_pass where User_Name=@User_Name";
SqlCommand cmd = new SqlCommand(cmdText, con);
cmd.Parameters.AddWithValue("@User_Name", Session["User_ID"]);
cmd.Parameters.AddWithValue("@User_pass", IGTMAIN.Encryptdata(txt_NewPass.Text));
con.Open();
cmd.ExecuteNonQuery();
script = "alert(\" Password Succesfully Updated.\");";
ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true);
}
}
