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