public static Boolean save(Souhait obj)
{
if (obj.Id == Guid.Empty)
{
return(insert(obj));
}
else
{
return(update(obj));
}
}
public static Souhait getFirst(string where)
{
Souhait res = null;
var temp = DbManager.getFirst(Configuration.Config.DB_PATH, TABLE_NAME, where);
if (temp != null)
{
res = createEntityFrom(temp);
}
return(res);
}
private static Souhait createEntityFrom(Dictionary <string, object> dict)
{
Souhait ob = new Souhait()
{
Id = Guid.Parse((String)dict["id"]),
Statut = (String)dict["statuts"],
Type = (String)dict["types"],
Surface_habitable_min = Aide.parseInt(dict["surfacehabitemin"].ToString()),
Surface_parcelle_min = Aide.parseInt(dict["surfaceparcellemin"].ToString()),
Chambre_min = Aide.parseInt(dict["nombrechambremin"].ToString()),
Cave = (String)dict["aveccaves"],
Garage = (String)dict["avecgarages"],
Ville = (String)dict["villes"],
Prix_max = Aide.parseFloat(dict["prixmax"].ToString()),
Id_acheteur = (String)dict["idacheteur"],
Nom_acheteur = (String)dict["nomacheteur"]
};
return(ob);
}
public static Boolean delete(Souhait obj)
{
return(DbManager.delete(Configuration.Config.DB_PATH, TABLE_NAME, TABLE_NAME + ".ID = '" + obj.Id + "'"));
}
public static Boolean update(Souhait obj)
{
return(DbManager.update(Configuration.Config.DB_PATH, TABLE_NAME, COLUMNS, obj.getValues(), TABLE_NAME + ".ID = '" + obj.Id + "'"));
}
public static Boolean insert(Souhait obj)
{
//obj.id = Guid.NewGuid();
return(DbManager.insert(Configuration.Config.DB_PATH, TABLE_NAME, COLUMNS, obj.getValues()));
}