//--------------------------------------------------------------------
public int Insert(ServiceChaine pServiceChaine)
{
string[] lsCols = null;
string[] lsValues = null;
this.FillArray(ref lsCols, ref lsValues, pServiceChaine, true);
return(DataBase.Insert("[ServiceChaine]", lsCols, lsValues));
}
//---------------------------------------------------------------------
private void FillArray(ref string[] pCols, ref string[] pValues, ServiceChaine pServiceChaine, bool pIsInsertID)
{
int liCpt = 0;
int liNombre = 2;
if (pIsInsertID)
{
pCols = new string[liNombre + 1];
pValues = new string[liNombre + 1];
pCols[liCpt] = "iD";
pValues[liCpt++] = "'" + pServiceChaine.ID.ToString() + "'";
}
else
{
pCols = new string[liNombre];
pValues = new string[liNombre];
}
pCols[liCpt] = "id_service";
pValues[liCpt++] = "'" + Util.DoubleQuote(pServiceChaine.Id_service) + "'";
pCols[liCpt] = "id_compte";
pValues[liCpt++] = "'" + Util.DoubleQuote(pServiceChaine.Id_compte) + "'";
}
//---------------------------------------------------------------------
public int Update(ServiceChaine pServiceChaine)
{
string[] lsCols = null;
string[] lsValues = null;
this.FillArray(ref lsCols, ref lsValues, pServiceChaine, false);
return(DataBase.UpdateID("ServiceChaine", lsCols, lsValues, pServiceChaine.ID));
}
//--------------------------------------------------------------------
private ServiceChaine FillFields(DataRow pDataRow)
{
ServiceChaine lServiceChaine = new ServiceChaine();
lServiceChaine.Id_service = (string)pDataRow["id_service"];
lServiceChaine.Id_compte = (string)pDataRow["id_compte"];
lServiceChaine.ID = new Guid(pDataRow["iD"].ToString());
return(lServiceChaine);
}
//--------------------------------------------------------------------
public ServiceChaine Find(Guid ID)
{
ServiceChaine lServiceChaine = (ServiceChaine)AbstractFind(ID);
if (Util.isNULL(lServiceChaine))
{
DataRow row = DataBase.SelectID(ID, "[ServiceChaine]");
if (Util.isNULL(row))
{
return(null);
}
lServiceChaine = this.FillFields(row);
LoadedMap.Add(lServiceChaine.ID, lServiceChaine);
}
return(lServiceChaine);
}
//----------------------------------------------------------------------------------------
public int Delete(ServiceChaine pServiceChaine)
{
return(DataBase.DeleteID(pServiceChaine.ID, "[ServiceChaine]"));
}
