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); }