public EditCategorieModel(string id_categorie) { categorieDTO = categorieProvider.getCategorie(id_categorie).Result; name = categorieDTO.name; description = categorieDTO.description; isEnabled = categorieDTO.isEnabled == "True" ? true : false; }
//--------------------------------------------- Updates -------------------------------------------- public static bool updateCategorie(CategorieDTO pCategorieDTO) { using (SqlConnection connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["connectionRRHHDatabase"].ConnectionString)) { SqlCommand command = new SqlCommand("usp_update_categorie", connection); command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.Add("@id_categorie", SqlDbType.Int); command.Parameters["@id_categorie"].Value = pCategorieDTO.id_categorie; command.Parameters.Add("@name", SqlDbType.NVarChar); command.Parameters["@name"].Value = pCategorieDTO.name; command.Parameters.Add("@description", SqlDbType.NVarChar); command.Parameters["@description"].Value = pCategorieDTO.description; command.Parameters.Add("@isEnabled", SqlDbType.Bit); command.Parameters["@isEnabled"].Value = pCategorieDTO.isEnabled; command.Connection.Open(); int result = command.ExecuteNonQuery(); if (result != 0) { return(true); } return(false); }; }
public string AddNewCategory(string catName) { // Deklaracja id string id; using (Db db = new Db()) { // sprawdzenie czy nazwa kategorii jest unikalna if (db.Categories.Any(x => x.Name == catName)) { return("tytulzajety"); } // Inicjalizacja DTO CategorieDTO dto = new CategorieDTO(); dto.Name = catName; dto.Slug = catName.Replace(" ", "-").ToLower(); dto.Sorting = 1000; // zapis do bazy db.Categories.Add(dto); db.SaveChanges(); // pobieramy id id = dto.Id.ToString(); } return(id); }
public static CategorieDTO getCategorie(string id_categorie) { CategorieDTO categorieDTO = new CategorieDTO(); using (SqlConnection connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["connectionRRHHDatabase"].ConnectionString)) { SqlCommand command = new SqlCommand("usp_get_categorie", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@id_categorie", SqlDbType.Int); command.Parameters["@id_categorie"].Value = id_categorie; command.Connection.Open(); SqlDataReader rdr = command.ExecuteReader(); while (rdr.Read()) { categorieDTO.id_categorie = rdr["id_categorie"].ToString(); categorieDTO.name = rdr["name"].ToString(); categorieDTO.description = rdr["description"].ToString(); categorieDTO.createdBy_id = rdr["createdBy_id"].ToString(); categorieDTO.createdBy_name = rdr["createdBy_name"].ToString(); categorieDTO.createdDate = rdr["createdDate"].ToString(); categorieDTO.isEnabled = rdr["isEnabled"].ToString(); } }; return(categorieDTO); }
//----------------------------------------------- Gets ------------------------------------------------ public static List <CategorieDTO> getCategories() { List <CategorieDTO> categories = new List <CategorieDTO>(); using (SqlConnection connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["connectionRRHHDatabase"].ConnectionString)) { SqlCommand command = new SqlCommand("usp_get_categories", connection); command.CommandType = CommandType.StoredProcedure; command.Connection.Open(); SqlDataReader rdr = command.ExecuteReader(); while (rdr.Read()) { CategorieDTO categorieDTO = new CategorieDTO(); categorieDTO.id_categorie = rdr["id_categorie"].ToString(); categorieDTO.name = rdr["name"].ToString(); categorieDTO.description = rdr["description"].ToString(); categorieDTO.createdBy_id = rdr["createdBy_id"].ToString(); categorieDTO.createdBy_name = rdr["createdBy_name"].ToString(); categorieDTO.createdDate = rdr["createdDate"].ToString(); categorieDTO.isEnabled = rdr["isEnabled"].ToString(); categories.Add(categorieDTO); } }; return(categories); }
public CategoryVM(CategorieDTO row) { Id = row.Id; Name = row.Name; Slug = row.Slug; Sorting = row.Sorting; }
public IHttpActionResult Put(CategorieDTO pCategorieDTO) { if (!CategoriesData.updateCategorie(pCategorieDTO)) { return(BadRequest()); } return(Ok()); }
public IActionResult AddCategorie([FromBody] CategorieDTO catdto) { var cate = catdto.CreateCategorie(); _maBd.Add(cate); _maBd.SaveChanges(); return(new OkObjectResult(cate)); }
public ActionResult _DeleteCategorieRedirect(string id_categorie) { CategorieDTO categorieDTO = new CategorieDTO(); categorieDTO.id_categorie = id_categorie; if (categorieProvider.deleteCategorie(categorieDTO).Result) { return(new HttpStatusCodeResult(200)); } return(new HttpStatusCodeResult(404, "Can't find that")); }
public Categorie Post(CategorieDTO value) { Categorie model = new Categorie() { NumeCategorie = value.NumeCategorie, Specificatii = value.Specificatii, Descriere = value.Descriere }; return(ICategorieRepository.Create(model)); }
//-------------------------------------- Deletes ----------------------------------------------- public async Task <bool> deleteCategorie(CategorieDTO pCategorieDTO) { using (var client = new HttpClient()) { client.BaseAddress = new Uri(_BaseAddress); client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", getToken()); HttpResponseMessage response = client.DeleteAsync("api/categories/?id_categorie=" + pCategorieDTO.id_categorie).Result; if (response.IsSuccessStatusCode) { return(true); } return(false); } }
public ActionResult _EditCategorie(string name, string description, bool isEnabled, string id_categorie) { CategorieDTO categorieDTO = new CategorieDTO(); categorieDTO.name = name; categorieDTO.description = description; categorieDTO.isEnabled = isEnabled.ToString(); categorieDTO.id_categorie = id_categorie; if (categorieProvider.putCategorie(categorieDTO).Result) { return(Json(categorieDTO)); } return(new HttpStatusCodeResult(404, "Can't find that")); }
public ActionResult DeleteCategory(int id) { using (Db db = new Db()) { // pobieramy kategorie o podnym id CategorieDTO dto = db.Categories.Find(id); // usuwamy kategorie db.Categories.Remove(dto); // zapis na bazie db.SaveChanges(); } return(RedirectToAction("Categories")); }
//-------------------------------------- Puts -------------------------------------------------- public async Task <bool> putCategorie(CategorieDTO pCategorieDTO) { using (var client = new HttpClient()) { client.BaseAddress = new Uri(_BaseAddress); var userJson = new JavaScriptSerializer().Serialize(pCategorieDTO); HttpContent contentPost = new StringContent(userJson, Encoding.UTF8, "application/json"); client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", getToken()); HttpResponseMessage response = client.PutAsync("api/categories/", contentPost).Result; if (response.IsSuccessStatusCode) { return(true); } return(false); } }
public ActionResult _AddCategorie(Model.AddCategorieModel pModel) { CategorieDTO categorieDTO = new CategorieDTO(); categorieDTO.name = pModel.name; categorieDTO.description = pModel.description; string user = Request.Cookies["user"].Value; UserDTO userDTO = new UsersProvider().getUser(user).Result; categorieDTO.createdBy_id = userDTO.user_id; categorieDTO.createdBy_name = userDTO.name + " " + userDTO.fLastName + " " + userDTO.sLastName; if (categorieProvider.postCategorie(categorieDTO).Result) { return(_CategoriesList()); } return(new HttpStatusCodeResult(404, "Can't find that")); }
public ActionResult Category(string name) { //deklaracja ProductVm list List <ProductVM> productVMList; using (Db db = new Db()) { //pobranie id kategorii CategorieDTO catDTO = db.Categories.Where(x => x.Slug == name).FirstOrDefault(); int catId = catDTO.Id; //inicjalizacja listy produktów productVMList = db.Products.ToArray().Where(x => x.CategoryId == catId).Select(x => new ProductVM(x)).ToList(); //pobieramy nazwę kategorii var productCat = db.Products.Where(x => x.CategoryId == catId).FirstOrDefault(); ViewBag.CategoryName = productCat.CategoryName; } return(View(productVMList)); }
public async Task <CategorieDTO> getCategorie(string id_categorie) { using (var client = new HttpClient()) { client.BaseAddress = new Uri(_BaseAddress); CategorieDTO categorie = new CategorieDTO(); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", getToken()); HttpResponseMessage response = client.GetAsync("api/categories/?id_categorie=" + id_categorie).Result; if (response.IsSuccessStatusCode) { string result = await response.Content.ReadAsStringAsync(); JavaScriptSerializer serializer = new JavaScriptSerializer(); categorie = serializer.Deserialize <CategorieDTO>(result); } return(categorie); } }
public Categorie Put(int id, CategorieDTO value) { Categorie model = ICategorieRepository.Get(id); if (value.NumeCategorie != null) { model.NumeCategorie = value.NumeCategorie; } if (value.Specificatii != null) { model.Specificatii = value.Specificatii; } if (value.Descriere != null) { model.Descriere = value.Descriere; } return(ICategorieRepository.Update(model)); }
public string RenameCategory(string newCatName, int id) { using (Db db = new Db()) { // sprawdzenie czy kategoria jest unikalna if (db.Categories.Any(x => x.Name == newCatName)) { return("tytulzajety"); } // pobieramy kategorie CategorieDTO dto = db.Categories.Find(id); // edycja kategorii dto.Name = newCatName; dto.Slug = newCatName.Replace(" ", "-").ToLower(); // zapis na bazie db.SaveChanges(); } return("Ok"); }
public static List <CategorieDTO> getUserCategories(string id_user) { List <CategorieDTO> personaAttributeList = new List <CategorieDTO>(); using (SqlConnection connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["connectionRRHHDatabase"].ConnectionString)) { SqlCommand command = new SqlCommand("usp_get_userCategories", connection); command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.Add("@id_user", SqlDbType.Int); command.Parameters["@id_user"].Value = id_user; command.Connection.Open(); SqlDataReader rdr = command.ExecuteReader(); while (rdr.Read()) { CategorieDTO categorie = new CategorieDTO(); categorie.id_categorie = rdr["id_categorie"].ToString(); categorie.name = rdr["name"].ToString(); categorie.description = rdr["description"].ToString(); categorie.isEnabled = rdr["isEnabled"].ToString(); personaAttributeList.Add(categorie); } }; return(personaAttributeList); }
public ActionResult EditProduct(ProductVM model, HttpPostedFileBase file) { // pobranie id produktu int id = model.Id; // pobranie kategorii dla listy rozwijanej using (Db db = new Db()) { 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 if (!ModelState.IsValid) { return(View(model)); } // sprawdzenie unikalnosci nazwy produktu using (Db db = new Db()) { 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 (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.Prize = model.Prize; dto.CategoryId = model.CategoryId; dto.ImageName = model.ImageName; CategorieDTO 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 (Db db = new Db()) { 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 katalogow 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(); } // Zapis nazwy obrazka na bazie string imageName = file.FileName; using (Db db = new Db()) { ProductDTO dto = db.Products.Find(id); dto.ImageName = imageName; db.SaveChanges(); } // Zapis nowych plików var path = string.Format("{0}\\{1}", pathString1, imageName); var path2 = string.Format("{0}\\{1}", pathString2, imageName); file.SaveAs(path); WebImage img = new WebImage(file.InputStream); img.Resize(200, 200); img.Save(path2); } #endregion return(RedirectToAction("EditProduct")); }
public ActionResult AddProduct(ProductVM model, HttpPostedFileBase file) { // sprawdzamy model state if (!ModelState.IsValid) { using (Db db = new Db()) { model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); return(View(model)); } } // sprawdzenie czy nazwa produktu jest unikalna 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("", "Ta nazwa produktu jest zajęta!"); return(View(model)); } } // deklaracja product id int id; // dodawanie produktu i zapis na bazie using (Db db = new Db()) { ProductDTO product = new ProductDTO(); product.Name = model.Name; product.Slug = model.Name.Replace(" ", "-").ToLower(); product.Description = model.Description; product.Prize = model.Prize; product.CategoryId = model.CategoryId; CategorieDTO 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 rozszezenia 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 (Db db = new Db()) { 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 imageName = file.FileName; // zapis nazwy obrazka do bazy 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); // zapisujemy orginalny obrazek file.SaveAs(path); // zapisujemy miniaturke WebImage img = new WebImage(file.InputStream); img.Resize(200, 200); img.Save(path2); } #endregion return(RedirectToAction("AddProduct")); }
public CategorieModel(string id_categorie) { categorie = categorieProvider.getCategorie(id_categorie).Result; generalAttributes = categorieProvider.getGeneralAttributes(id_categorie).Result; }
public CategorieDTO Get(string id_categorie) { CategorieDTO categorie = CategoriesData.getCategorie(id_categorie); return(categorie); }