public int validareProdus(Produs p) { if (p.Categorie.ToString().Length < 1) { return(0); } if (p.Nume.ToString().Length < 1) { return(0); } if (p.Descriere.ToString().Length < 1) { return(0); } if (p.Gramaj <= 0) { return(0); } if (p.Pret < 0.01) { return(0); } return(1); }
public List <Produs> IncarcaListaDeEvenimente() { List <string> marca = new List <string>(); List <Produs> produs = new List <Produs>(); using (var cn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename" + @"='D:\An4\PSSC\PSSC Proiect Nou\Proiect_DPO\Interfata\App_Data\ProduseDB.mdf';Integrated Security=True")) { string _sql = @"SELECT * FROM [dbo].[CatalogProduse] "; var cmd = new SqlCommand(_sql, cn); cn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { string[] tokens = reader["DetaliiEveniment"].ToString().Split('"'); string tip = Regex.Match(tokens[20], @"\d+").Value; string stare = Regex.Match(tokens[52], @"\d+").Value; //resultString = Regex.Match(subjectString, @"\d+").Value; Produs p = new Produs(new PlainText(tokens[5]), new PlainText(tokens[11]), new PlainText(tokens[17]), (TipProdus)Enum.Parse(typeof(TipProdus), tip), new PlainText(tokens[25]), new PlainText(tokens[31]), new PlainText(tokens[37]), new PlainText(tokens[43]), new PlainText(tokens[49]), (StareProdus)Enum.Parse(typeof(StareProdus), stare)); // Produs p = new Produs(new PlainText(tokens[5]), new PlainText(tokens[11]), new PlainText(tokens[17]), 0, new PlainText(tokens[25]), new PlainText(tokens[31]), new PlainText(tokens[37]), new PlainText(tokens[43]), new PlainText(tokens[49]), 0); produs.Add(p); } } } return(produs); }
public void ReadProdus() { Console.WriteLine("Dati id-ul:"); int id = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Dati numele:"); string nume = Console.ReadLine(); Console.WriteLine("Date codul intern:"); string cod = Console.ReadLine(); Console.WriteLine("Dati codul producatorul:"); string producator = Console.ReadLine(); Produs next = new Produs(id, nume, cod, producator); if (CompareProd(new Produs(id, nume, cod, producator))) { elemente.Add(new Produs(id, nume, cod, producator)); //nrElemente++; Console.WriteLine("Produsul a fost adugat!"); } else { Console.WriteLine("Produsul dat deja exista!"); } }
[HttpPost]// Adaugarea Produs in BD public async Task <IActionResult> Add(IFormFile uploadedFile, Produs produs) { if (uploadedFile != null) { string path = "/img/Produse/" + uploadedFile.FileName; using (var fileStream = new FileStream(appEnvironment.WebRootPath + path, FileMode.Create)) { await uploadedFile.CopyToAsync(fileStream); } string way = "/img/Produse/"; Produs file = new Produs { Img = uploadedFile.FileName, Path = way }; Produs obj = new Produs { Name = produs.Name, Company = produs.Company, Desc = produs.Desc, Img = file.Img, Path = file.Path, Price = produs.Price, Favourite = produs.Favourite, categoryID = produs.categoryID, category = produs.category }; db.Produse.Add(obj); db.SaveChanges(); } logger.LogInformation("Admin a adaugat un nou produs"); return(RedirectToAction("Meniu_manager")); }
public ActionResult Create(int idProdus) { String userId = User.Identity.GetUserId(); Produs produs = db.Produse.Find(idProdus); var cartItems = (from cp in db.CartItems where cp.idUtilizator == userId where cp.idProdus == idProdus select cp).ToList <CartItem>(); if (cartItems.Any()) { TempData["mesaj"] = "Produsul se află deja în coș."; } else if (produs.cantitate == 0) { TempData["mesaj"] = "Produsul nu este disponibil"; } else { CartItem cartItem = new CartItem(); cartItem.idProdus = idProdus; cartItem.idUtilizator = User.Identity.GetUserId(); cartItem.cantitate = 1; cartItem.cantitateMaxima = produs.cantitate; cartItem.denumireProdus = produs.titlu; db.CartItems.Add(cartItem); db.SaveChanges(); } return(RedirectToAction("Index")); }
public void UpdateRatingStat(int produsId, int rating, string flag) { Produs produsAsociat = db.Produse.Find(produsId); if (flag == "NOU") { produsAsociat.nrRatinguri += 1; } if (flag == "STERGE") { produsAsociat.nrRatinguri -= 1; } if (flag == "STERGE") { produsAsociat.ratingInsumat -= rating; } else { produsAsociat.ratingInsumat += rating; } produsAsociat.ratingMediu = getRatingMediu(produsAsociat); if (TryUpdateModel(produsAsociat)) { db.SaveChanges(); } }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } Produs = await _context.Produs .Include(b => b.Furnizor) .Include(b => b.CategoriiProduse).ThenInclude(b => b.Categorie) .AsNoTracking() .FirstOrDefaultAsync(m => m.ID == id); //Produs = await _context.Produs.FirstOrDefaultAsync(m => m.ID == id); if (Produs == null) { return(NotFound()); } //apelam PopulateAssignedCategoryData pentru o obtine informatiile necesare checkbox- //urilor folosind clasa AssignedCategoryData PopulateAssignedCategoryData(_context, Produs); ViewData["FurnizorID"] = new SelectList(_context.Set <Furnizor>(), "ID", "NumeFurnizor"); return(Page()); }
public void WhenInserting3EntitiesInTransactionWeGetAll3() { // insert 3 entitati Categorie, Client, Produs var categorie = new Categorie { Nume = "Produs XXX" }; var client = new Client { Nume = "Client XXX", CNP = "232323232", Prenume = "Client XXX prenume" }; var produs = new Produs { Nume = "Produs YYY", CategorieId = 1, Pret = 12 }; using (var connection = new SqlConnection(connectionString)) { connection.Open(); var categorieRepository = new AdoNetCategorieRepository(connection); var clientRepository = new AdoNetClientRepository(connection); var produsRepository = new AdoNetProdusRepository(connection); var categorieId = categorieRepository.Insert(categorie); var clientId = clientRepository.Insert(client); var produsId = produsRepository.Insert(produs); var categorieActual = categorieRepository.GetById(categorieId); var clientActual = clientRepository.GetById(clientId); var produsActual = produsRepository.GetById(produsId); categorie.AssertAreSame(categorieActual, false); client.AssertAreSame(clientActual, false); produs.AssertAreSame(produsActual, false); } }
private IEnumerable <SelectListItem> categoriiAsociate(Produs produs, int[] categoriiAsociateId) { Categorie[] categoriiAsociateArray; var categoriiAsociateRez = new List <SelectListItem>(); try { categoriiAsociateArray = categoriiDinId(categoriiAsociateId); for (int i = 0; i < categoriiAsociateArray.Length; i++) { categoriiAsociateRez.Add(new SelectListItem { Value = categoriiAsociateArray[i].idCategorie.ToString(), Text = categoriiAsociateArray[i].titlu.ToString() }); } return(categoriiAsociateRez); } catch (NullReferenceException) { return(categoriiAsociateRez); } }
public async Task <IActionResult> Edit(int id, Produs produs) { if (id != produs.id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(produs); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ProdusExists(produs.id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(produs)); }
public async Task <IActionResult> PutProdus(int id, Produs produs) { if (id != produs.Id) { return(BadRequest()); } _context.Entry(produs).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ProdusExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <Produs> > PostProdus(Produs produs) { _context.Produse.Add(produs); await _context.SaveChangesAsync(); return(CreatedAtAction("GetProdus", new { id = produs.Id }, produs)); }
//Funtiile de adaugare in baza de date pentru fiecare tabel in parte public async Task addProdusAsync(Produs produs) { //Se ia numarul de id-uri din baza de date FirebaseResponse idResponse = await client.GetAsync("Counter/ProdCNT"); Counter get = idResponse.ResultAs <Counter>(); get.nr = get.nr + 1; nrProduse = get.nr; //Se face update in baza de date la numarul de produse adaugate FirebaseResponse updateId = await client.UpdateAsync("Counter/ProdCNT", get); //Se introduce produsul cu id-ul sau var data = new Data { Id = get.nr, Denumire = produs.Denumire, Pret = produs.Pret, Gramaj = produs.Gramaj, Retetar = produs.Retetar }; SetResponse response = await client.SetAsync("Produse/" + get.nr.ToString(), data); Data result = response.ResultAs <Data>(); //listaProduse(); }
public ActionResult Edit(int id) { Produs produs = db.Produs.Find(id); ViewBag.Produs = produs; return(View(produs)); }
public ActionResult Editeaza(int id, Produs nou) { ViewBag.cat = GetAllCategories(); try { if (ModelState.IsValid) { Produs actual = app.Produse.Find(id); if (TryUpdateModel(actual)) { actual.CategorieId = nou.CategorieId; actual.Descriere = nou.Descriere; actual.Pret = nou.Pret; actual.Titlu = nou.Titlu; TempData["mesajProdus"] = "editat"; app.SaveChanges(); } return(RedirectToAction("Index")); } else { return(View(nou)); } } catch (Exception e) { return(View(nou)); } }
private void btnCreareProdus_Click(object sender, RoutedEventArgs e) { Produs produsNou = getProdus(); try { ProdusBLL produstBLL = new ProdusBLL(); if (produstBLL.validareProdus(produsNou) == 1) { if (ProdusDAO.getProdus(produsNou) == null) { ProdusBLL.insertProdus(produsNou); listaProduseWindow.deseneazaForme(); MessageBox.Show("Produsul a fost inserat cu succes!"); this.Close(); } else { MessageBox.Show("Acest produs exista deja!"); } } else { MessageBox.Show("Produs invalid!"); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public void Update(Manager.Model.Produs produs1) { Produs produsExistent; Produs produs = new Produs(); if (produs1 != null) { produs.Id = Guid.Parse(produs1.Id); produs.Marime = produs1.Marime; produs.Pret = produs1.Pret; produs.PretRedus = produs1.PretRedus; produs.Titlu = produs1.Titlu; produs.Categorie = produs1.Categorie; produs.Culoare = produs1.Culoare; produs.Descriere = produs1.Descriere; produsExistent = databaseContext.Produs.FirstOrDefault(existingProdus => existingProdus.Id == produs.Id); if (produsExistent != null) { produs.CaleFolder = produsExistent.CaleFolder; databaseContext.Produs.Remove(produsExistent); databaseContext.Produs.Add(produs); databaseContext.SaveChanges(); } } }
public ActionResult Edit(int id) { Produs prd2 = db.Produse.Find(id); ViewBag.ProdusulDeEditat = prd2; return(View()); }
public ActionResult Stergere(int id) { try { Produs produsDeSters = db.Produse.Find(id); if (produsDeSters.idOwner == User.Identity.GetUserId() || User.IsInRole("Admin")) { StergereImagine(id); db.Produse.Remove(produsDeSters); db.SaveChanges(); TempData["mesaj"] = "Produsul a fost eliminat cu scces!"; } else { TempData["mesaj"] = "Nu aveți dreptul să ștergeți acest produs!"; } return(RedirectToAction("Index")); } catch (Exception e) { ViewBag.exceptie = e; return(View("ExceptieStergere")); } }
// To protect from overposting attacks, enable the specific properties you want to bind to, for // more details, see https://aka.ms/RazorPagesCRUD. public async Task <IActionResult> OnPostAsync(string[] selectedCategories) { var newProdus = new Produs(); if (selectedCategories != null) { newProdus.CategoriiProdus = new List <CategorieProdus>(); foreach (var cat in selectedCategories) { var catToAdd = new CategorieProdus { CategorieID = int.Parse(cat) }; newProdus.CategoriiProdus.Add(catToAdd); } } if (await TryUpdateModelAsync <Produs>(newProdus, "Produs", i => i.Denumire, i => i.Brand, i => i.Pret, i => i.DataFabricarii, i => i.StatusID)) { _context.Produs.Add(newProdus); await _context.SaveChangesAsync(); return(RedirectToPage("./Index")); } PopulateAssignedCategoryData(_context, newProdus); return(Page()); }
public static Produs getProdus(Produs p) { Produs produs = null; string query = "SELECT * FROM Produs WHERE categorie = '" + p.Categorie + "' and descriere = '" + p.Descriere + "' and gramaj = '" + p.Gramaj + "' and pret = '" + p.Pret + "';"; MySqlConnection conn = ConnectionFactory.getConnection(); conn.Open(); try { cmd.Connection = conn; cmd.CommandText = query; //System.Windows.MessageBox.Show(cmd.CommandText.ToString()); MySqlDataReader rdr = cmd.ExecuteReader(); if (rdr.Read()) { produs = new Produs(Convert.ToInt32(rdr["idProdus"]), Convert.ToString(rdr["categorie"]), Convert.ToString(rdr["nume"]), Convert.ToString(rdr["descriere"]), Convert.ToInt32(rdr["gramaj"]), Convert.ToDouble(rdr["pret"])); rdr.Close(); } } catch (Exception e) { System.Windows.MessageBox.Show(e.ToString()); } finally { ConnectionFactory.close(conn); } return(produs); }
public async Task <IActionResult> Edit(int id, [Bind("ID,Denumire,Pret,SuplimentID")] Produs produs) { if (id != produs.ID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(produs); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ProdusExists(produs.ID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["SuplimentID"] = new SelectList(_context.Supliment, "ID", "Denumire", produs.SuplimentID); return(View(produs)); }
public async Task <IActionResult> Edit(int id, [Bind("ProdusID,NumeMedicament,CategorieID,FurnizorID,Doza,Pret,DataExpirare")] Produs produs) { if (id != produs.ProdusID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(produs); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ProdusExists(produs.ProdusID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["CategorieID"] = new SelectList(_context.Categorii, "CategorieID", "CategorieID", produs.CategorieID); ViewData["FurnizorID"] = new SelectList(_context.Furnizori, "FurnizorID", "FurnizorID", produs.FurnizorID); return(View(produs)); }
public static List <Object> createListOfObjects(string query, string tip) { List <Object> list = new List <Object>(); MySqlConnection conn = ConnectionFactory.getConnection(); cmd.Connection = conn; cmd.CommandText = query; try { conn.Open(); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Object o = null; if (tip == "Cont") { o = new Cont(Convert.ToString(rdr["username"]), Convert.ToString(rdr["pass"]), Convert.ToChar(rdr["rol"])); } else if (tip == "CategoriiProdus") { o = new CategoriiProdus(Convert.ToString(rdr["categorie"])); } else if (tip == "Client") { o = new Client(Convert.ToInt32(rdr["idClient"]), Convert.ToString(rdr["username"]), Convert.ToString(rdr["nume"]), Convert.ToString(rdr["prenume"]), Convert.ToString(rdr["cnp"]), Convert.ToString(rdr["adresaLivrare"]), Convert.ToString(rdr["nrTelefon"]), Convert.ToString(rdr["email"]), Convert.ToChar(rdr["eClientLoial"])); } else if (tip == "Comanda") { o = new Comanda(Convert.ToInt32(rdr["idComanda"]), Convert.ToInt32(rdr["idClient"]), Convert.ToString(rdr["dataComanda"]), Convert.ToDouble(rdr["pretTotal"]), Convert.ToString(rdr["modalitatePlata"])); } else if (tip == "DetaliiComanda") { o = new DetaliiComanda(Convert.ToInt32(rdr["idComanda"]), Convert.ToString(rdr["numeProdus"]), Convert.ToDouble(rdr["pret"]), Convert.ToInt32(rdr["cantitate"])); } else if (tip == "Produs") { o = new Produs(Convert.ToInt32(rdr["idProdus"]), Convert.ToString(rdr["categorie"]), Convert.ToString(rdr["nume"]), Convert.ToString(rdr["descriere"]), Convert.ToInt32(rdr["gramaj"]), Convert.ToDouble(rdr["pret"])); } list.Add(o); } rdr.Close(); } catch (Exception ex) { System.Windows.MessageBox.Show(ex.ToString()); } finally { ConnectionFactory.close(conn); } return(list); }
public ActionResult BanUser(String userId) { System.Diagnostics.Debug.WriteLine(userId); ApplicationUser user = db.Users.Find(userId); System.Diagnostics.Debug.WriteLine(user.Id); System.Diagnostics.Debug.WriteLine(UserManager.IsInRole(user.Id, "User")); if (UserManager.IsInRole(user.Id, "User") == true) { System.Diagnostics.Debug.WriteLine("User"); UserManager.RemoveFromRole(userId, "User"); UserManager.AddToRole(userId, "BlockedUser"); TempData["mesaj"] = "User-ul a fost blocat cu succes!"; } else if (UserManager.IsInRole(user.Id, "Seller") == true) { System.Diagnostics.Debug.WriteLine("Seller"); var produse = from p in db.Produse where p.idOwner == userId select p; foreach (var p in produse) { Produs produsDeAscuns = db.Produse.Find(p.idProdus); produsDeAscuns.aprobat = false; } db.SaveChanges(); UserManager.RemoveFromRole(userId, "Seller"); UserManager.AddToRole(userId, "BlockedSeller"); TempData["mesaj"] = "Seller-ul a fost blocat cu succes!"; } else if (UserManager.IsInRole(user.Id, "BlockedUser") == true) { System.Diagnostics.Debug.WriteLine("BlockedUser"); UserManager.RemoveFromRole(userId, "BlockedUser"); UserManager.AddToRole(userId, "User"); TempData["mesaj"] = "User-ul a fost deblocat cu succes!"; } else if (UserManager.IsInRole(user.Id, "BlockedSeller") == true) { System.Diagnostics.Debug.WriteLine("BlockedSeller"); UserManager.RemoveFromRole(userId, "BlockedSeller"); UserManager.AddToRole(userId, "Seller"); TempData["mesaj"] = "Seller-ul a fost deblocat cu succes!"; } else if (UserManager.IsInRole(user.Id, "Admin") == true) { System.Diagnostics.Debug.WriteLine("Admin"); TempData["mesaj"] = "Nu se poate bloca un cont administrativ"; } return(RedirectToAction("Index")); }
public ActionResult New(int id) { ViewData["ProdusId"] = id; Produs produs = db.Produs.Find(id); ViewData["Pret"] = produs.Pret; return(View()); }
private void adaugaProdusul_Click(object sender, EventArgs e) { Produs produsSelectat = (Produs)listaProduse.SelectedItem; CosCumparaturiData.Add(produsSelectat); cosProduseBinding.ResetBindings(false); }
public ActionResult DeleteConfirmed(int id) { Produs produs = db.Produse.Find(id); db.Produse.Remove(produs); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Delete(int id) { Produs produs = db.Produs.Find(id); db.Produs.Remove(produs); db.SaveChanges(); return(RedirectToAction("Index", "Home")); }
public IActionResult OnGet() { ViewData["StatusID"] = new SelectList(_context.Set <Status>(), "ID", "StatusVal"); var produs = new Produs(); produs.CategoriiProdus = new List <CategorieProdus>(); PopulateAssignedCategoryData(_context, produs); return(Page()); }
private void AddEditProdusForm_Load(object sender, EventArgs e) { if (ProdusObject == null) { ProdusObject = new Produs(); this.Text = "Adauga produs"; } else { this.Text = "Modifica produs"; numeTbox.Text = ProdusObject.Nume; stocMinimTbox.Text = ProdusObject.StocMinim.ToString("0.00"); pretTbox.Text = ProdusObject.Pret.ToString("0.00"); umTbox.Text = ProdusObject.Um; } }
private void MakeChartWithProdus(Produs produs, DateTime beginDate, DateTime endDate, IntervalType interval = IntervalType.Zilnic) { string comparer = ""; switch (interval) { case IntervalType.Zilnic: comparer = "dd/MM/yyyy"; break; case IntervalType.Lunar: comparer = "MM/yyyy"; break; } chartVanzari.Series.Clear(); var vanzariPeProdus = new List<VanzareProdus>(); while (beginDate.Date <= endDate.Date) { var result = from poz in PozitieFacturaIesire.GetAll() where poz.FacturaIesireObject.Data.ToString(comparer) == beginDate.Date.ToString(comparer) && poz.StocObject.IdProdus == produs.ID group poz by poz.FacturaIesireObject.Data.ToString(comparer) into poz_nou select new VanzareProdus { Cantitate = poz_nou.Sum(p => p.Cantitate).ToString("0.00"), DataVanzarii = beginDate.Date.ToString(comparer) }; VanzareProdus vanzare = null; vanzare = result.FirstOrDefault() == null ? new VanzareProdus { Cantitate = "0", DataVanzarii = beginDate.Date.ToString(comparer) } : result.FirstOrDefault(); vanzariPeProdus.Add(vanzare); switch (interval) { case IntervalType.Zilnic: beginDate = beginDate.AddDays(1); break; case IntervalType.Lunar: beginDate = beginDate.AddMonths(1); break; } } var series = new Series(produs.Nume); series.XValueMember = "DataVanzarii"; series.XValueType = ChartValueType.Date; series.YValueMembers = "Cantitate"; series.YValueType = ChartValueType.String; chartVanzari.DataSource = vanzariPeProdus.ToList(); chartVanzari.Series.Add(series); }
private void searchProdusBtn_Click(object sender, EventArgs e) { var form = new SelectItemForm { Datas = Produs.GetAll().Cast<GestiuneObject>().ToList(), Text = "Cautare produs" }; if (form.ShowDialog() == System.Windows.Forms.DialogResult.OK) SelectedProdus = form.SelectedObject == null ? null : (Produs)form.SelectedObject; }
public void InsertProdusTest() { var target = new Produs { Nume = "Testing1", Pret = 123m, StocMinim = 12, Um = "Testing" }; if (target.Save().Status != StatusEnum.Errors) { Assert.Fail(); } }
public void UpdateProdusTest() { var target = new Produs { Nume = "Modificat", Pret = 123m, StocMinim = 122, Um = "Modificat", ID = 1 }; if (target.Save().Status == StatusEnum.Errors) { Assert.Fail(); } }