protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
Panel1.Visible = true;
if (e.CommandName == "Decrypt")
{
int rowIndex = Convert.ToInt32(e.CommandArgument);
string encrypted_text, decrypted_text, key;
key = TextBox1.Text.ToString();
if (key == "")
{
Response.Write("<script>window.alert('Please enter a key!!');</script>");
return;
}
EncDecServiceReference.EncDecServiceClient ed_service = new EncDecServiceReference.EncDecServiceClient();
GridViewRow row = GridView1.Rows[rowIndex];
file_name = row.Cells[2].Text;
string user = System.Web.HttpContext.Current.User.Identity.Name;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
try
{
using (conn)
{
string query = "select TextToByte from UserFiles where UserName=@username and FilePath=@file_name";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@username", user);
cmd.Parameters.AddWithValue("@file_name", file_name);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
encrypted_text = reader.GetValue(0).ToString();
decrypted_text = ed_service.DecryptData(key, encrypted_text);
dec_data = decrypted_text.ToString();
}
conn.Close();
}
}
catch (SqlException ex)
{
Response.Write(ex);
}
}
}
