public string DeleteBudget(Guid id)
{
Dictionary <string, object> dictionnaire = new Dictionary <string, object>();
dictionnaire.Add("id", id.ToString());
return(sqlManager.ExecProcedure("DeleteBudget", dictionnaire));
}
public string DeleteEncaissement(string id)
{
Dictionary <string, object> dictionnaire = new Dictionary <string, object>();
dictionnaire.Add("id", id);
return(sqlManager.ExecProcedure("DeleteEncaissement", dictionnaire));
}
public string GetAllAccountPositionAtDate(string _date)
{
Dictionary <string, object> dictionnaire = new Dictionary <string, object>();
var date = DateTime.Parse(_date, new System.Globalization.CultureInfo("fr-FR"));
dictionnaire.Add("date", date.ToString("dd/MM/yyyy"));
return(sqlManager.ExecProcedure("GetAllAccountsPositionAtDate", dictionnaire));
}
public string GetAccountType()
{
string retourSQL = sqlManager.ExecProcedure("getAccountType");
List <tmpClassAccount> retour = JsonConvert.DeserializeObject <List <tmpClassAccount> >(retourSQL);
Dictionary <string, List <string> > dict = new Dictionary <string, List <string> >();
foreach (var item in retour)
{
if (!dict.ContainsKey(item.banque))
{
dict.Add(
item.banque,
new List <string>());
}
dict[item.banque].Add(item.compte);
}
return(JsonConvert.SerializeObject(dict));
}
public string GetClassification()
{
List <tmpClassClasif> retour = new List <tmpClassClasif>();
retour = JsonConvert.DeserializeObject <List <tmpClassClasif> >(
sqlManager.ExecProcedure("GetClassification").Replace("\\r\\n", "").Replace("\\", ""));
Dictionary <ClassificationDTO, List <SousClassificationDTO> > dict =
new Dictionary <ClassificationDTO, List <SousClassificationDTO> >();
foreach (var item in retour)
{
if (!dict.ContainsKey(new ClassificationDTO(item.id_classification)))
{
dict.Add(
new ClassificationDTO(item.id_classification,
item.classification),
new List <SousClassificationDTO>());
}
dict[new ClassificationDTO(item.id_classification)].Add(
new SousClassificationDTO(item.id_sous_classification,
item.sous_classification));
}
return(JsonConvert.SerializeObject(dict));
}
public string GetPayementMethod()
{
return(sqlManager.ExecProcedure("GetPayementMethod"));
}
public string GetAllSociete()
{
return(sqlManager.ExecProcedure("GetAllSociete"));
}