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