//--------------------------------------------------------------------
public int Insert(TransactionVente pTransactionVente)
{
string[] lsCols = null;
string[] lsValues = null;
this.FillArray(ref lsCols, ref lsValues, pTransactionVente, true);
return(DataBase.Insert("[tblTransactionVente]", lsCols, lsValues));
}
//--------------------------------------------------------------------
public int Insert(PrescriptionLignePrescriptionMédicament pPrescriptionLignePrescriptionMédicament)
{
string[] lsCols = null;
string[] lsValues = null;
this.FillArray(ref lsCols, ref lsValues, pPrescriptionLignePrescriptionMédicament, true);
return(DataBase.Insert("[tblPrescriptionLignePrescriptionMédicament]", lsCols, lsValues));
}
//--------------------------------------------------------------------
public int Insert(Patient pPatient)
{
string[] lsCols = null;
string[] lsValues = null;
this.FillArray(ref lsCols, ref lsValues, pPatient, true);
return(DataBase.Insert("[tblPatient]", lsCols, lsValues));
}
//--------------------------------------------------------------------
public int InsertAllMédicament(Prescription pPrescription)
{
int liErreur = DataBase.DeleteRecords("PrescriptionMédicament", "IDPrescription = '" + pPrescription.ID.ToString() + "'");
if (pPrescription.ListMédicament.Count == 0)
{
return(liErreur);
}
IDictionaryEnumerator lDictionaryEnumerator = pPrescription.ListMédicament.GetEnumerator();
int liI = 0;
string[] lsCols = new string[2];
string[] lsValues = new string[2];
lsCols[0] = "IDPrescription";
lsCols[1] = "IDMédicament";
while (lDictionaryEnumerator.MoveNext())
{
lsValues[0] = "'" + pPrescription.ID.ToString() + "'";
lsValues[1] = "'" + ((Médicament)lDictionaryEnumerator.Value).ID.ToString() + "'";
if (DataBase.Insert("Médicament", lsCols, lsValues) == liErreur)
{
liI = liErreur;
}
if (liI != liErreur)
{
liI += 1;
}
}
return(liI);
}
//--------------------------------------------------------------------
public int Insert(Pharmacien pPharmacien)
{
string[] lsCols = null;
string[] lsValues = null;
this.FillArray(ref lsCols, ref lsValues, pPharmacien, true);
return(DataBase.Insert("[tblPharmacien]", lsCols, lsValues));
}
//--------------------------------------------------------------------
public int Insert(Prescription pPrescription)
{
string[] lsCols = null;
string[] lsValues = null;
this.FillArray(ref lsCols, ref lsValues, pPrescription, true);
return(DataBase.Insert("[tblPrescription]", lsCols, lsValues));
}
//--------------------------------------------------------------------
public int Insert(RuptureDeStock pRuptureDeStock)
{
string[] lsCols = null;
string[] lsValues = null;
this.FillArray(ref lsCols, ref lsValues, pRuptureDeStock, true);
return(DataBase.Insert("[tblRuptureDeStock]", lsCols, lsValues));
}
//--------------------------------------------------------------------
public int Insert(Médecin pMédecin)
{
string[] lsCols = null;
string[] lsValues = null;
this.FillArray(ref lsCols, ref lsValues, pMédecin, true);
return(DataBase.Insert("[tblMédecin]", lsCols, lsValues));
}
//--------------------------------------------------------------------
public int Insert(Utilisateur pUtilisateur)
{
string[] lsCols = null;
string[] lsValues = null;
this.FillArray(ref lsCols, ref lsValues, pUtilisateur, true);
return(DataBase.Insert("[tblUtilisateur]", lsCols, lsValues));
}
//--------------------------------------------------------------------
public int InsertAllTransactionVente(Session pSession)
{
int liErreur = DataBase.DeleteRecords("SessionTransactionVente", "IDSession = '" + pSession.ID.ToString() + "'");
if (pSession.ListTransactionVente.Count == 0)
{
return(liErreur);
}
IDictionaryEnumerator lDictionaryEnumerator = pSession.ListTransactionVente.GetEnumerator();
int liI = 0;
string[] lsCols = new string[2];
string[] lsValues = new string[2];
lsCols[0] = "IDSession";
lsCols[1] = "IDTransactionVente";
while (lDictionaryEnumerator.MoveNext())
{
lsValues[0] = "'" + pSession.ID.ToString() + "'";
lsValues[1] = "'" + ((TransactionVente)lDictionaryEnumerator.Value).ID.ToString() + "'";
if (DataBase.Insert("TransactionVente", lsCols, lsValues) == liErreur)
{
liI = liErreur;
}
if (liI != liErreur)
{
liI += 1;
}
}
return(liI);
}