public void DeleteUploadedFile(long id) { WebInitializer.Initialize(); using (var db = new DBUploadFilesDataContext(WebSpecificInstances.DbFactory.CreateConnection())) { var row = db.SYS_FileUploads.FirstOrDefault(r => r.id == id && r.PersonSID == Tools.Security.User.GetSID()); if (row != null) { db.SYS_FileUploads.DeleteOnSubmit(row); db.SubmitChanges(); } } }
protected override void InitInsertValues(System.Collections.IDictionary values, ListControlItem item) { base.InitInsertValues(values, item); WebInitializer.Initialize(); using (var db = new DBUploadFilesDataContext(SpecificInstances.DbFactory.CreateConnection())) { var row = db.SYS_FileUploads. FirstOrDefault(r => r.id == Convert.ToInt64(item.Value) && r.PersonSID == User.GetSID()); if (row != null) { values[FileDataFieldName] = row.data; values[FileFieldName] = row.dataFileName; } } }
private string UploadFile(byte[] buffer, string fileName, string subsystem, string tableId) { WebInitializer.Initialize(); using (var db = new DBUploadFilesDataContext(WebSpecificInstances.DbFactory.CreateConnection())) { var sfu = new SYS_FileUpload { data = buffer, UploadDate = DateTime.Now, PersonSID = Tools.Security.User.GetSID(), SubSystemName = subsystem, dataFileName = fileName, }; db.SYS_FileUploads.InsertOnSubmit(sfu); db.SubmitChanges(); var result = GetResult(fileName, tableId, sfu); return(new JavaScriptSerializer().Serialize(result)); } }