public void Update(DataContracts.UserProducts entity)
{
UserProducts up = _source.First(o => o.IdProduct == entity.IdProduct && o.IdUser == entity.IdUser);
if (up != null)
{
up.Quantity = entity.Quantity;
}
}
public void Delete(DataContracts.UserProducts entity)
{
string query = string.Format("DELETE FROM USERPRODUCTS WHERE id = {0};", entity.ID);
using (SqlCommand cmd = AccessBD.Connection.CreateCommand())
{
cmd.CommandText = query;
cmd.ExecuteNonQuery();
}
}
public void Update(DataContracts.UserProducts entity)
{
string query = string.Format("UPDATE USERPRODUCTS SET idProduct = {0}, idUser = {1}, quantity = {2};", entity.IdUser, entity.IdUser, entity.Quantity);
using (SqlCommand cmd = AccessBD.Connection.CreateCommand())
{
cmd.CommandText = query;
cmd.ExecuteNonQuery();
}
}
public void Insert(DataContracts.UserProducts entity)
{
string query = string.Format("INSERT INTO USERPRODUCTS(idProduct, idUser, quantity) VALUES('{0}', '{1}', '{2}');", entity.IdProduct, entity.IdUser, entity.Quantity);
using (SqlCommand cmd = AccessBD.Connection.CreateCommand())
{
cmd.CommandText = query;
cmd.ExecuteNonQuery();
}
}
private List<UserProducts> MapUSERPRODUCTS(IDataReader reader)
{
List<UserProducts> list = new List<UserProducts>();
while (reader.Read())
{
UserProducts userproducts = new UserProducts()
{
IdUser = Tools.ChangeType<int>(reader["idUser"]),
IdProduct = Tools.ChangeType<int>(reader["idProduct"]),
Quantity = Tools.ChangeType<int>(reader["quantity"]),
};
list.Add(userproducts);
}
return list;
}
private void SaveProducts()
{
foreach (var prod in this.HandleDoublons())
{
UserProducts entity = new UserProducts();
entity.IdProduct = prod.First.ID;
entity.IdUser = this.Context.ApplicationUser.ID;
entity.Quantity = prod.Second;
UserProductsRepo.Insert(entity);
}
}
public void Delete(DataContracts.UserProducts entity)
{
_source.RemoveAll(o => o.IdProduct == entity.IdProduct && o.IdUser == entity.IdUser);
}
public void Insert(DataContracts.UserProducts entity)
{
_source.Add(entity);
}
