public List<CategoryDTO> GetAllCategory() { List<CategoryDTO> list = new List<CategoryDTO>(); try { SqlDataReader reader = ConnectionManager.GetCommand("SP0201ALL", new Dictionary<string, SqlDbType>() { }, new List<object>() { }).ExecuteReader(); while (reader.Read()) { CategoryDTO categoryDto = new CategoryDTO(); categoryDto.CategoryId = reader["CategoryID"].ToString(); categoryDto.CategoryName = reader["CategoryName"].ToString(); categoryDto.CreatedDate = (DateTime)reader["CreatedDate"]; categoryDto.UpdatedDate = (DateTime)reader["UpdatedDate"]; list.Add(categoryDto); } reader.Close(); } catch (Exception e) { Log.Error("Error at AuthorDAO - GetAllCategory", e); return null; } return list; }
public CategoryDTO GetCategoryById(String categoryId) { CategoryDTO categoryDto = null; try { SqlDataReader reader = ConnectionManager.GetCommand("SP0201CI", new Dictionary<string, SqlDbType>() { { "@Param1", SqlDbType.NVarChar } }, new List<object>() { categoryId }).ExecuteReader(); if (reader.Read()) { categoryDto = new CategoryDTO(); categoryDto.CategoryId = reader["CategoryID"].ToString(); categoryDto.CategoryName = reader["CategoryName"].ToString(); categoryDto.CreatedDate = (DateTime)reader["CreatedDate"]; categoryDto.UpdatedDate = (DateTime)reader["UpdatedDate"]; } } catch (Exception e) { Log.Error("Error at CategoryDAO - GetCategoryByID", e); return null; } return categoryDto; }
public static CategoryDTO CreateFromCategory(Category category) { CategoryDTO categoryDTO = new CategoryDTO(); categoryDTO.CategoryID = category.CategoryID; categoryDTO.Name = category.CategoryName; categoryDTO.Description = category.Description; return categoryDTO; }
public ActionResult Edit(int id) { CategoriesDAL c = new CategoriesDAL(); CategoryDTO dto = new CategoryDTO(); dto = c.GetCategoryByID(id); CategoryModel model = new CategoryModel(); model.id_categ = dto.id_categ; model.categ_name = dto.categ_name; return View(model); }
protected void Setup() { CategoryDTO category = new CategoryDTO(); PropertyInfo propertyInfo = category.GetType().GetProperty("Name"); if (propertyInfo == null) return; var attr = (ColumnAttribute)Attribute.GetCustomAttribute(propertyInfo, typeof(ColumnAttribute)); if(attr == null) return; this._metaDataColumn = new MetaDataColumn(propertyInfo,attr); }
public CatalogueDTO GetCatalogueById(String isbn) { CatalogueDTO catalogueDto = null; try { SqlDataReader reader = ConnectionManager.GetCommand("SP0101ISBN", new Dictionary<string, SqlDbType>() { { "@Param1", SqlDbType.NVarChar } }, new List<object>() { isbn }).ExecuteReader(); if (reader.Read()) { catalogueDto = new CatalogueDTO(); PublisherDTO publisherDto = new PublisherDTO(); CategoryDTO categoryDto = new CategoryDTO(); catalogueDto.ISBN = reader["ISBN"].ToString(); catalogueDto.Title = reader["Title"].ToString(); // add code for get data publisherDto.PublisherId = int.Parse(reader["PublisherID"].ToString()); catalogueDto.Publisher = publisherDto; catalogueDto.ShortDescription = reader["ShortDescription"].ToString(); // add code for get data categoryDto.CategoryId = reader["CategoryID"].ToString(); catalogueDto.Category = categoryDto; catalogueDto.Language = reader["Language"].ToString(); catalogueDto.Year = int.Parse(reader["Year"].ToString()); catalogueDto.ExpandLimit = int.Parse(reader["ExpandLimit"].ToString()); catalogueDto.ExpandDateLimit = int.Parse(reader["ExpandDateLimit"].ToString()); catalogueDto.NumberOfCopies = int.Parse(reader["NumberOfCopies"].ToString()); catalogueDto.AvailableCopies = int.Parse(reader["AvailableCopies"].ToString()); catalogueDto.Price = float.Parse(reader["Price"].ToString()); catalogueDto.Image = reader["Image"].ToString(); catalogueDto.HitTime = int.Parse(reader["HitTime"].ToString()); catalogueDto.RentalTime = int.Parse(reader["RentalTime"].ToString()); catalogueDto.CreatedDate = (DateTime) reader["CreatedDate"]; catalogueDto.UpdatedDate = (DateTime) reader["UpdatedDate"]; } reader.Close(); } catch (Exception e) { Log.Error("Error at CatalogueDAO - GetCatalogueByID", e); return null; } return catalogueDto; }
public void IntegraCategoria() { try { Console.WriteLine("Início do exemplo de integração de categoria"); int nIdCategoria = 100; //Id da categoria que queremos inserir no exemplo //Primeiro buscamos a categoria para ver se esta já existe na VTEX. Esta busca é muito importante //para que seja mantido novos dados que venham a existir, fazendo com que seja necessária a alteração //apenas dos campos que realmente devem ser preenchidos CategoryDTO objCategory = this.vtexService.CategoryGet(nIdCategoria); if (objCategory == null) { //Instanciamos um objeto do tipo CategoryDTO caso esta categoria não exista na VTEX objCategory = new CategoryDTO(); } objCategory.Id = nIdCategoria; objCategory.FatherCategoryId = null; //Nesse caso está sendo criado um departamento, que é uma categoria sem categoria pai objCategory.Name = "Nome da categoria"; objCategory.Title = "Título da categoria"; objCategory.Description = "Descrição da categoria"; objCategory.IsActive = true; //Enviando os dados para serem inseridos ou atualizados. Note que o retorno padrão dos métodos InsertUpdate //é o próprio objeto enviado. Isto ocorre para que se possa recuperar ids auto-incrementos ou mesmo para verificação //dos dados por parte do integrador. objCategory = this.vtexService.CategoryInsertUpdate(objCategory); //Mensagem de sucesso Console.WriteLine("Categoria inserida com sucesso"); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } finally { Console.WriteLine("Fim do exemplo de integração de categoria"); Console.ReadKey(); } }
public static List<CategoryDTO> GetAllCategory() { List<CategoryDTO> rs = new List<CategoryDTO>(); string query = "select * from db3c04c35a9c6b45918ba3a551005e16ee.category"; DataTable dt = DataProvider.ExecuteQuery(query); for (int i = 0; i < dt.Rows.Count; i++) { CategoryDTO sp = new CategoryDTO(); sp.ID = (string)dt.Rows[i]["ID"]; sp.Name = (string)dt.Rows[i]["Name"]; rs.Add(sp); } return rs; }
public ActionResult Add(CategoryModel model) { CategoriesDAL category = new CategoriesDAL(); CategoryDTO dto = new CategoryDTO(); dto.categ_name = model.categ_name; try { if (ModelState.IsValid) { category.insertCategory(dto); return RedirectToAction("Index"); } } catch (DataException) { //Log the error (add a variable name after DataException) ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator."); } return View(model); }
public int DeleteCategory(CategoryDTO category) { try { ConnectionManager.GetCommand("SP0204", new Dictionary<string, SqlDbType>() { {"@Param1", SqlDbType.NVarChar} }, new List<object>() { category.CategoryId }).ExecuteNonQuery(); } catch (Exception e) { Log.Error("Error at CategoryDAO - DeleteCategory", e); return 0; } return 1; }
public CategoryOut(InventoryDBContext context, CategoryDTO categoryDTO) : base(categoryDTO) { }
public async Task Update(CategoryDTO categoryDto) { var categoryEntity = _mapper.Map <Category>(categoryDto); await _categoryRepository.UpdateAsync(categoryEntity); }
public Task UpdateAsync(CategoryDTO model) { throw new NotImplementedException(); }
public Int32 SaveCategory(CategoryDTO category) { using (DelightServiceClient service = new DelightServiceClient()) { return service.SaveCategory(category); } }
public IEnumerable <ProductDTO> GetByCategory(CategoryDTO category) { return(_productMapper.Map <IQueryable <Product>, IEnumerable <ProductDTO> >(_dbcontext.Products.GetByCondition(p => p.CategoryId == category.Id))); }
public int InsertCategory(CategoryDTO category) { CategoryDAO dao = new CategoryDAO(); return dao.InsertCategory(category); }
public ActionResult AddProduct(ProductVM model, HttpPostedFileBase file) { //Check model state if (!ModelState.IsValid) { using (Db db = new Db()) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); return(View(model)); } } //Make sure productName is unique using (Db db = new Db()) { if (db.Products.Any(x => x.Name == model.Name)) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); ModelState.AddModelError("", "That model name is taken"); return(View(model)); } } //Declare product id int id; //init and save ProductDTO using (Db db = new Db()) { ProductDTO product = new ProductDTO(); product.Name = model.Name; product.Slug = model.Name.Replace(" ", "-").ToLower(); product.Description = model.Description; product.Price = model.Price; product.CategoryId = model.CategoryId; CategoryDTO catDTO = db.Categories.FirstOrDefault(x => x.Id == model.CategoryId); model.CategoryName = catDTO.Name; db.Products.Add(product); db.SaveChanges(); //Get the Id id = product.Id; } //Set tempData messsage TempData["SM"] = "You have added a product!"; #region Upload Image //create necessary directories var originalDirectory = new DirectoryInfo(string.Format("{0}Images\\Uploads", Server.MapPath(@"\"))); //check if a file was updated var pathString1 = Path.Combine(originalDirectory.ToString(), "Products"); var pathString2 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString()); var pathString3 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Thumbs"); var pathString4 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Gallery"); var pathString5 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Gallery\\Thumbs"); if (!Directory.Exists(pathString1)) { Directory.CreateDirectory(pathString1); } if (!Directory.Exists(pathString2)) { Directory.CreateDirectory(pathString2); } if (!Directory.Exists(pathString3)) { Directory.CreateDirectory(pathString3); } if (!Directory.Exists(pathString4)) { Directory.CreateDirectory(pathString4); } if (!Directory.Exists(pathString5)) { Directory.CreateDirectory(pathString5); } if (file != null && file.ContentLength > 0) { //Get file extension string ext = file.ContentType.ToLower(); //Verify extension if (ext != "image/jpg" && ext != "image/jpeg" && ext != "image/pjpeg" && ext != "image/gif" && ext != "image/x-png" && ext != "image/png") { using (Db db = new Db()) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); ModelState.AddModelError("", "The image was not upload. Wrong image extension!"); return(View(model)); } } //Init image name string imageName = file.FileName; //Save image name to DTO using (Db db = new Db()) { ProductDTO dto = db.Products.Find(id); dto.ImageName = imageName; db.SaveChanges(); } //Set original and thumb image paths var path = string.Format("{0}\\{1}", pathString2, imageName); var path2 = string.Format("{0}\\{1}", pathString3, imageName); //Save original file.SaveAs(path); //Create and save thumb WebImage img = new WebImage(file.InputStream); img.Resize(200, 200); img.Save(path2); } #endregion //Redirect return(RedirectToAction("AddProduct")); }
private string BuildInsertCategoryQuery(Guid guid, CategoryDTO category) { return(string.Format(@"INSERT INTO Book_Category (category_id, title, description) VALUES ('{0}', '{1}', '{2}')", guid, category.Title, category.Description)); }
public ActionResult EditProduct(ProductVM model, HttpPostedFileBase uploadPhoto, HttpPostedFileBase uploadPDF) { // Get product id int id = model.Id; // Populate categories select list and gallery images using (TicketAppDB db = new TicketAppDB()) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); } //model.GalleryImages = Directory.EnumerateFiles(Server.MapPath("~/Images/Uploads/Products/" + id + "/Gallery/Thumbs")) // .Select(fn => Path.GetFileName(fn)); // Check model state if (!ModelState.IsValid) { return(View(model)); } // Make sure product name is unique using (TicketAppDB db = new TicketAppDB()) { if (db.Products.Where(x => x.Id != id).Any(x => x.Name == model.Name)) { ModelState.AddModelError("", "That product name is taken!"); return(View(model)); } } using (TicketAppDB db = new TicketAppDB()) { if (uploadPhoto != null && uploadPhoto.ContentLength > 0) { var deleteCommand = "DELETE FROM tblPhoto WHERE ProductId = " + id + ";"; DbConnection(); using (SqlCommand cmd = new SqlCommand(deleteCommand, con)) { con.Open(); cmd.ExecuteNonQuery(); con.Close(); } var photo = new PhotoDTO { Name = System.IO.Path.GetFileName(uploadPhoto.FileName), photoType = photoType.Picture, ContentType = uploadPhoto.ContentType, ProductId = id }; string photoext = Path.GetExtension(photo.Name); var strings = new List <string> { ".png", ".jpeg", ".gif", ".jpg" }; bool contains = strings.Contains(photoext, StringComparer.OrdinalIgnoreCase); if (!contains) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); ModelState.AddModelError("", "That photo was not uploaded - wrong image extension."); return(View(model)); } using (var reader2 = new System.IO.BinaryReader(uploadPhoto.InputStream)) { photo.Data = reader2.ReadBytes(uploadPhoto.ContentLength); } model.Photos = new List <PhotoDTO> { photo }; db.Photos.Add(photo); db.SaveChanges(); } } using (TicketAppDB db = new TicketAppDB()) { if (uploadPDF != null && uploadPDF.ContentLength > 0) { var deleteCommand = "DELETE FROM tblPdf WHERE ProductId = " + id + ";"; DbConnection(); using (SqlCommand cmd = new SqlCommand(deleteCommand, con)) { con.Open(); cmd.ExecuteNonQuery(); con.Close(); } var invoice = new PdfDTO { Name = System.IO.Path.GetFileName(uploadPDF.FileName), PdfType = PDFType.Invoice, ContentType = uploadPDF.ContentType, ProductId = id }; string pdfext = Path.GetExtension(invoice.Name); if (!pdfext.Equals(".pdf", StringComparison.OrdinalIgnoreCase)) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); ModelState.AddModelError("", "That pdf was not uploaded - wrong Pdf extension."); return(View(model)); } using (var reader = new System.IO.BinaryReader(uploadPDF.InputStream)) { invoice.Data = reader.ReadBytes(uploadPDF.ContentLength); } model.Pdfs = new List <PdfDTO> { invoice }; db.Pdfs.Add(invoice); db.SaveChanges(); } } PdfDTO pdfs = new PdfDTO(); PhotoDTO images = new PhotoDTO(); string pdfsName; string imagesName; using (TicketAppDB db = new TicketAppDB()) { pdfs = db.Pdfs.Where(x => x.ProductId == id).FirstOrDefault(); pdfsName = pdfs.Name; images = db.Photos.Where(x => x.ProductId == id).FirstOrDefault(); imagesName = images.Name; } if (uploadPDF != null) { pdfsName = uploadPDF.FileName; } if (uploadPhoto != null) { imagesName = uploadPhoto.FileName; } // Update product string name = ""; using (TicketAppDB db = new TicketAppDB()) { ProductDTO dto = db.Products.Find(id); dto.Name = model.Name; dto.Slug = model.Name.Replace(" ", "-").ToLower(); dto.Description = model.Description; dto.ReservationDate = model.ReservationDate; dto.Verified = model.Verified; dto.PdfName = pdfsName; dto.ImageName = imagesName; dto.Price = model.Price; dto.CategoryId = model.CategoryId; name = model.Name; CategoryDTO catDTO = db.Categories.FirstOrDefault(x => x.Id == model.CategoryId); //dto.CategoryName = catDTO.Name; db.SaveChanges(); } // Set TempData message TempData["SM"] = "You have edited '" + name + "'!"; // Redirect return(RedirectToAction("Index", "Dashboard")); }
public ActionResult EditProduct(ProductVM model, HttpPostedFileBase file) { //Получение id продукта int id = model.Id; //Заполнение списка ктегориями и изображениями using (Db db = new Db()) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); } model.GalleryImages = Directory .EnumerateFiles(Server.MapPath("~/Images/Uploads/Products/" + id + "/Gallery/Small")) .Select(fn => Path.GetFileName(fn)); //Проверка модели на валидность if (!ModelState.IsValid) { return(View(model)); } //Проверка имени продукта на уникальность using (Db db = new Db()) { if (db.Products.Where(x => x.Id != id).Any(x => x.Name == model.Name)) { ModelState.AddModelError("", "Это название рекламы занято"); return(View(model)); } } //Обновление продукта using (Db db = new Db()) { ProductDTO dto = db.Products.Find(id); dto.Name = model.Name; dto.Slug = model.Name.Replace(" ", "-").ToLower(); dto.Description = model.Description; dto.Price = model.Price; dto.CategoryId = model.CategoryId; dto.ImageName = model.ImageName; CategoryDTO catDTO = db.Categories.FirstOrDefault(x => x.Id == model.CategoryId); //Присваивание текущей категории модели dto.CategoryName = catDTO.Name; db.SaveChanges(); } //Установка сообщения в TempData TempData["M"] = "Вы изменили рекламу"; //Логика обработки изображений #region Image Upload //Проверка загрузки файла if (file != null && file.ContentLength > 0) { //Получение расширения файла string ext = file.ContentType.ToLower(); //Проверка расширения if (ext != "image/jpg" && ext != "image/png" && ext != "image/jpeg" && ext != "image/pjpeg" && ext != "image/gif" && ext != "image/x-png") { using (Db db = new Db()) { ModelState.AddModelError("", "Картинка не загружена. Недопустимое расширение."); return(View(model)); } } //Установка путей загрузки var originalDirectory = new DirectoryInfo(string.Format($"{Server.MapPath(@"\")}Images\\Uploads")); var pathString1 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString()); var pathString2 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Small"); //Удаление существующих путей и директорий DirectoryInfo di1 = new DirectoryInfo(pathString1); DirectoryInfo di2 = new DirectoryInfo(pathString2); //удаление в основной директории foreach (var file2 in di1.GetFiles()) { file2.Delete(); } //Удаление цменьшенных изображений foreach (var file3 in di1.GetFiles()) { file3.Delete(); } //Сохранение имени изображения string imageName = file.FileName; using (Db db = new Db()) { ProductDTO dto = db.Products.Find(id); dto.ImageName = imageName; db.SaveChanges(); } //Сохранение оригинала и уменьшенной версии var path = string.Format($"{pathString1}\\{imageName}"); //к оригинальному изображению var path2 = string.Format($"{pathString2}\\{imageName}"); //к уменьшенному //Сохранение оригинального изображения file.SaveAs(path); //Создание и сохранение уменьшенной картинки WebImage img = new WebImage(file.InputStream); img.Resize(200, 200).Crop(1, 1); img.Save(path2); } #endregion //Переадресация пользователя return(RedirectToAction("EditProduct")); }
public ActionResult AddProduct(ProductVM model, HttpPostedFileBase file) { //Проверка модели на валидность if (!ModelState.IsValid) { using (Db db = new Db()) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); return(View(model)); } } //Проверка имени продуктa на уникальность using (Db db = new Db()) { if (db.Products.Any(x => x.Name == model.Name)) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); ModelState.AddModelError("", "Такое название рекламы уже существует."); return(View(model)); } } //Объявление переменной ProductId int id; //Инициализация и сохранение модели на основе ProductDTO using (Db db = new Db()) { ProductDTO product = new ProductDTO(); product.Name = model.Name; product.Slug = model.Name.Replace(" ", "-").ToLower();; product.Description = model.Description; product.Price = model.Price; product.CategoryId = model.CategoryId; CategoryDTO catDTO = db.Categories.FirstOrDefault(x => x.Id == model.CategoryId); product.CategoryName = catDTO.Name; db.Products.Add(product); db.SaveChanges(); id = product.Id; } //Вывод сообщения в TempData TempData["M"] = "Вы добавили рекламу"; #region Upload Image //Создание ссылок на директории var originalDirectory = new DirectoryInfo(string.Format($"{Server.MapPath(@"\")}Images\\Uploads")); var pathString1 = Path.Combine(originalDirectory.ToString(), "Products"); var pathString2 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString()); var pathString3 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Small"); var pathString4 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Gallery"); var pathString5 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Gallery\\Small"); //Проверка на существование директорий, создание если нужно if (!Directory.Exists(pathString1)) { Directory.CreateDirectory(pathString1); } if (!Directory.Exists(pathString2)) { Directory.CreateDirectory(pathString2); } if (!Directory.Exists(pathString3)) { Directory.CreateDirectory(pathString3); } if (!Directory.Exists(pathString4)) { Directory.CreateDirectory(pathString4); } if (!Directory.Exists(pathString5)) { Directory.CreateDirectory(pathString5); } //Проверка на загрузку файла if (file != null && file.ContentLength > 0) { //Получение расширения файла string ext = file.ContentType.ToLower(); //Проверка расширения файла if (ext != "image/jpg" && ext != "image/png" && ext != "image/jpeg" && ext != "image/pjpeg" && ext != "image/gif" && ext != "image/x-png") { using (Db db = new Db()) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); ModelState.AddModelError("", "Картинка не загружена. Недопустимое расширение."); return(View(model)); } } //Объявление переменной с именем изображения string imageName = file.FileName; //Сохранение имени в модель DTO using (Db db = new Db()) { ProductDTO dto = db.Products.Find(id); dto.ImageName = imageName; db.SaveChanges(); } //Назначение пути к оригинальному и уменьшенному изображению var path = string.Format($"{pathString2}\\{imageName}"); //к оригинальному изображению var path2 = string.Format($"{pathString3}\\{imageName}"); //к уменьшенному //Сохранение оригинального изображения file.SaveAs(path); //Создание и сохранение уменьшенной картинки WebImage img = new WebImage(file.InputStream); img.Resize(200, 200).Crop(1, 1); img.Save(path2); } #endregion //Переадресовка пользователя return(RedirectToAction("AddProduct")); }
private void btnSave_Click(object sender, EventArgs e) { CategoryBUS bus = new CategoryBUS(); if (txtCategoryID.ReadOnly == true) { if (String.IsNullOrEmpty(txtCategoryName.Text)) { MessageBox.Show(Resources.ADD_NULL_CATEGORY_NAME); txtCategoryName.Focus(); } else { CategoryDTO category = (CategoryDTO) grvCategory.GetFocusedRow(); category.CategoryName = txtCategoryName.Text; if (bus.UpdateCategory(category) == 1) { MessageBox.Show(Resources.ADD_CATEGORY_SUCCESS); grdCategory.RefreshDataSource(); } else { MessageBox.Show(Resources.ADD_CATEGORY_FAIL); } } } else { if (String.IsNullOrEmpty(txtCategoryID.Text)) { MessageBox.Show(Resources.ADD_NULL_CATEGORY_ID); txtCategoryID.Focus(); } else { if(String.IsNullOrEmpty(txtCategoryName.Text)) { MessageBox.Show(Resources.ADD_NULL_CATEGORY_NAME); txtCategoryName.Focus(); } else { if (bus.GetCategoryById(txtCategoryID.Text) != null) { MessageBox.Show(Resources.ADD_EXISTING_CATEGORY_ID); } else { bool Ok = false; if (txtCategoryID.Text.IndexOf('.') == -1) { Ok = true; } else { if (bus.GetCategoryById(txtCategoryID.Text.Substring(0, txtCategoryID.Text.LastIndexOf('.'))) != null) Ok = true; else Ok = false; } if (Ok) { CategoryDTO category = new CategoryDTO() { CategoryId = txtCategoryID.Text, CategoryName = txtCategoryName.Text, CreatedDate = DateTime.Now, UpdatedDate = DateTime.Now }; if (bus.InsertCategory(category) == 1) { MessageBox.Show(Resources.ADD_CATEGORY_SUCCESS); txtCategoryID.ReadOnly = true; lst.Add(category); grdCategory.RefreshDataSource(); } else { MessageBox.Show(Resources.ADD_CATEGORY_FAIL); } } else MessageBox.Show(Resources.ADD_ORPHANAGE_CATEGORY); } } } } }
public ActionResult AddProduct(ProductVM model, HttpPostedFileBase file) { if (!ModelState.IsValid) { using (Db db = new Db()) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); } return(View(model)); } //Make sure productname is unique using (Db db = new Db()) { if (db.Products.Any(x => x.Name == model.Name)) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); ModelState.AddModelError("", "That product name id taken!"); return(View(model)); } } int id; using (Db db = new Db()) { ProductDTO productdto = new ProductDTO(); productdto.Name = model.Name; productdto.Slug = model.Name.Replace(" ", "-").ToLower(); productdto.Description = model.Description; productdto.Price = model.Price; productdto.CategoryId = model.CategoryId; CategoryDTO catDTO = db.Categories.FirstOrDefault(x => x.Id == model.CategoryId); productdto.CategoryName = catDTO.Name; db.Products.Add(productdto); db.SaveChanges(); id = productdto.Id; } //set tempdata message TempData["SM"] = "You have added a product!"; #region Upload image var originalDirectory = new DirectoryInfo(string.Format("{0}Images\\Uploads", Server.MapPath(@"\"))); var pathString1 = Path.Combine(originalDirectory.ToString(), "Products"); var pathString2 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString()); var pathString3 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Thumbs"); var pathString4 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Gallery"); var pathString5 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Gallery\\Thumbs"); if (!Directory.Exists(pathString1)) { Directory.CreateDirectory(pathString1); } if (!Directory.Exists(pathString2)) { Directory.CreateDirectory(pathString2); } if (!Directory.Exists(pathString3)) { Directory.CreateDirectory(pathString3); } if (!Directory.Exists(pathString4)) { Directory.CreateDirectory(pathString4); } if (!Directory.Exists(pathString5)) { Directory.CreateDirectory(pathString5); } if (file != null && file.ContentLength > 0) { string ext = file.ContentType.ToLower(); if (ext != "image/jpg" && ext != "image/jpeg" && ext != "image/pjpeg" && ext != "image/gif" && ext != "image/x-png" && ext != "image/png") { using (Db db = new Db()) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); ModelState.AddModelError("", "The image was not uploaded or wrong image extension"); } } string imageName = file.FileName; using (Db db = new Db()) { ProductDTO dto = db.Products.Find(id); dto.ImageName = imageName; db.SaveChanges(); } var path = string.Format("{0}\\{1}", pathString2, imageName); var path2 = string.Format("{0}\\{1}", pathString3, imageName); file.SaveAs(path); WebImage img = new WebImage(file.InputStream); img.Resize(200, 200); img.Save(path2); } #endregion return(RedirectToAction("AddProduct")); }
public int DeleteCategory(CategoryDTO category) { CategoryDAO dao = new CategoryDAO(); return dao.DeleteCategory(category); }
public ActionResult EditProduct(ProductVM model, HttpPostedFileBase file) { int id = model.Id; using (Db db = new Db()) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); } model.GalleryImages = Directory.EnumerateFiles(Server.MapPath("~/Images/Uploads/Products/" + id + "/Gallery/Thumbs")).Select(fn => Path.GetFileName(fn)); if (!ModelState.IsValid) { return(View(model)); } using (Db db = new Db()) { if (db.Products.Where(x => x.Id != id).Any(x => x.Name == model.Name)) { ModelState.AddModelError("", "Products name is taken!"); return(View(model)); } } using (Db db = new Db()) { ProductDTO dto = db.Products.Find(id); dto.Name = model.Name; dto.Slug = model.Name.Replace(" ", "-").ToLower(); dto.Description = model.Description; dto.Price = model.Price; dto.CategoryId = model.CategoryId; dto.ImageName = model.ImageName; CategoryDTO catDTO = db.Categories.FirstOrDefault(x => x.Id == model.CategoryId); dto.CategoryName = catDTO.Name; db.SaveChanges(); } #region ImageUpload if (file != null && file.ContentLength > 0) { string ext = file.ContentType.ToLower(); if (ext != "image/jpg" && ext != "image/jpeg" && ext != "image/pjpeg" && ext != "image/gif" && ext != "image/x-png" && ext != "image/png") { using (Db db = new Db()) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); ModelState.AddModelError("", "The image was not uploaded or wrong image extension"); } } var originalDirectory = new DirectoryInfo(String.Format("{0}Images\\Uploads", Server.MapPath(@"\"))); var pathString1 = Path.Combine(originalDirectory.ToString(), "Products"); var pathString2 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Thumbs"); DirectoryInfo di1 = new DirectoryInfo(pathString1); DirectoryInfo di2 = new DirectoryInfo(pathString2); foreach (FileInfo file2 in di1.GetFiles()) { file2.Delete(); } foreach (FileInfo file3 in di2.GetFiles()) { file3.Delete(); } string imgName = file.FileName; using (Db db = new Db()) { ProductDTO dto = db.Products.Find(id); dto.ImageName = imgName; db.SaveChanges(); } var path = string.Format("{0}\\{1}", pathString1, imgName); var path2 = string.Format("{0}\\{1}", pathString2, imgName); file.SaveAs(path); WebImage img = new WebImage(file.InputStream); img.Resize(200, 200); img.Save(path2); } #endregion TempData["SM"] = "You have edited the product!"; return(RedirectToAction("EditProduct")); }
public int UpdateCategory(CategoryDTO category) { CategoryDAO dao = new CategoryDAO(); return dao.UpdateCategory(category); }
public async Task <IActionResult> UpdateEntityAsync(CategoryDTO categoryDTO) { await _categoryService.UpdateEntityAsync(categoryDTO).ConfigureAwait(false); return(Ok("İşlem Başarılı")); }
//----------------Delete------------------- public ActionResult Delete(int id) { CategoriesDAL c = new CategoriesDAL(); CategoryDTO dto = new CategoryDTO(); dto = c.GetCategoryByID(id); try { c.deleteCategory(dto); return RedirectToAction("Index"); } catch (DataException) { //Log the error (add a variable name after DataException) ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator."); } return View(); }
public int UpdateCategory(CategoryDTO category) { category.UpdatedDate = DateTime.Now; try { ConnectionManager.GetCommand("SP0203", new Dictionary<string, SqlDbType>() { {"@Param1", SqlDbType.NVarChar}, {"@Param2", SqlDbType.NVarChar}, {"@Param3", SqlDbType.DateTime}, {"@Param4", SqlDbType.DateTime} }, new List<object>() { category.CategoryId, category.CategoryName, category.CreatedDate, category.UpdatedDate }).ExecuteNonQuery(); } catch (Exception e) { Log.Error("Error at CategoryDAO - UpdateCategory", e); return 0; } return 1; }
public ActionResult AddProduct(ProductVM model, HttpPostedFileBase file) { //sprawdzamy model state if (!ModelState.IsValid) { //kontekst using (Database db = new Database()) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); return(View(model)); } } // sprawdzenie czy nazwa produktu jest unikalna //kontekst using (Database db = new Database()) { if (db.Products.Any(x => x.Name == model.Name)) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); ModelState.AddModelError("", "Ta nazwa produktu jest zajęta"); return(View(model)); } } //deklaracja prductId int id; // dodawanie produktu i zapis na bazie using (Database db = new Database()) { ProductDTO product = new ProductDTO(); product.Name = model.Name; product.Slug = model.Name.Replace(" ", "-").ToLower(); product.Description = model.Description; product.Price = model.Price; product.CategoryId = model.CategoryId; CategoryDTO catDto = db.Categories.FirstOrDefault(x => x.Id == model.CategoryId); product.CategoryName = catDto.Name; db.Products.Add(product); db.SaveChanges(); // pobranie id dodanego produktu id = product.Id; } //ustawiamy komunikat TempData["SM"] = "Dodałeś produkt"; #region Upload Image //utworzenie potrzebnej struktury katalogów var originalDirectory = new DirectoryInfo(string.Format("{0}Images\\Uploads", Server.MapPath(@"\"))); var pathString1 = Path.Combine(originalDirectory.ToString(), "Products"); var pathString2 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString()); var pathString3 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Thumbs"); var pathString4 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Gallery"); var pathString5 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Gallery\\Thumbs"); if (!Directory.Exists(pathString1)) { Directory.CreateDirectory(pathString1); } if (!Directory.Exists(pathString2)) { Directory.CreateDirectory(pathString2); } if (!Directory.Exists(pathString3)) { Directory.CreateDirectory(pathString3); } if (!Directory.Exists(pathString4)) { Directory.CreateDirectory(pathString4); } if (!Directory.Exists(pathString5)) { Directory.CreateDirectory(pathString5); } if (file != null && file.ContentLength > 0) { // sprawdzenie rozszerzenia pliku czy mamy do czynienia z obrazkiem string ext = file.ContentType.ToLower(); if (ext != "image/jpg" && ext != "image/jpeg" && ext != "image/pjpeg" && ext != "image/gif" && ext != "image/x-png" && ext != "image/png") { using (Database db = new Database()) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); ModelState.AddModelError("", "Obraz nie został przesłany - nieprawidłowe rozszerzenie obrazu."); return(View(model)); } } // inicjalizacja nazwy obrazka string imgName = file.FileName; // zapis nazwy obrazka do bazy using (Database db = new Database()) { ProductDTO dto = db.Products.Find(id); dto.ImageName = imgName; db.SaveChanges(); } var path = string.Format("{0}\\{1}", pathString2, imgName); var path2 = string.Format("{0}\\{1}", pathString3, imgName); //zapisujemy oryginalny obrazek file.SaveAs(path); //zapisujemy miniaturkę WebImage img = new WebImage(file.InputStream); img.Resize(200, 200); img.Save(path2); } #endregion return(RedirectToAction("AddProduct")); }
public async Task UploadFileAsync(IFormFile uploadeDoc, CategoryDTO category) { bool isNew = false; await _context.Docs.Include(x => x.Versions).LoadAsync(); var same = _context.Docs.FirstOrDefault(x => x.Name == uploadeDoc.FileName && x.Category == (Category)category); int release = 1; if (same != null) { release = same.Versions.OrderBy(x => x.Release).Last().Release + 1; } else { isNew = true; same = new Doc { Category = (Category)category, Name = uploadeDoc.FileName, }; _context.Docs.Add(same); } //string path = $"{_appEnvironment.ContentRootPath}/Files/{category}_{release}_{uploadeDoc.FileName}"; string path = $"{_configuration.GetValue<string>("FilesPath")}/{category}_{release}_{uploadeDoc.FileName}"; var version = new Models.Version { Doc = same, Path = path, Release = release, Size = uploadeDoc.Length, UploadDateTime = DateTime.Now, }; _context.Versions.Add(version); try { await _context.SaveChangesAsync(); if (!Directory.Exists(_configuration.GetValue <string>("FilesPath"))) { Directory.CreateDirectory(_configuration.GetValue <string>("FilesPath")); } using (var fileStream = new FileStream(path, FileMode.Create)) { await uploadeDoc.CopyToAsync(fileStream); } } catch (DbUpdateException db) { throw db; // } catch (Exception fileStriem) { // + откат изменений в БД if (isNew) { _context.Remove(same); } _context.Versions.Remove(version); throw fileStriem; } }
public List<CategoryDTO> SearchCategory(string info) { List<CategoryDTO> list = new List<CategoryDTO>(); CategoryDTO categoryDTO; try { SqlDataReader reader = ConnectionManager.GetCommand("sp0005category", new Dictionary<string, SqlDbType>() { { "@cate", SqlDbType.NVarChar } }, new List<object>() { info }).ExecuteReader(); while (reader.Read()) { categoryDTO = new CategoryDTO(); categoryDTO.CategoryId = reader["categoryID"].ToString(); categoryDTO.CategoryName = reader["categoryName"].ToString(); categoryDTO.CreatedDate = (DateTime)reader["CreatedDate"]; categoryDTO.UpdatedDate = (DateTime)reader["UpdatedDate"]; list.Add(categoryDTO); } reader.Close(); } catch (Exception e) { Log.Logger.Error("Error at AuthorDAO - GetAuthorByID", e); return null; } return list; }
public static string GetOperationLog(this CategoryDTO entity, CategoryDTO oldDTO = null) { var sb = new StringBuilder(); var parentNames = new List <string>(); var parent = entity.Parent; while (parent != null) { parentNames.Add(parent.Name); parent = parent.Parent; } parentNames.Reverse(); var parentNameString = string.Join(" > ", parentNames.ToArray()); if (oldDTO == null) { sb.AppendLine(string.Format("{0}: {1}", CommonMessageResources.Sn, entity.Sn)); sb.AppendLine(string.Format("{0}: {1}", CommonMessageResources.Name, entity.Name)); sb.AppendLine(string.Format("{0}: {1}", BaseMessagesResources.Parent_Category, parentNameString)); sb.AppendLine(string.Format("{0}: {1}", CommonMessageResources.SortOrder, entity.SortOrder)); sb.AppendLine(string.Format("{0}: {1}", BaseMessagesResources.Child_SerialNumberRule_Prefix, entity.ChildSnRulePrefix)); sb.AppendLine(string.Format("{0}: {1}", BaseMessagesResources.Child_SerialNumberRule_NumberLength, entity.ChildSnRuleNumberLength)); } else { var oldParentNames = new List <string>(); var oldParent = oldDTO.Parent; while (oldParent != null) { oldParentNames.Add(oldParent.Name); oldParent = oldParent.Parent; } oldParentNames.Reverse(); var oldParentNameString = string.Join(" > ", oldParentNames.ToArray()); if (entity.Sn != oldDTO.Sn) { sb.AppendLine(string.Format("{0}: {1} => {2}", CommonMessageResources.Sn, oldDTO.Sn, entity.Sn)); } if (entity.Name != oldDTO.Name) { sb.AppendLine(string.Format("{0}: {1} => {2}", CommonMessageResources.Name, oldDTO.Name, entity.Name)); } if (parentNameString != oldParentNameString) { sb.AppendLine(string.Format("{0}: {1} => {2}", BaseMessagesResources.Parent_Category, parentNameString, oldParentNameString)); } if (entity.SortOrder != oldDTO.SortOrder) { sb.AppendLine(string.Format("{0}: {1} => {2}", CommonMessageResources.SortOrder, oldDTO.SortOrder, entity.SortOrder)); } if (entity.ChildSnRulePrefix != oldDTO.ChildSnRulePrefix) { sb.AppendLine(string.Format("{0}: {1} => {2}", BaseMessagesResources.Child_SerialNumberRule_Prefix, oldDTO.ChildSnRulePrefix, entity.ChildSnRulePrefix)); } if (entity.ChildSnRuleNumberLength != oldDTO.ChildSnRuleNumberLength) { sb.AppendLine(string.Format("{0}: {1} => {2}", BaseMessagesResources.Child_SerialNumberRule_NumberLength, oldDTO.ChildSnRuleNumberLength, entity.ChildSnRuleNumberLength)); } } return(sb.ToString().TrimEnd('\r', '\n')); }
public async Task <IActionResult> UpdateCategory(string id, [FromBody] CategoryDTO category) { await _categoryManager.UpdateCategory(id, _mapper.Map <Category>(category)); return(Ok()); }
public void UpdateCategory(CategoryDTO category) { uow.Categories.Update(mapper.Map <CategoryDTO, Category>(category)); }
protected void Setup() { CategoryDTO category = new CategoryDTO(); this._metaDataTable = new MetaDataTable(category.GetType(), CategoryDTO.ENTITYNAME); }
public void Edit(CategoryDTO DTO) { DAL.Edit(DTO); }
public IActionResult Update(CategoryDTO categoryDTO) { _categoryService.Update(_mapper.Map <Category>(categoryDTO)); return(RedirectToAction("Index")); }
public ActionResult EditProduct(ProductVM model, HttpPostedFileBase file) { // pobranie id produktu int id = model.Id; // pobranie kategorii dla listy rozwijanej using (Database db = new Database()) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); } // ustawiamy zdjecia model.GalleryImages = Directory .EnumerateFiles(Server.MapPath("~/Images/Uploads/Products/" + id + "/Gallery/Thumbs")) .Select(fn => Path.GetFileName(fn)); // sprawdzamy model state (czy nasz formularz jest poprawnie wypełniony) if (!ModelState.IsValid) { return(View(model)); } // sprawdzenie unikalności nazwy produktu using (Database db = new Database()) { if (db.Products.Where(x => x.Id != id).Any(x => x.Name == model.Name)) { ModelState.AddModelError("", "Ta nazwa produktu jest zajęta"); return(View(model)); } } // Edycja produktu i zapis na bazie using (Database db = new Database()) { ProductDTO dto = db.Products.Find(id); dto.Name = model.Name; dto.Slug = model.Name.Replace(" ", "-").ToLower(); dto.Description = model.Description; dto.Price = model.Price; dto.CategoryId = model.CategoryId; dto.ImageName = model.ImageName; //sprawdzenie nazwy po idku CategoryDTO catDto = db.Categories.FirstOrDefault(x => x.Id == model.CategoryId); dto.CategoryName = catDto.Name; db.SaveChanges(); } // ustawienie TempData TempData["SM"] = "Edytowałeś produkt"; #region Image Upload // sprawdzamy czy jest plik if (file != null && file.ContentLength > 0) { // sprawdzamy rozszerzenie pliku czy to jest obrazek string ext = file.ContentType.ToLower(); if (ext != "image/jpg" && ext != "image/jpeg" && ext != "image/pjpeg" && ext != "image/gif" && ext != "image/x-png" && ext != "image/png") { using (Database db = new Database()) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); ModelState.AddModelError("", "Obraz nie został przesłany - nieprawidłowe rozszerzenie obrazu."); return(View(model)); } } //utworzenie potrzebnej struktury katalogów var originalDirectory = new DirectoryInfo(string.Format("{0}Images\\Uploads", Server.MapPath(@"\"))); var pathString1 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString()); var pathString2 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Thumbs"); // usuwamy stare pliki z katalogów DirectoryInfo di1 = new DirectoryInfo(pathString1); DirectoryInfo di2 = new DirectoryInfo(pathString2); foreach (var file2 in di1.GetFiles()) { file2.Delete(); } foreach (var file3 in di2.GetFiles()) { file3.Delete(); } // zapisujemy nazwę obrazkę na bazie string imageName = file.FileName; using (Database db = new Database()) { ProductDTO dto = db.Products.Find(id); dto.ImageName = imageName; db.SaveChanges(); } // Zapis nowych pliku var path = string.Format("{0}\\{1}", pathString1, imageName); var path2 = string.Format("{0}\\{1}", pathString2, imageName); //zapisujemy plik obrazka file.SaveAs(path); //zapisujemy plik miniaturki i zmniejszamy wielkość obrazka głównego WebImage img = new WebImage(file.InputStream); img.Resize(200, 200); img.Save(path2); } #endregion return(RedirectToAction("EditProduct")); }
public CategoryDTO RenameCategory(CategoryDTO category) { throw new NotImplementedException(); }
public CategoryResponse(CategoryDTO category) : base(string.Empty, true) { this.category = category; }
public void Add(CategoryDTO DTO) { DAL.Add(DTO); }
public void AddCategory(CategoryDTO category) { uow.Categories.Create(mapper.Map <CategoryDTO, Category>(category)); }