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