public static void SavePisteur(PisteurModel model)
{
string instanceName = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
using (SqlConnection connPool = new SqlConnection(instanceName))
{
if (connPool.State == System.Data.ConnectionState.Closed)
connPool.Open();
PISTEUR dataObj = new PISTEUR();
dataObj.NOM = model.NOM;
dataObj.PRENOM = model.PRENOM;
dataObj.CONTACT = model.TEL;
dataObj.ID_ZONE = model.ID_ZONE;
dataObj.VILLAGE = model.VILLAGE;
if (model.ID_AUTO != 0) dataObj.SetId(model.ID_AUTO);
try
{
dataObj.Save();
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex2)
{
throw ex2;
}
finally
{
try { connPool.Close(); }
catch (SqlException) { }
finally { connPool.Dispose(); }
}
}
}
public static List<PISTEUR> GetList()
{
List<PISTEUR> _list= new List<PISTEUR>();
SqlDataReader dr = null;
PISTEUR var = null;
SqlParameter id_auto=new SqlParameter ("@ID_AUTO","0");
try
{
dr=SqlHelper.ExecuteReader(DbLink.Instance.Connection,
"SPGETLIST_PISTEUR" ,id_auto);
while (dr.Read())
{
var=new PISTEUR();
var.SetId(dr.GetInt32(dr.GetOrdinal("ID_AUTO")));
if(!(dr.IsDBNull(dr.GetOrdinal("NOM"))))
{
var.NOM = dr.GetString(dr.GetOrdinal("NOM"));
}
if(!(dr.IsDBNull(dr.GetOrdinal("PRENOM"))))
{
var.PRENOM = dr.GetString(dr.GetOrdinal("PRENOM"));
}
if(!(dr.IsDBNull(dr.GetOrdinal("CONTACT"))))
{
var.CONTACT = dr.GetString(dr.GetOrdinal("CONTACT"));
}
if(!(dr.IsDBNull(dr.GetOrdinal("VILLAGE"))))
{
var.VILLAGE = dr.GetString(dr.GetOrdinal("VILLAGE"));
}
if(!(dr.IsDBNull(dr.GetOrdinal("ID_ZONE"))))
{
var.ID_ZONE = dr.GetInt32(dr.GetOrdinal("ID_ZONE"));
}
var.SetZONE(dr.GetString(dr.GetOrdinal("ZONE")));
_list.Add(var);
}
return _list;
}
catch (SqlException ex)
{
throw ex;
}
finally
{
dr.Close();
}
}