public async Task <HttpResponseMessage> Run(
[HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = null)] HttpRequestMessage req,
ILogger log)
{
log.LogInformation("C# HTTP trigger function processed a request.");
string json;
dynamic data = await req.Content.ReadAsAsync <object>();
string annee = data?.annee;
string id_sous_classification = data?.id_sous_classification;
string budget = data?.budget;
string mois_valeur = data?.mois_valeur;
try
{
json = new BudgetDAO(sqlManager).SaveBudget(new BudgetDTO()
{
id = annee,
id_sous_classification = id_sous_classification,
budget = budget,
periode = new DateTime(int.Parse(annee), int.Parse(mois_valeur), 1)
});
}
catch (Exception e)
{
return(new HttpResponseMessage(HttpStatusCode.Conflict)
{
Content = new StringContent(e.ToString())
});
}
return(new HttpResponseMessage(HttpStatusCode.OK)
{
Content = new StringContent(json)
});
}
public async Task <HttpResponseMessage> Run(
[HttpTrigger(AuthorizationLevel.Anonymous, "get", Route = null)] HttpRequest req,
ILogger log)
{
log.LogInformation("C# HTTP trigger function processed a request.");
string annee;
req.GetQueryParameterDictionary().TryGetValue("annee", out annee);
string retour = "";
try
{
retour = new BudgetDAO(sqlManager).GetBudgetBilan(annee);
}
catch (Exception e)
{
return(new HttpResponseMessage(HttpStatusCode.InternalServerError)
{
Content = new StringContent(e.Message)
});
}
return(new HttpResponseMessage(HttpStatusCode.OK)
{
Content = new StringContent(retour, Encoding.UTF8, "application/json")
});
}
public async Task <HttpResponseMessage> Run(
[HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = null)] HttpRequestMessage req,
ILogger log)
{
Dictionary <string, object> dictionnaire = new Dictionary <string, object>();
string json = "";
dynamic data = await req.Content.ReadAsAsync <object>();
dictionnaire.Add("id", data?.id);
try
{
json = new BudgetDAO(sqlManager).DeleteBudget(new Guid(((Object)(data?.id)).ToString()));
}
catch (Exception e)
{
return(new HttpResponseMessage(HttpStatusCode.Conflict)
{
Content = new StringContent(e.ToString())
});
}
return(new HttpResponseMessage(HttpStatusCode.OK)
{
Content = new StringContent(json)
});
}
public async Task <HttpResponseMessage> Run(
[HttpTrigger(AuthorizationLevel.Anonymous, "get", Route = null)] HttpRequest req,
ILogger log)
{
log.LogInformation("C# HTTP trigger function processed a request.");
string annee;
string classification;
req.GetQueryParameterDictionary().TryGetValue("classification", out classification);
req.GetQueryParameterDictionary().TryGetValue("annee", out annee);
string retour = new BudgetDAO(sqlManager).GetBudget(annee, classification);
return(new HttpResponseMessage(HttpStatusCode.OK)
{
Content = new StringContent(JsonConvert.SerializeObject(retour))
});
}
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 MoneyConverter()
{
string test1 = new BudgetDAO(null).toMoneyEuros(300);
string test2 = new BudgetDAO(null).toMoneyEuros(3000);
string test3 = new BudgetDAO(null).toMoneyEuros(30000);
string test4 = new BudgetDAO(null).toMoneyEuros(300000);
string test5 = new BudgetDAO(null).toMoneyEuros(3000000);
string test6 = new BudgetDAO(null).toMoneyEuros(30000000);
string test7 = new BudgetDAO(null).toMoneyEuros(30000000.0);
string test8 = new BudgetDAO(null).toMoneyEuros(30000000.1);
string test9 = new BudgetDAO(null).toMoneyEuros(30000000.23);
string test10 = new BudgetDAO(null).toMoneyEuros(30000000.02);
string test11 = new BudgetDAO(null).toMoneyEuros(0.021457);
string test12 = new BudgetDAO(null).toMoneyEuros(000.021457);
string test13 = new BudgetDAO(null).toMoneyEuros(0000000.021457);
string test14 = new BudgetDAO(null).toMoneyEuros(0);
string test15 = new BudgetDAO(null).toMoneyEuros(0.0);
string test16 = new BudgetDAO(null).toMoneyEuros(-30000000.23);
string test17 = new BudgetDAO(null).toMoneyEuros(-300000000.23);
string test18 = new BudgetDAO(null).toMoneyEuros(-3000000000.23);
Assert.AreEqual("300 €", test1);
Assert.AreEqual("3 000 €", test2);
Assert.AreEqual("30 000 €", test3);
Assert.AreEqual("300 000 €", test4);
Assert.AreEqual("3 000 000 €", test5);
Assert.AreEqual("30 000 000 €", test6);
Assert.AreEqual("30 000 000 €", test7);
Assert.AreEqual("30 000 000,1 €", test8);
Assert.AreEqual("30 000 000,23 €", test9);
Assert.AreEqual("30 000 000,02 €", test10);
Assert.AreEqual("0,021457 €", test11);
Assert.AreEqual("0,021457 €", test12);
Assert.AreEqual("0,021457 €", test13);
Assert.AreEqual("0 €", test14);
Assert.AreEqual("0 €", test15);
Assert.AreEqual("-30 000 000,23 €", test16);
Assert.AreEqual("-300 000 000,23 €", test17);
Assert.AreEqual("-3 000 000 000,23 €", test18);
}
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);
}
public static bool SupprimerBudget(int id)
{
return(BudgetDAO.DeleteBudget(id));
}
public static bool ModifierBudget(Budget unBudget)
{
return(BudgetDAO.UpdateBudget(unBudget));
}
public static bool GetRegexString(string value, string regex)
{
return(BudgetDAO.GetRegexString(value, regex));
}
public static bool CreerBudget(Budget unBudget)
{
return(BudgetDAO.AjoutBudget(unBudget));
}
public static void AjoutBudget(BudgetBO unBudget)
{
BudgetDAO.AjoutBudget(unBudget);
}
public static List <BudgetBO> GetBudget(string libelle)
{
return(BudgetDAO.GetBudget(libelle));
}
public static int AjoutBudget(Budget unBudget)
{
return(BudgetDAO.AjoutBudget(unBudget));
}
// Méthode qui retourne un object de type Budget en
// fonction de l'id
public static Budget GetBudget(int id)
{
return(BudgetDAO.GetBudget(id));
}
public static List <BudgetBO> GetBudgets()
{
return(BudgetDAO.GetBudgets());
}
public static int ModificationBudget(Budget unBudget)
{
return(BudgetDAO.ModificationBudget(unBudget));
}
public static BudgetBO TrouverBudget(int idBudget)
{
return(BudgetDAO.TrouveBudget(idBudget));
}
public static float MontantTotalEPS()
{
return(BudgetDAO.MontantTotalEPS());
}
public static void ModifieMontant(BudgetBO unBudget)
{
BudgetDAO.UpdateMontant(unBudget);
}
// Méthode qui renvoit une List d'objets Classe en faisant appel à
// la méthode GetLesClasses() de la DAL
public static List <Budget> GetLesBudget()
{
return(BudgetDAO.GetLesBudget());
}
