public HttpResponseMessage Upload_Delete(Upload_Delete_Info info)
{
string result = string.Empty;
try
{
Model.tblReportArchive list = new Model.tblReportArchive();
using (Model.EntityContext db = new Model.EntityContext())
{
list = (from x in db.tblReportArchive
where x.fldAutoID == info.fldAutoID
select x).ToList().FirstOrDefault();
File.Delete(list.fldPath);
db.tblReportArchive.Remove(list);
db.SaveChanges();
}
result = rule.JsonStr("ok", "", list);
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage Upload_Data(Upload_Data_Info info)
{
string result = string.Empty;
try
{
Model.tblReportArchive list = new Model.tblReportArchive();
list.fldAutoID = 0;
list.fldReport_Name = info.fldReport_Name;
list.fldReport_Type = info.fldReport_Type;
list.fldRName = info.fldRName;
list.fldUserID = info.fldUserID;
list.fldTime = info.fldTime;
list.fldPath = info.fldPath;
list.fldFileName = info.fldFileName;
using (Model.EntityContext db = new Model.EntityContext())
{
db.tblReportArchive.Add(list);
db.SaveChanges();
}
result = rule.JsonStr("ok", "", list);
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage Download_File(string fldAutoID)
{
string result = string.Empty;
try
{
int ID = int.Parse(fldAutoID);
Model.tblReportArchive list = new Model.tblReportArchive();
using (Model.EntityContext db = new Model.EntityContext())
{
list = (from x in db.tblReportArchive
where x.fldAutoID == ID
select x).ToList().FirstOrDefault();
}
var FilePath = HostingEnvironment.MapPath(@"~/App_Data/ReportArchive/") + list.fldPath;
var stream = new FileStream(FilePath, FileMode.Open);
HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.OK);
response.Content = new StreamContent(stream);
response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream");
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")
{
FileName = list.fldFileName
};
return(response);
result = rule.JsonStr("ok", "", list);
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
