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