public IResponse <bool> AddProduct(AddProductModel model)
{
try
{
var result = ProductRepository.AddProduct(Transformer.AsDatabaseModel(model));
return(Ok <bool>(true));
}
catch (Exception ex)
{
return(Fail <bool>(ex.Message));
}
}
public bool AddUser(UserViewModel model)
{
if (model.Password != null)
{
model.Password = Core.Shared.Encryption.CreateMD5(model.Password);
}
if (UserRepository.Add(Transformer.AsDatabaseModel(model)) != null)
{
return(true);
}
else
{
return(false);
}
}
public UploadFileTypeViewModel AddUploadFileType(UploadFileTypeViewModel model, string rootPath)
{
model.FilesPath = "/Files/" + model.FilesPath;
var path = rootPath + model.FilesPath;
if (Directory.Exists(path))
{
throw new Exception("ამ სახელით დირექტორია უკვე არსებობს");
}
else
{
Directory.CreateDirectory(path);
return(Transformer.AsViewModelModel(UploadFileTypeRepository.Add(Transformer.AsDatabaseModel(model))));
}
}
public bool SaveExcelFileToDatabase(UploadFileViewModel model)
{
try
{
using (var ms = new MemoryStream())
{
model.UploadFile.CopyTo(ms);
model.FileBytes = ms.ToArray();
}
model.UploadDate = DateTime.Now;
model.IsActive = true;
model.IsImported = false;
if (UploadFileRepository.DisableActiveFileStatuses(model.FileTypeID) && UploadFileRepository.SaveExcelFileToDatabase(Transformer.AsDatabaseModel(model)))
{
return(true);
}
return(false);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void ImportMapping(int fileID)
{
var file = UploadFileRepository.Get().Where(m => m.ID == fileID && m.IsActive == true && m.IsImported == false).FirstOrDefault();
if (file != null)
{
using (MemoryStream ms = new MemoryStream(file.UploadFileData))
{
using (ExcelPackage excel = new ExcelPackage(ms))
{
if (excel.Workbook.Worksheets.Count == 0)
{
throw new Exception("File Is Empty");
}
else
{
try
{
List <FileMappingViewModel> fileMapping = new List <FileMappingViewModel>();
var worksheet = excel.Workbook.Worksheets.FirstOrDefault();
var start = worksheet.Dimension.Start;
var end = worksheet.Dimension.End;
for (int row = start.Row + 1; row <= end.Row; row++)
{
fileMapping.Add(new FileMappingViewModel()
{
SheetName = worksheet.Cells[row, 1].Text,
VariableName = worksheet.Cells[row, 2].Text,
Cell = worksheet.Cells[row, 3].Text,
FileTypeID = file.UploadFileTypeID,
VariableTypeID = (int)VariableTypes.Nvarchar
});
}
if (fileMapping.Count == 0)
{
throw new Exception("File Is not Correct");
}
FileMappingRepository.ImportNewMappingData(fileMapping.Select(m => Transformer.AsDatabaseModel(m)).ToList(), file.UploadFileTypeID);
UploadFileRepository.CheckAsImported(file.ID);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
}
else
{
throw new Exception("File Not Found! It's already deactivated or imported!");
}
}
public IEnumerable <UploadFileViewModel> GetFileList()
{
var data = UploadFileRepository.GetUploadFileList().Where(m => m.IsActive == true).ToList();
return(data.Select(m => Transformer.AsDatabaseModel(m)));
}
