public static async Task <File> Upload(HttpPostedFileBase file, FileGroups fileGroup, Controller controller) { try { using (ApplicationDbContext db = new ApplicationDbContext()) { var guid = Guid.NewGuid(); var fileExt = System.IO.Path.GetExtension(file.FileName); var newFileName = guid.ToString(); var newFile = new File { Id = newFileName, Extension = fileExt, Size = file.ContentLength, CreateUserId = controller.User.Identity.GetUserId(), CreateTime = DateTime.Now, }; var destinationFolder = ""; var categoryG = await db.Categories.FindAsync((int)fileGroup); newFile.Categories.Add(categoryG); if (fileExt == ".png" || fileExt == ".jpg" || fileExt == ".gif" || fileExt == ".svg") { var categoryT = await db.Categories.FindAsync((int)FileTypes.Image); newFile.Categories.Add(categoryT); destinationFolder = Properties.Resources.UploadFolder_Image; } db.Files.Add(newFile); await db.SaveChangesAsync(); if (!System.IO.Directory.Exists(controller.Server.MapPath("~/" + destinationFolder))) { System.IO.Directory.CreateDirectory(controller.Server.MapPath("~/" + destinationFolder)); } var newPath = System.IO.Path.Combine(controller.Server.MapPath("~/" + destinationFolder), newFileName + fileExt); file.SaveAs(newPath); //thumb if (fileExt == ".png" || fileExt == ".jpg" || fileExt == ".gif") { using (Image img = Image.FromFile(newPath)) { var thumb = img.CreateThumbnail(new Size(256, Convert.ToInt32((img.Height / (img.Width / 256))))); thumb.Save(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(newPath), "thumb", System.IO.Path.GetFileName(newPath))); } } return(newFile); } } catch (Exception) { return(null); } }
/*public List<ISchemaBase> FindAllByColumn(String ColumnName) * { * this.t * }*/ public override SQLScriptList ToSqlDiff() { var listDiff = new SQLScriptList(); listDiff.Add("USE [" + Name + "]\r\nGO\r\n\r\n", 0, Enums.ScripActionType.UseDatabase); listDiff.AddRange(Assemblies.ToSqlDiff()); listDiff.AddRange(Defaults.ToSqlDiff()); listDiff.AddRange(UserTypes.ToSqlDiff()); listDiff.AddRange(TablesTypes.ToSqlDiff()); listDiff.AddRange(Tables.ToSqlDiff()); listDiff.AddRange(Rules.ToSqlDiff()); listDiff.AddRange(Schemas.ToSqlDiff()); listDiff.AddRange(XmlSchemas.ToSqlDiff()); listDiff.AddRange(Procedures.ToSqlDiff()); listDiff.AddRange(CLRProcedures.ToSqlDiff()); listDiff.AddRange(CLRFunctions.ToSqlDiff()); listDiff.AddRange(FileGroups.ToSqlDiff()); listDiff.AddRange(DDLTriggers.ToSqlDiff()); listDiff.AddRange(Synonyms.ToSqlDiff()); listDiff.AddRange(Views.ToSqlDiff()); listDiff.AddRange(Users.ToSqlDiff()); listDiff.AddRange(Functions.ToSqlDiff()); listDiff.AddRange(Roles.ToSqlDiff()); listDiff.AddRange(PartitionFunctions.ToSqlDiff()); listDiff.AddRange(PartitionSchemes.ToSqlDiff()); listDiff.AddRange(FullText.ToSqlDiff()); return(listDiff); }
private IEnumerable <ResourceDataGroupBase> GetData(VSProject project, IEnumerable <CultureInfo> cultures) { var data = new List <ResourceDataGroupBase>(); IList <ResourceDataGroupBase> uncompletedDataGroups = null; if (ExportDiff) { uncompletedDataGroups = project.GetUncompleteDataGroups(cultures); } IEnumerable <IResourceFileGroup> resxGroups = project.ResxGroups.Values; if (FileGroups != null && FileGroups.Count() > 0) { resxGroups = project.ResxGroups.Values.Intersect(FileGroups); } foreach (IResourceFileGroup group in resxGroups) { IEnumerable <ResourceDataGroupBase> groupDataValues = group.AllData.Values .Where(resxGroup => uncompletedDataGroups == null || uncompletedDataGroups.Contains(resxGroup)); if (IgnoreInternalResources) { groupDataValues = groupDataValues.Where(resxGroup => !resxGroup.Name.StartsWith(">>")); } data.AddRange(groupDataValues); } return(data); }
public override async void Activate(object parameter, NavigationMode navigationMode) { base.Activate(parameter, navigationMode); await _fileService.IsInitialized.Task; ShouldShowPlaceholder = FileGroups.Any(x => x.Files.Any()) ? Visibility.Collapsed : Visibility.Visible; }
public override SQLScriptList ToSqlDiff(ICollection <ISchemaBase> schemas) { var isAzure10 = this.Info.Version == DatabaseInfo.SQLServerVersion.SQLServerAzure10; var listDiff = new SQLScriptList(); var header = $@"/* OpenDBDiff {System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString()} https://github.com/OpenDBDiff/OpenDBDiff Script created by {Environment.UserDomainName}\{Environment.UserName} on {DateTime.Now.ToShortDateString()} at {DateTime.Now.ToLongTimeString()}. Created on: {Environment.MachineName} Source: {SourceInfo?.Database ?? "Unknown"} on {SourceInfo?.Server ?? "Unknown"} Destination: {Info?.Database ?? "Unknown"} on {Info?.Server ?? "Unknown"} ### This script performs actions to change the Destination schema to the Source schema. ### */ "; listDiff.Add(new SQLScript(header, 0, ScriptAction.None)); if (!isAzure10) { listDiff.Add("USE [" + Name + "]\r\nGO\r\n\r\n", 0, ScriptAction.UseDatabase); listDiff.AddRange(Assemblies.ToSqlDiff(schemas)); listDiff.AddRange(UserTypes.ToSqlDiff(schemas)); } listDiff.AddRange(TablesTypes.ToSqlDiff(schemas)); listDiff.AddRange(Tables.ToSqlDiff(schemas)); listDiff.AddRange(Rules.ToSqlDiff(schemas)); listDiff.AddRange(Schemas.ToSqlDiff(schemas)); listDiff.AddRange(XmlSchemas.ToSqlDiff(schemas)); listDiff.AddRange(Procedures.ToSqlDiff(schemas)); if (!isAzure10) { listDiff.AddRange(CLRProcedures.ToSqlDiff(schemas)); listDiff.AddRange(CLRFunctions.ToSqlDiff(schemas)); listDiff.AddRange(FileGroups.ToSqlDiff(schemas)); } listDiff.AddRange(DDLTriggers.ToSqlDiff(schemas)); listDiff.AddRange(Synonyms.ToSqlDiff(schemas)); listDiff.AddRange(Views.ToSqlDiff(schemas)); listDiff.AddRange(Users.ToSqlDiff(schemas)); listDiff.AddRange(Functions.ToSqlDiff(schemas)); listDiff.AddRange(Roles.ToSqlDiff(schemas)); listDiff.AddRange(PartitionFunctions.ToSqlDiff(schemas)); listDiff.AddRange(PartitionSchemes.ToSqlDiff(schemas)); if (!isAzure10) { listDiff.AddRange(FullText.ToSqlDiff(schemas)); } return(listDiff); }
public override string ToSqlAdd() { string sql = "CREATE PARTITION SCHEME " + FullName + "\r\n"; sql += " AS PARTITION " + PartitionFunction + "\r\n"; sql += "TO ("; FileGroups.ForEach(item => sql += "[" + item + "],"); sql = sql.Substring(0, sql.Length - 1); sql += ")\r\nGO\r\n"; return(sql); }
public static async Task <bool> Upload(CreateFileViewModel model, FileGroups fileGroup, Controller controller) { try { using (ApplicationDbContext db = new ApplicationDbContext()) { var guid = Guid.NewGuid(); var fileExt = System.IO.Path.GetExtension(model.File.FileName); var newFileName = guid.ToString(); var newFile = new File { Id = newFileName, Name = model.Name, Description = model.Description, Extension = fileExt, Size = model.File.ContentLength, CreateUserId = controller.User.Identity.GetUserId(), CreateTime = DateTime.Now, }; var destinationFolder = ""; var categoryG = await db.Categories.FindAsync((int)fileGroup); newFile.Categories.Add(categoryG); if (fileExt == ".png" || fileExt == ".jpg") { var categoryT = await db.Categories.FindAsync((int)FileTypes.Image); newFile.Categories.Add(categoryT); destinationFolder = Properties.Resources.UploadFolder_Image; } else { var categoryT = await db.Categories.FindAsync((int)FileTypes.Other); newFile.Categories.Add(categoryT); destinationFolder = Properties.Resources.UploadFolder_Other; } db.Files.Add(newFile); await db.SaveChangesAsync(); var newPath = System.IO.Path.Combine(controller.Server.MapPath("~/" + destinationFolder), newFileName + fileExt); model.File.SaveAs(newPath); return(true); } } catch (Exception) { return(false); } }
private async void DeleteFile(BindableStorageFile item) { FileService.FileLocation location = _fileService.GetFileLocation(item); await _fileService.DeleteFileAsync((StorageFile)item.BackingFile, location); if (item == ActiveFile) { ActiveFile = null; } ShouldShowPlaceholder = FileGroups.Any(x => x.Files.Any()) ? Visibility.Collapsed : Visibility.Visible; }
private async Task <dynamic> upload(HttpPostedFileBase file, FileGroups fileGroup, string imagesFolderPath) { var newFile = await Uploader.Upload(file, fileGroup, this); var result = new { oldFileName = file.FileName, newFileName = newFile.Id, ext = newFile.Extension, link = imagesFolderPath + newFile.Id + newFile.Extension, }; return(result); }
public MainViewModel(IFileService fileService, INavigationServiceEx navService) : base(navService) { _fileService = fileService; _narrowNumberScope.Names.Add(new InputScopeName(InputScopeNameValue.Number)); _narrowDefaultScope.Names.Add(new InputScopeName(InputScopeNameValue.Default)); _wideNumberScope.Names.Add(new InputScopeName(InputScopeNameValue.Number)); _wideDefaultScope.Names.Add(new InputScopeName(InputScopeNameValue.Default)); CurrentNarrowInputScope = _narrowNumberScope; CurrentWideInputScope = _wideNumberScope; FileGroups.Add(new FileCollection(Constants.ROAMED_FILES_TITLE, _fileService.RoamedFiles, FileService.FileLocation.Roamed)); FileGroups.Add(new FileCollection(Constants.LOCAL_FILES_TITLE, _fileService.LocalFiles, FileService.FileLocation.Local)); }
public RISEmulator() { // // Stored files options. // fileGroups = new FileGroups("RIS Emulator"); validationResultsFileGroup = new ValidationResultsFileGroup(); this.validationResultsFileGroup.DefaultFolder = "Results"; this.fileGroups.Add(validationResultsFileGroup); this.fileGroups.CreateDirectories(); Initialize(); // Save the config so next time no attempt will be made to again try to load the same settings // wlConfig.Serialize(); dataDirectory = Directory.GetCurrentDirectory(); modeOfRsp = true; }
public override string ToSql() { string sql = ""; sql += FileGroups.ToSql(); sql += Schemas.ToSql(); sql += XmlSchemas.ToSql(); sql += Rules.ToSql(); sql += UserTypes.ToSql(); sql += Assemblies.ToSql(); sql += Tables.ToSql(); sql += Functions.ToSql(); sql += Procedures.ToSql(); sql += CLRProcedures.ToSql(); sql += CLRFunctions.ToSql(); sql += DDLTriggers.ToSql(); sql += Synonyms.ToSql(); sql += Views.ToSql(); sql += Users.ToSql(); sql += PartitionFunctions.ToSql(); sql += FullText.ToSql(); return(sql); }
private async Task OpenFile(StorageFile file) { bool isValid = await _fileService.ValidateFileAsync(file); if (!isValid) { MessageDialog dialog = new MessageDialog("The file you tried to open was not formatted correctly. Are you sure it's a two-column comma-delimited file?", "Unable to read file"); await dialog.ShowAsync(); return; } AddFileDialogOutput output = await ShowAddFileDialog(file.Name); if (output == null) { return; } string contents = await FileIO.ReadTextAsync(file); ActiveFile = await _fileService.SaveAndEncryptFileAsync(contents, output.FileName, output.Password); ShouldShowPlaceholder = FileGroups.Any(x => x.Files.Any()) ? Visibility.Collapsed : Visibility.Visible; _codeDictionary = await GetCodes(output.Password); }
private void InsertForm() { string new_filenameCH = string.Empty; string new_filenameRG = string.Empty; string new_filenameGU = string.Empty; if (fuChk.PostedFile.ContentLength != 0) { string original_filename = Path.GetFileName(fuChk.PostedFile.FileName); new_filenameCH = Guid.NewGuid().ToString() + Path.GetExtension(original_filename); string new_filepath = Server.MapPath("~/Files/checklists/" + new_filenameCH); fuChk.PostedFile.SaveAs(new_filepath); ViewState["CH"] = new_filenameCH; } if (fuRg.PostedFile.ContentLength != 0) { string original_filename = Path.GetFileName(fuRg.PostedFile.FileName); new_filenameRG = Guid.NewGuid().ToString() + Path.GetExtension(original_filename); string new_filepath = Server.MapPath("~/Files/regular/" + new_filenameRG); fuRg.PostedFile.SaveAs(new_filepath); ViewState["RG"] = new_filenameRG; } if (fuGu.PostedFile.ContentLength != 0) { string original_filename = Path.GetFileName(fuGu.PostedFile.FileName); new_filenameGU = Guid.NewGuid().ToString() + Path.GetExtension(original_filename); string new_filepath = Server.MapPath("~/Files/guideline/" + new_filenameGU); fuGu.PostedFile.SaveAs(new_filepath); ViewState["GU"] = new_filenameGU; } FileGroups fg = new FileGroups() { FileGroupTitle = txtFileGroupName.Text }; db.FileGroups.AddObject(fg); db.SaveChanges(); Files p = new Files() { CHName = new_filenameCH, GUName = new_filenameGU, RGName = new_filenameRG, FileGroupID = fg.FileGroupID, }; db.Files.AddObject(p); db.SaveChanges(); }
public override SQLScriptList ToSqlDiff(List <ISchemaBase> schemas) { var isAzure10 = this.Info.Version == DatabaseInfo.VersionTypeEnum.SQLServerAzure10; var listDiff = new SQLScriptList(); listDiff.Add(new SQLScript(String.Format(@"/* 数据库差异脚本 脚本创建于: {1}\{2} 时间: {3} {4} 创建人:{5} 参考数据库:{6} 地址:{7} 目标数据库:{8} 地址:{9} */ ", System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString(), Environment.UserDomainName, Environment.MachineName, DateTime.Now.ToShortDateString(), DateTime.Now.ToLongTimeString(), Environment.UserName, SourceInfo != null ? SourceInfo.Database : "Uknown", SourceInfo != null ? SourceInfo.Server : "Uknown", Info != null ? Info.Database : "Uknown", Info != null ? Info.Server : "Uknown", 0), 0, Enums.ScripActionType.None)); if (!isAzure10) { listDiff.Add("USE [" + Name + "]\r\nGO\r\n\r\n", 0, Enums.ScripActionType.UseDatabase); listDiff.AddRange(Assemblies.ToSqlDiff(schemas)); listDiff.AddRange(UserTypes.ToSqlDiff(schemas)); } listDiff.AddRange(TablesTypes.ToSqlDiff(schemas)); listDiff.AddRange(Tables.ToSqlDiff(schemas)); listDiff.AddRange(Rules.ToSqlDiff(schemas)); listDiff.AddRange(Schemas.ToSqlDiff(schemas)); listDiff.AddRange(XmlSchemas.ToSqlDiff(schemas)); listDiff.AddRange(Procedures.ToSqlDiff(schemas)); if (!isAzure10) { listDiff.AddRange(CLRProcedures.ToSqlDiff(schemas)); listDiff.AddRange(CLRFunctions.ToSqlDiff(schemas)); listDiff.AddRange(FileGroups.ToSqlDiff(schemas)); } listDiff.AddRange(DDLTriggers.ToSqlDiff(schemas)); listDiff.AddRange(Synonyms.ToSqlDiff(schemas)); listDiff.AddRange(Views.ToSqlDiff(schemas)); listDiff.AddRange(Users.ToSqlDiff(schemas)); listDiff.AddRange(Functions.ToSqlDiff(schemas)); listDiff.AddRange(Roles.ToSqlDiff(schemas)); listDiff.AddRange(PartitionFunctions.ToSqlDiff(schemas)); listDiff.AddRange(PartitionSchemes.ToSqlDiff(schemas)); if (!isAzure10) { listDiff.AddRange(FullText.ToSqlDiff(schemas)); } return(listDiff); }
public override SQLScriptList ToSqlDiff(List <ISchemaBase> schemas) { var isAzure10 = this.Info.Version == DatabaseInfo.VersionTypeEnum.SQLServerAzure10; var listDiff = new SQLScriptList(); listDiff.Add(new SQLScript(String.Format(@"/* Open DBDiff {0} http://opendbiff.codeplex.com/ Script created by {1}\{2} on {3} at {4}. Created on: {5} Source: {6} on {7} Destination: {8} on {9} */ ", System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString(), Environment.UserDomainName, Environment.UserName, DateTime.Now.ToShortDateString(), DateTime.Now.ToLongTimeString(), Environment.MachineName, SourceInfo != null ? SourceInfo.Database : "Uknown", SourceInfo != null ? SourceInfo.Server : "Uknown", Info != null ? Info.Database : "Uknown", Info != null ? Info.Server : "Uknown", 0), 0, Enums.ScripActionType.None)); if (!isAzure10) { listDiff.Add("USE [" + Name + "]\r\nGO\r\n\r\n", 0, Enums.ScripActionType.UseDatabase); listDiff.AddRange(Assemblies.ToSqlDiff(schemas)); listDiff.AddRange(UserTypes.ToSqlDiff(schemas)); } listDiff.AddRange(TablesTypes.ToSqlDiff(schemas)); listDiff.AddRange(Tables.ToSqlDiff(schemas)); listDiff.AddRange(Rules.ToSqlDiff(schemas)); listDiff.AddRange(Schemas.ToSqlDiff(schemas)); listDiff.AddRange(XmlSchemas.ToSqlDiff(schemas)); listDiff.AddRange(Procedures.ToSqlDiff(schemas)); if (!isAzure10) { listDiff.AddRange(CLRProcedures.ToSqlDiff(schemas)); listDiff.AddRange(CLRFunctions.ToSqlDiff(schemas)); listDiff.AddRange(FileGroups.ToSqlDiff(schemas)); } listDiff.AddRange(DDLTriggers.ToSqlDiff(schemas)); listDiff.AddRange(Synonyms.ToSqlDiff(schemas)); listDiff.AddRange(Views.ToSqlDiff(schemas)); listDiff.AddRange(Users.ToSqlDiff(schemas)); listDiff.AddRange(Functions.ToSqlDiff(schemas)); listDiff.AddRange(Roles.ToSqlDiff(schemas)); listDiff.AddRange(PartitionFunctions.ToSqlDiff(schemas)); listDiff.AddRange(PartitionSchemes.ToSqlDiff(schemas)); if (!isAzure10) { listDiff.AddRange(FullText.ToSqlDiff(schemas)); } return(listDiff); }
private async Task <List <dynamic> > uploads(IEnumerable <HttpPostedFileBase> files, FileGroups fileGroup, string imagesFolderPath) { var result = new List <dynamic>(); foreach (var file in files) { var newFile = await Uploader.Upload(file, fileGroup, this); if (newFile != null) { var resultItem = new { oldFileName = file.FileName, newFileName = newFile.Id, ext = newFile.Extension, link = imagesFolderPath + newFile.Id + newFile.Extension }; result.Add(resultItem); } } return(result); }