private static List <MemberInterest> get(string query, Dictionary <string, object> parameters)
{
MemberInterest item = null;
Connection cs = new Connection();
List <MemberInterest> list = new List <MemberInterest>();
MySqlDataReader reader = cs.Select(query, parameters);
while (reader.Read())
{
item = new MemberInterest();
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("categoryProductId")))
{
item.categoryProductId = reader.GetInt32(reader.GetOrdinal("categoryProductId"));
}
list.Add(item);
}
cs.CloseConnection();
return(list);
}
public static int Add(MemberInterest m)
{
int t = 0;
string query = @"INSERT INTO memberInterest (memberId, categoryProductId) " +
"VALUES (@memberId, @categoryProductId);";
Connection cs = new Connection();
Dictionary <string, object> param = new Dictionary <string, object>();
param.Add("memberId", m.memberId);
param.Add("categoryProductId", m.categoryProductId);
try
{
t = cs.Insert(query, param);
//si insertion reussit
}
catch (MySqlException e) { }
cs.CloseConnection();
//si insertion echoue
return(t);
}
