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);
        }
Esempio n. 2
0
        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);
        }
Esempio n. 3
0
        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"));
        }
Esempio n. 6
0
        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());
        }
Esempio n. 8
0
        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);
            }
        }
Esempio n. 9
0
        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);
            }
        }
Esempio n. 10
0
        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));
        }
Esempio n. 11
0
        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());
        }
Esempio n. 12
0
        public async Task <ActionResult <Produs> > PostProdus(Produs produs)
        {
            _context.Produse.Add(produs);
            await _context.SaveChangesAsync();

            return(CreatedAtAction("GetProdus", new { id = produs.Id }, produs));
        }
Esempio n. 13
0
        //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();
        }
Esempio n. 14
0
        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());
            }
        }
Esempio n. 17
0
        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();
                }
            }
        }
Esempio n. 18
0
        public ActionResult Edit(int id)
        {
            Produs prd2 = db.Produse.Find(id);

            ViewBag.ProdusulDeEditat = prd2;
            return(View());
        }
Esempio n. 19
0
        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"));
            }
        }
Esempio n. 20
0
        // 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);
        }
Esempio n. 22
0
        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));
        }
Esempio n. 24
0
        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);
        }
Esempio n. 25
0
        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"));
        }
Esempio n. 26
0
        public ActionResult New(int id)
        {
            ViewData["ProdusId"] = id;
            Produs produs = db.Produs.Find(id);

            ViewData["Pret"] = produs.Pret;
            return(View());
        }
Esempio n. 27
0
        private void adaugaProdusul_Click(object sender, EventArgs e)
        {
            Produs produsSelectat = (Produs)listaProduse.SelectedItem;

            CosCumparaturiData.Add(produsSelectat);

            cosProduseBinding.ResetBindings(false);
        }
Esempio n. 28
0
        public ActionResult DeleteConfirmed(int id)
        {
            Produs produs = db.Produse.Find(id);

            db.Produse.Remove(produs);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Esempio n. 29
0
        public ActionResult Delete(int id)
        {
            Produs produs = db.Produs.Find(id);

            db.Produs.Remove(produs);
            db.SaveChanges();
            return(RedirectToAction("Index", "Home"));
        }
Esempio n. 30
0
        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());
        }
Esempio n. 31
0
 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;
 }
Esempio n. 34
0
 public void InsertProdusTest()
 {
     var target = new Produs
     {
         Nume = "Testing1",
         Pret = 123m,
         StocMinim = 12,
         Um = "Testing"
     };
     if (target.Save().Status != StatusEnum.Errors)
     {
         Assert.Fail();
     }
 }
Esempio n. 35
0
 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();
     }
 }