Ejemplo n.º 1
0
        public void SaveAndGetBudget()
        {
            var budgetDAO   = new BudgetDAO(sqlManager);
            var listClassif = JsonConvert.DeserializeObject <Dictionary <string, List <SousClassificationDTO> > >(
                new ClassificationDAO(sqlManager).GetClassification());
            var budgetDTO = new BudgetDTO()
            {
                budget = "2",
                id_sous_classification = listClassif["EQUIPEMENTS_FOURNITURES_REPARATION"][1].id,
                periode = DateTime.Parse("25/02/2019", CultureInfo.CurrentCulture)
            };

            budgetDAO.SaveBudget(budgetDTO);
            var result = JsonConvert.DeserializeObject <Dictionary <string, List <DTO.BudgetDTO> > >(
                budgetDAO.GetBudget("2019", "EQUIPEMENTS_FOURNITURES_REPARATION"));

            Assert.AreEqual(Double.Parse(result["1"][0].budget.Replace('.', ',')), Double.Parse(budgetDTO.budget.Replace('.', ',')));
        }
Ejemplo n.º 2
0
        public void EditBudget()
        {
            var budgetDAO   = new BudgetDAO(sqlManager);
            var listClassif = JsonConvert.DeserializeObject <Dictionary <string, List <SousClassificationDTO> > >(
                new ClassificationDAO(sqlManager).GetClassification());
            var budgetDTO1 = new BudgetDTO()
            {
                budget = "2",
                id_sous_classification = listClassif["EQUIPEMENTS_FOURNITURES_REPARATION"][1].id,
                periode = DateTime.Parse("25/02/2019", CultureInfo.CurrentCulture)
            };

            budgetDAO.SaveBudget(budgetDTO1);
            var result = JsonConvert.DeserializeObject <Dictionary <string, List <BudgetDTO> > >(
                budgetDAO.GetBudget("2019", "EQUIPEMENTS_FOURNITURES_REPARATION"));
            var budgetDTO2 = new BudgetDTO()
            {
                budget = "3",
                id     = result["1"][0].id,
                id_sous_classification = listClassif["EQUIPEMENTS_FOURNITURES_REPARATION"][0].id,
                sous_classification    = listClassif["EQUIPEMENTS_FOURNITURES_REPARATION"][0].name,
                periode = DateTime.Parse("23/11/2019", CultureInfo.CurrentCulture)
            };

            budgetDAO.EditBudget(budgetDTO2);
            result = JsonConvert.DeserializeObject <Dictionary <string, List <BudgetDTO> > >(
                budgetDAO.GetBudget("2019", "EQUIPEMENTS_FOURNITURES_REPARATION"));
            var budgetDTO3 = new BudgetDTO()
            {
                id     = result["10"][0].id,
                budget = result["10"][0].budget,
                sous_classification    = result["10"][0].sous_classification,
                id_sous_classification = result["10"][0].id_sous_classification
            };

            Assert.AreEqual(budgetDTO2.id, budgetDTO3.id);
            Assert.AreEqual(budgetDTO2.id_sous_classification, budgetDTO3.id_sous_classification);
            Assert.AreEqual(budgetDTO2.sous_classification, budgetDTO3.sous_classification);
            Assert.AreEqual(double.Parse(budgetDTO2.budget), double.Parse(budgetDTO3.budget.Replace('.', ',')));
        }
Ejemplo n.º 3
0
        public void DeleteBudget()
        {
            var budgetDAO   = new BudgetDAO(sqlManager);
            var listClassif = JsonConvert.DeserializeObject <Dictionary <string, List <SousClassificationDTO> > >(
                new ClassificationDAO(sqlManager).GetClassification());
            var budgetDTO1 = new BudgetDTO()
            {
                budget = "2",
                id_sous_classification = listClassif["EQUIPEMENTS_FOURNITURES_REPARATION"][1].id,
                periode = DateTime.Parse("25/02/2019", CultureInfo.CurrentCulture)
            };

            budgetDAO.SaveBudget(budgetDTO1);
            var result = JsonConvert.DeserializeObject <Dictionary <string, List <BudgetDTO> > >(
                budgetDAO.GetBudget("2019", "EQUIPEMENTS_FOURNITURES_REPARATION"));

            Assert.IsTrue(result["1"].Count > 0);
            budgetDAO.DeleteBudget(new Guid(result["1"][0].id));
            result = JsonConvert.DeserializeObject <Dictionary <string, List <BudgetDTO> > >(
                budgetDAO.GetBudget("2019", "EQUIPEMENTS_FOURNITURES_REPARATION"));
            Assert.IsTrue(result["1"].Count == 0);
        }