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