public bool InsertIntoFile(MFile objfiles) { StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO tb_file (fileSender, fileAccepter, fileTitle, fileTime, fileContent, path, examine, fileName) VALUES(@FileSender,@FileAccepter,@FileTitle,@FileTime,@FileContent,@FilePath,@FileExamine,@FileName)"); SqlParameter[] param = { SQLDbHelper.GetParameter("@FileSender", SqlDbType.VarChar, 20, "fileSender", objfiles.FileSender), SQLDbHelper.GetParameter("@FileAccepter", SqlDbType.VarChar, 20, "fileAccepter", objfiles.FileAccepter), SQLDbHelper.GetParameter("@FileTitle", SqlDbType.VarChar, 50, "fileTitle", objfiles.FileTitle), SQLDbHelper.GetParameter("@FileTime", SqlDbType.DateTime, "fileTime", objfiles.FileTime), SQLDbHelper.GetParameter("@FileContent", SqlDbType.Text, "fileContent", objfiles.FileContent), SQLDbHelper.GetParameter("@FilePath", SqlDbType.VarChar, 100, "path", objfiles.Path), SQLDbHelper.GetParameter("@FileExamine", SqlDbType.VarChar, 10, "examine", objfiles.Examine), SQLDbHelper.GetParameter("@FileName", SqlDbType.VarChar, 50, "fileName", objfiles.FileName) }; bool is_succeed = SQLDbHelper.ExecuteSql(sb.ToString(), param); if (is_succeed) { return(true); } else { return(false); } }
public DownloadFileChangedEventArgs(MFile kind, string filename, int total, int progressed) { FileKind = kind; FileName = filename; TotalFileCount = total; ProgressedFileCount = progressed; }
/// <summary> ///Delete from this table /// </summary> /// <param name="Id">record number</param> /// <returns></returns> public async Task <SweetAlertExtenstion> DeleteAsync(int Id) { try { var entity = await GetByIdAsync(Id); if (!string.IsNullOrEmpty(entity.BookOrSeet)) { await MFile.Delete(entity.BookOrSeet); } if (!string.IsNullOrEmpty(entity.BookCover)) { await MFile.Delete(entity.BookCover); } DbContext.Remove(entity); await DbContext.SaveChangesAsync(); return(SweetAlertExtenstion.Ok()); } catch { return(SweetAlertExtenstion.Error()); } }
public async Task <int> UpdateProduct(DataLayer.ViewModels.Products.ProductUpdateViewModel vm, IFormFile file) { if (file != null) { if (vm.IndexPic != null) { var WebContent = _hostingEnvironment.WebRootPath; if (vm.IndexPic != "Images/no-Pic.jpg") { System.IO.File.Delete(WebContent + FilePath.Product.GetDescription()); } } vm.IndexPic = await MFile.Save(file, FilePath.Product.GetDescription()); } var model = GetById(vm.Id); if (file == null) { vm.IndexPic = model.IndexPic; } Mapper.Map(vm, model); DbContext.SaveChanges(); return(model.Id); }
public DownloadFile(MFile type, string name, string path, string url) { Type = type; Name = name; Path = path; Url = url; }
public async Task <SweetAlertExtenstion> UpdateAsync(NewsUpdateViewModel model) { try { var entity = await GetByIdAsync(model.Id); entity = (News)Mapper.Map(model, entity, typeof(NewsUpdateViewModel), typeof(News)); #region ذخیره فایل مورد نظر if (model.ImageFile != null) { //حذف فایل قبلی await MFile.Delete(entity.ImageAddress); // ذخیره فایل جدید entity.ImageAddress = await MFile.Save(model.ImageFile, "Uploads/NewsImages"); } #endregion await DbContext.SaveChangesAsync(); return(SweetAlertExtenstion.Ok()); } catch (Exception e) { return(SweetAlertExtenstion.Error()); } }
/// <summary> /// ثبت یک آیتم در جدول مورد نظر /// </summary> /// <param name="model">مدلی که از سمت کلاینت در حال پاس دادن آن هستیم</param> /// <returns></returns> public async Task <SweetAlertExtenstion> UpdateAsync(SlideShowUpdateViewModel model) { try { var entity = Mapper.Map <SlideShow>(model); #region ذخیره فایل مورد نظر if (model.ImageFile != null) { //حذف فایل قبلی MFile.Delete(entity.ImgAddress); // ذخیره فایل جدید entity.ImgAddress = MFile.Save(model.ImageFile, "Uploads/SlideShow"); } #endregion await UpdateAsync(entity); return(SweetAlertExtenstion.Ok()); } catch (Exception e) { return(SweetAlertExtenstion.Error()); } }
public async Task <int> UpdateAsync(ProductPackageUpdateViewModel vm, IFormFile file) { var model = GetById(vm.Id); if (file != null) { if (vm.IndexPic != null) { try { var WebContent = _hostingEnvironment.WebRootPath; System.IO.File.Delete(WebContent + FilePath.productPackage.GetDescription()); } catch (Exception) { return(0); } } vm.IndexPic = await MFile.Save(file, FilePath.productPackage.GetDescription()); } else { vm.IndexPic = model.IndexPic; } Mapper.Map(vm, model); await DbContext.SaveChangesAsync(); return(model.Id); }
public async Task DownloadParallelAsync(DownloadFile[] files, int parallelDegree) { MFile filetype = MFile.Library; if (files.Length > 0) { filetype = files[0].Type; } semaphore = new SemaphoreSlim(parallelDegree, parallelDegree); total = files.Length; progressed = 0; progressEvent = null; var downloadTasks = new List <Task>(files.Length); foreach (var file in files) { await semaphore.WaitAsync().ConfigureAwait(false); var t = Task.Run(() => doDownload(file)); downloadTasks.Add(t); } var download = Task.WhenAll(downloadTasks); await download; //if (progressEvent != null && !progressEvent.IsCompleted) // await progressEvent; }
public DownloadFileChangedEventArgs(MFile kind, bool isDownloader, string?filename, int total, int progressed) { FileKind = kind; FileName = filename; TotalFileCount = total; ProgressedFileCount = progressed; this.IsDownloader = isDownloader; }
private void fire(MFile kind, string name, int total, int progressed) { FileChanged?.Invoke(new DownloadFileChangedEventArgs() { FileKind = kind, FileName = name, TotalFileCount = total, ProgressedFileCount = progressed }); }
public void DeleteFileByFileID(MFile objfiles) { StringBuilder sb = new StringBuilder(); sb.Append("delete from tb_file where fileID=@FileID"); SqlParameter[] param = { SQLDbHelper.GetParameter("@FileID", SqlDbType.Int, 4, "fileID", objfiles.ID) }; SQLDbHelper.ExecuteSql(sb.ToString(), param); }
/// <summary> /// ویرایش یک آیتم /// </summary> /// <param name="model"></param> /// <returns></returns> public async Task <SweetAlertExtenstion> UpdateAsync(SubProjectUpdateViewModel model) { try { var entity = Mapper.Map <SubProject>(model); #region InsertFiles #region Book Or Sheet if (model.BookOrSeetAddress != null) { await MFile.Delete(model.BookOrSeet); entity.BookOrSeet = await MFile.Save(model.BookOrSeetAddress, "Uploads/BookOrSeet"); } #endregion #region Book Cover if (model.BookCoverAddress != null) { await MFile.Delete(model.BookCover); entity.BookCover = await MFile.Save(model.BookCoverAddress, "Uploads/BookCover"); } #endregion #endregion if (model.SubProjectType == DataLayer.SSOT.ProjectTypeSSOT.Sheet) { model.BindingNumber = null; model.BindingType = null; model.BookCoverColor = null; model.BookCoverMaterial = null; model.BookCover = null; } //// TODO //if (model.Size != DataLayer.SSOT.SizeSSOT.Cutsom) //{ // model.Width = null; // model.Height = null; //} Entities.Update(entity); await DbContext.SaveChangesAsync(); return(SweetAlertExtenstion.Ok()); } catch (Exception e) { return(SweetAlertExtenstion.Error()); } }
public async Task <int> CreateAsync(ProductPackageInsertViewModel vm, IFormFile file) { vm.IndexPic = await MFile.Save(file, FilePath.productPackage.GetDescription()); var mapModel = Map(vm); mapModel.IsManager = true; await AddAsync(mapModel); return(mapModel.Id); }
private void l(MFile file, string name, int max, int value) { var e = new DownloadFileChangedEventArgs() { FileKind = file, FileName = name, MaxValue = max, CurrentValue = value }; ChangeFile?.Invoke(e); }
private void l(MFile file, string name, int max, int value) { var e = new DownloadFileChangedEventArgs() { FileKind = file, FileName = name, TotalFileCount = max, ProgressedFileCount = value }; ChangeFile?.Invoke(e); }
public void UpdateFileExaminByFileID(MFile objfiles) { StringBuilder sb = new StringBuilder(); sb.Append("UPDATE tb_file SET examine = @Examine WHERE fileID =@FileID"); SqlParameter[] param = { SQLDbHelper.GetParameter("@Examine", SqlDbType.VarChar, 10, "examine", objfiles.Examine), SQLDbHelper.GetParameter("@FileID", SqlDbType.Int, 4, "fileID", objfiles.ID) }; SQLDbHelper.ExecuteSql(sb.ToString(), param); }
public DataTable SelectAllFilesByExamine(MFile objfiles) { StringBuilder sb = new StringBuilder(); sb.Append("select * from tb_file where examine=@Examine order by fileTime desc"); SqlParameter[] param = { SQLDbHelper.GetParameter("@Examine", SqlDbType.VarChar, 10, "examine", objfiles.Examine) }; DataTable dt = SQLDbHelper.ExecuteDt(sb.ToString(), param); return(dt); }
public DataTable SelectFilesByFileID(MFile objfiles) { StringBuilder sb = new StringBuilder(); sb.Append("select * from tb_file where fileID=@FileID"); SqlParameter[] param = { SQLDbHelper.GetParameter("@FileID", SqlDbType.Int, 4, "fileID", objfiles.ID) }; DataTable dt = SQLDbHelper.ExecuteDt(sb.ToString(), param); return(dt); }
public DataTable SelectAllFilesByAccepter(MFile objfiles) { StringBuilder sb = new StringBuilder(); sb.Append("select * from tb_file where fileAccepter=@FileAccepter order by fileTime desc"); SqlParameter[] param = { SQLDbHelper.GetParameter("@FileAccepter", SqlDbType.VarChar, 20, "fileAccepter", objfiles.FileAccepter) }; DataTable dt = SQLDbHelper.ExecuteDt(sb.ToString(), param); return(dt); }
public DataTable SelectAllFilesByExamineAndAccepter(MFile objfiles) { StringBuilder sb = new StringBuilder(); sb.Append("select * from tb_file where examine=@Examine and fileAccepter=@FileAccepter order by fileTime desc"); OleDbParameter[] param = { OleDbHelper.GetParameter("@Examine", OleDbType.VarWChar, 10, "examine", objfiles.Examine), OleDbHelper.GetParameter("@FileAccepter", OleDbType.VarWChar, 20, "fileAccepter", objfiles.FileAccepter) }; DataTable dt = OleDbHelper.ExecuteDt(sb.ToString(), param); return(dt); }
public static MetaData GetMeta(this MFile mp3File) { var tFile = TagLib.File.Create(mp3File.FullPath); return(new MetaData { Title = tFile.Tag.Title, Album = tFile.Tag.Album, Length = tFile.Properties.Duration, Performer = tFile.Tag.JoinedPerformers, Composer = tFile.Tag.JoinedComposers, Comment = tFile.Tag.Comment, FileName = Path.GetFileNameWithoutExtension(mp3File.FullPath) }); }
/// <summary> /// ثبت یک آیتم در جدول مورد نظر /// </summary> /// <param name="model">مدلی که از سمت کلاینت در حال پاس دادن آن هستیم</param> /// <returns></returns> public async Task <SweetAlertExtenstion> Delete(int Id) { try { var entity = await GetByIdAsync(Id); await MFile.Delete(entity.AddressImg); await DeleteAsync(entity); return(SweetAlertExtenstion.Ok("عملیات با موفقیت انجام شد")); } catch { return(SweetAlertExtenstion.Error()); } }
//public async Task SetUserClaims(string username) //{ // var userinfo = await GetByConditionAsyncTracked(a => a.UserName == username); // var claimsidentity = new List<Claim>() // { // new Claim("FirstName", userinfo.FirstName ?? ""), // new Claim("LastName", userinfo.LastName ?? ""), // new Claim("FullName", userinfo.FirstName + " "+ userinfo.LastName), // new Claim("UserProfile" , userinfo.ProfilePic ?? "/Uploads/UserImage/NoPhoto.jpg") // //... // }; // await _userClaimsRepository.RemoveClamsByUserId(userinfo.Id); // await _userManager.AddClaimsAsync(userinfo, claimsidentity); //} /// <summary> /// ویرایش عکس یک کاربر /// </summary> /// <param name="UserId">شماره کاربری</param> /// <param name="profilePic">عکس جدید کاربر</param> /// <returns></returns> public async Task <SweetAlertExtenstion> UpdateProfilePic(int UserId, IFormFile profilePic) { try { var entity = await GetByIdAsync(UserId); MFile.Delete(entity.ProfilePic); entity.ProfilePic = MFile.Save(profilePic, "Uploads/UserImage"); await DbContext.SaveChangesAsync(); return(SweetAlertExtenstion.Ok("عملیات با موفقیت انجام شد")); } catch { return(SweetAlertExtenstion.Error()); } }
public bool Insert(MFile mFile) { try { using (var connection = new SQLiteConnection(System.IO.Path.Combine(folder, dbFileName))) { connection.DeleteAll <MFile>(); connection.Insert(mFile); return(true); } } catch (SQLiteException ex) { Log.Info("SQLiteEx", ex.Message); return(false); } }
public async Task <int> SubmitProduct(DataLayer.ViewModels.Products.ProductInsertViewModel vm, IFormFile file) { if (file == null) { vm.IndexPic = "Images/no-Pic.jpg"; } else { vm.IndexPic = await MFile.Save(file, FilePath.Product.GetDescription()); } var mapModel = Map(vm); await AddAsync(mapModel); return(mapModel.Id); }
public async Task <SweetAlertExtenstion> InsertCar(CarTransportationInsertViewModel model, IFormFile file) { if (file == null) { model.Pic = "Images/no-Pic.jpg"; } else { model.Pic = await MFile.Save(file, FilePath.Cars.GetDescription()); } var result = model.ToEntity(); await AddAsync(result); return(SweetAlertExtenstion.Ok()); }
/// <summary> /// ثبت یک آیتم در جدول مورد نظر /// </summary> /// <param name="model">مدلی که از سمت کلاینت در حال پاس دادن آن هستیم</param> /// <returns></returns> public async Task <SweetAlertExtenstion> AddAsync(SubProjectInsertViewModel model) { try { var entity = Mapper.Map <SubProject>(model); #region InsertFiles #region Book Or Sheet entity.BookOrSeet = await MFile.Save(model.BookOrSeetAddress, "Uploads/BookOrSeet"); #endregion #region Book Cover if (model.BookCoverAddress != null) { entity.BookCover = await MFile.Save(model.BookCoverAddress, "Uploads/BookCover"); } #endregion #endregion if (entity.SubProjectType == DataLayer.SSOT.ProjectTypeSSOT.Book) { //TODO check .PDF //if (Path.GetExtension(entity.BookOrSeet).ToLower() == "pdf") { string filePath = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot/" + entity.BookOrSeet); PdfReader pdfReader = new PdfReader(filePath); entity.BookPageNumber = pdfReader.NumberOfPages; } } await Entities.AddAsync(entity); await DbContext.SaveChangesAsync(); return(SweetAlertExtenstion.Ok()); } catch (Exception e) { return(SweetAlertExtenstion.Error()); } }
/// <summary> /// 获取全部未接收文件信息自动生成或更新XML文件 /// </summary> public void SelectNotReceivedFilesUpdXml() { DataTable dt = new DataTable(); dt.TableName = "File"; MFile objfiles = new MFile(); objfiles.Examine = "未接收"; dt = files.SelectAllFilesByExamine(objfiles); //实例化一个FileStream对象 FileStream objFs = new FileStream(HttpContext.Current.Server.MapPath("~/Xml/FileInfoXml/NotReceivedFileInfo.xml"), FileMode.Create, FileAccess.Write); DataSet ds = new DataSet(); ds.Tables.Add(dt); //将获取后的数据自动生成或更新xml文件 ds.WriteXml(objFs); //关闭新建对象 objFs.Close(); }
/// <summary> /// ثبت اطلاعات در جدول مورد نظر /// </summary> /// <param name="model">مدلی که باید به این تابع پاس داده شود تا بتوان آن را ذخیره کرد</param> /// <returns></returns> public async Task <SweetAlertExtenstion> Insert(InsertNewsListView model) { try { var entity = Mapper.Map <News>(model); await _newsGroupRepository.AddAsync(new DataLayer.ViewModels.NewsGroup.NewsGroupInsertViewModel { Title = "12" }); #region ذخیره فایل مورد نظر entity.ImageAddress = await MFile.Save(model.ImageFile, "Uploads/NewsImages"); #endregion await _newsGroupRepository.AddAsync(new DataLayer.ViewModels.NewsGroup.NewsGroupInsertViewModel { Title = "13" }); entity.Date = DateTime.Now; var result1 = await _newsGroupRepository.AddAsync(new DataLayer.ViewModels.NewsGroup.NewsGroupInsertViewModel { Title = DateTime.Now.ToString() }); await AddAsync(entity); await _newsGroupRepository.AddAsync(new DataLayer.ViewModels.NewsGroup.NewsGroupInsertViewModel { Title = "14" }); return(SweetAlertExtenstion.Ok()); } catch { return(SweetAlertExtenstion.Error()); } }
private void UploadFile(MFile fileToUpload, bool overwrite) { phUpload.Visible = phMultiUpload.Visible = false; string errStr = "", statusStr = ""; //written into literal at end of method string newFilePath = ""; bool fileExists = FileManagerService.FileExists(fileToUpload.Path + fileToUpload.Name); if (fileExists && !overwrite) { phOverwriteDialog.Visible = true; errStr = "A file with the same name already exists."; //check if ok to overwrite if (FileManagerService.AllowOverwrite()) { FileInMem = fileToUpload; statusStr += "Would you like to overwrite it?"; } else { statusStr += "Overwriting files is not allowed. Rename your file and try again."; btnOverwriteYes.Visible = false; } } else { //ok to upload newFilePath = FileManagerService.SaveFile(fileToUpload); //javascript to load detail if (newFilePath != "") ShowNewDetail(newFilePath); else { errStr = "Upload failed."; statusStr = "Please try again with a different file."; } } //statusMsg.Text = "<p>" + statusStr + "</p>"; if (errStr.IndexOf("<strong") == -1) errStr = "<strong class='alert'>" + errStr + "</strong>"; if (statusStr != "") errStr += "</p><p>" + statusStr; errMsg.Text = errStr; }
private MFile CreateMFile(HtmlInputFile input, string path) { MFile f = new MFile(); f.Name = Path.GetFileName(input.PostedFile.FileName); f.Path = path; f.ReadFileFromStream(input.PostedFile.InputStream); //read file bytes if (!string.IsNullOrEmpty(custom_fields.Value)) { f.Attribs = new Hashtable(); string[] fields = custom_fields.Value.Split(new char[] { ',' }); if (fields.Length >= 1) f.Attribs.Add(fields[0].Substring(0, fields[0].LastIndexOf("|")), tbxCustomField1.Value); if (fields.Length >= 2) f.Attribs.Add(fields[1].Substring(0, fields[1].LastIndexOf("|")), tbxCustomField2.Value); if (fields.Length >= 3) f.Attribs.Add(fields[2].Substring(0, fields[2].LastIndexOf("|")), tbxCustomField3.Value); } return f; }