private static List <MemberProduct> get(string query, Dictionary <string, object> parameters)
{
MemberProduct item = null;
Connection cs = new Connection();
List <MemberProduct> list = new List <MemberProduct>();
MySqlDataReader reader = cs.Select(query, parameters);
while (reader.Read())
{
item = new MemberProduct();
if (!reader.IsDBNull(reader.GetOrdinal("id")))
{
item.id = reader.GetInt32(reader.GetOrdinal("id"));
}
if (!reader.IsDBNull(reader.GetOrdinal("memberId")))
{
item.memberId = reader.GetInt32(reader.GetOrdinal("memberId"));
}
if (!reader.IsDBNull(reader.GetOrdinal("productId")))
{
item.productId = reader.GetInt32(reader.GetOrdinal("producId"));
}
if (!reader.IsDBNull(reader.GetOrdinal("date")))
{
item.date = reader.GetDateTime(reader.GetOrdinal("date"));
}
if (!(reader["status"] == DBNull.Value))
{
item.status = reader["status"].ToString().Trim();
}
list.Add(item);
}
cs.CloseConnection();
return(list);
}
public static int Add(MemberProduct m)
{
int t = 0;
string query = @"INSERT INTO memberProduct (memberId, productId, date, status) " +
"VALUES (@memberId, @productId, NOW(), @status);";
Connection cs = new Connection();
Dictionary <string, object> param = new Dictionary <string, object>();
param.Add("memberId", m.memberId);
param.Add("productId", m.productId);
param.Add("status", m.status);
try
{
t = cs.Insert(query, param);
//si insertion reussit
}
catch (MySqlException e) { }
cs.CloseConnection();
//si insertion echoue
return(t);
}