protected
void
Page_Load(
object
sender, EventArgs e)
{
if
(!IsPostBack)
{
string
[] filePaths = Directory.GetFiles(Server.MapPath(
"~/Uploads/"
));
List<ListItem> files =
new
List<ListItem>();
foreach
(
string
filePath
in
filePaths)
{
files.Add(
new
ListItem(Path.GetFileName(filePath), filePath));
}
GridView1.DataSource = files;
GridView1.DataBind();
}
}
protected
void
UploadFile(
object
sender, EventArgs e)
{
string
fileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
FileUpload1.PostedFile.SaveAs(Server.MapPath(
"~/Uploads/"
) + fileName);
Response.Redirect(Request.Url.AbsoluteUri);
}
protected
void
DownloadFile(
object
sender, EventArgs e)
{
string
filePath = (sender
as
LinkButton).CommandArgument;
Response.ContentType = ContentType;
Response.AppendHeader(
"Content-Disposition"
,
"attachment; filename="
+ Path.GetFileName(filePath));
Response.WriteFile(filePath);
Response.End();
}
protected
void
DeleteFile(
object
sender, EventArgs e)
{
string
filePath = (sender
as
LinkButton).CommandArgument;
File.Delete(filePath);
Response.Redirect(Request.Url.AbsoluteUri);
}
protected
void
SaveAllFiles(
object
sender, EventArgs e)
{
string
fileNames =
string
.Empty;
foreach
(GridViewRow row
in
this
.GridView1.Rows)
{
fileNames += row.Cells[0].Text +
","
;
}
string
files = fileNames.Remove(fileNames.Length - 1);
string
constr = ConfigurationManager.ConnectionStrings[
"conString"
].ConnectionString;
string
sqlStatment =
"UPDATE FilesUploaded SET FileName = @FileName WHERE Id =@Id"
;
using
(SqlConnection con =
new
SqlConnection(constr))
{
using
(SqlCommand cmd =
new
SqlCommand(sqlStatment, con))
{
con.Open();
cmd.Parameters.AddWithValue(
"@FileName"
, files);
cmd.Parameters.AddWithValue(
"@Id"
, Convert.ToInt32(
this
.txtId.Text.Trim()));
cmd.ExecuteNonQuery();
con.Close();
}
}
}