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