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('.', ',')));
}
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('.', ',')));
}
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);
}