public void ProcessRequest(HttpContext context) { string path = "C:/Users/alkes_000/Documents/visual studio 2015/Projects/EnergySimply/EnergySimply/ExcelFile/powertochoose.xlsx"; //var basePath = VirtualPathUtility.GetDirectory(context.Request.Url.AbsolutePath); var basePath = context.Request.Url.ToString(); var bp = basePath.Substring(0, basePath.IndexOf("Handlers")); var fullPath = Path.Combine(bp, @"ExcelFile/powertochoose.xlsx"); //var fullPath = Path.Combine(bp, @"ExcelFile/powertochoose.xlsx"); // Hard coded but you can easily get from url parameters // string path = context.Request["path"]; var file = new FileInfo(path); DocumentDal dal = new DocumentDal(); // You should check for file.Exists ! var savedFileName = "Powertochoose" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"; EnergySavedFile sf = new EnergySavedFile(); sf.CreateDate = DateTime.Now; sf.FileName = savedFileName; var result = dal.SaveFileRecord(sf); //context.Response.Clear(); //context.Response.AddHeader("content-disposition", // string.Format("attachment; filename=\"{0}\"", savedFileName)); //context.Response.AddHeader("content-disposition", "attachment; filename=excelData.xls"); // context.Response.ContentType = "application/vnd.ms-excel"; // context.Response.WriteFile(file.FullName, false); context.Response.ContentType = "text/plain"; context.Response.Write("Hello World"); }
public EnergySavedFile SaveFileRecord(EnergySavedFile file) { try { using (var ctx = new DB_121539_alkeshpatelfEntities()) { ctx.EnergySavedFiles.Add(file); ctx.SaveChanges(); return(file); } } catch (Exception ex) { throw ex; } }