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