public string Insert(fileData data)
{
string msg = string.Empty;
con.Open();
MySqlCommand cmd = new MySqlCommand("insert into documents(Name,Type,Hash,Data,User_ID) values(@Name,@type,@hash,@data,@userid)", con);
cmd.Parameters.AddWithValue("@Name", data.Name);
cmd.Parameters.AddWithValue("@type", data.Type);
cmd.Parameters.AddWithValue("@hash", data.Hash);
cmd.Parameters.AddWithValue("@data", data.Data);
cmd.Parameters.AddWithValue("@userid", data.Userid);
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
msg = data.Name + " inserted successfully";
}
else
{
msg = "failed to insert file";
}
con.Close();
return(msg);
}
public DataSet Display(fileData data)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
MySqlCommand cmd = new MySqlCommand("select * from documents", con);
//MySqlCommand cmd = new MySqlCommand("select * from documents where User_ID=@Userid", con);
cmd.Parameters.AddWithValue("@Userid", data.Userid);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
cmd.ExecuteNonQuery();
con.Close();
return(ds);
}
