public static DataSet DataSetTotalComptes(TotalCompte tc)
{
double totPointe = 0.0;
double totaVenir = 0.0;
double totSolde = 0.0;
Type elementType = typeof(Operation);
DataSet ds = new DataSet();
DataTable t = new DataTable("TotalComptes");
ds.Tables.Add(t);
t.Columns.Add("Compte", typeof(string));
t.Columns.Add("Pointé", typeof(double));
t.Columns.Add("A venir", typeof(double));
t.Columns.Add("Solde", typeof(double));
List <Compte> list = tc.Comptes;
//go through each property on T and add each value to the table
foreach (Compte item in list)
{
DataRow row = t.NewRow();
double soldOpePoint = item.SoldeOperationPointee();
double aVenir = item.AVenir();
double soldFinal = soldOpePoint + aVenir;
row["Compte"] = item.Libelle;
row["Pointé"] = soldOpePoint;
row["A venir"] = aVenir;
row["Solde"] = soldFinal;
totPointe += soldOpePoint;
totaVenir += aVenir;
totSolde += soldFinal;
t.Rows.Add(row);
}
DataRow rowTot = t.NewRow();
rowTot["Compte"] = "Total";
rowTot["Pointé"] = totPointe;
rowTot["A venir"] = totaVenir;
rowTot["Solde"] = totSolde;
t.Rows.Add(rowTot);
return(ds);
}
public static void Delete(TotalCompte tcA)
{
Log.Logger.Debug("Debut TotalCompte.Delete(" + tcA.Id + ")");
try
{
OB ob = (OB)CallContext.GetData(KEY.OB);
ob.ListeTotalCompte.RemoveAll((tc) => tc.Id == tcA.Id);
CallContext.SetData(KEY.OB, ob);
}
catch (Exception ex)
{
Log.Logger.Error(ex.Message);
throw;
}
}
public static TotalCompte Charge(int id)
{
Log.Logger.Debug("Debut TotalCompte.Charge(" + id + ")");
TotalCompte tc = new TotalCompte();
try
{
OB ob = (OB)CallContext.GetData(KEY.OB);
tc = ob.ListeTotalCompte.Where(ttc => ttc.Id == id).First();
}
catch (Exception ex)
{
Log.Logger.Error(ex.Message);
throw;
}
return(tc);
}
public static TotalCompte Maj(TotalCompte tcA)
{
Log.Logger.Debug("Debut TotalCompte.Maj(" + tcA.Id + ")");
try
{
OB ob = (OB)CallContext.GetData(KEY.OB);
TotalCompte tc = ob.ListeTotalCompte.Find((ttc) => ttc.Id == tcA.Id);
tc.Libelle = tcA.Libelle;
tc.Comptes = tcA.Comptes;
CallContext.SetData(KEY.OB, ob);
}
catch (Exception ex)
{
Log.Logger.Error(ex.Message);
throw;
}
return(tcA);
}
public static TotalCompte Sauve(TotalCompte tcA)
{
Log.Logger.Debug("Debut TotalCompte.Sauve(" + tcA.Libelle + ")");
try
{
OB ob = (OB)CallContext.GetData(KEY.OB);
if (ob.ListeTotalCompte == null)
{
ob.ListeTotalCompte = new List <TotalCompte>();
}
tcA.Id = ob.ListeTotalCompte.Count != 0 ? ob.ListeTotalCompte.Max(u => u.Id) + 1 : 1;
ob.ListeTotalCompte.Add(tcA);
CallContext.SetData(KEY.OB, ob);
}
catch (Exception ex)
{
Log.Logger.Error(ex.Message);
throw;
}
return(tcA);
}
