public async Task AddAsync(vCartItem entity)
{
var spParameters = new SqlParameter[4];
spParameters[0] = new SqlParameter()
{
ParameterName = "FashionProductId", Value = entity.FashionProductId
};
spParameters[1] = new SqlParameter()
{
ParameterName = "PaytmUserId", Value = entity.PaytmUserId
};
spParameters[2] = new SqlParameter()
{
ParameterName = "ProductQuantity", Value = entity.ProductQuantity
};
spParameters[3] = new SqlParameter()
{
ParameterName = "TotalAmount", Value = entity.TotalAmount
};
await DbContextManager.StoreProc <StoreProcResult>("[dbo].[spCart]", spParameters);
await Uow.RegisterNewAsync(entity);
await Uow.CommitAsync();
}
public List <vCartItem> Get(int userId)
{
var cartItems = new List <vCartItem>();
var reader = this.GetReader($"select * from vCart where userid={userId}");
while (reader.Read())
{
var cartItem = new vCartItem();
cartItem.ItemName = reader.GetString(0);
cartItem.Price = reader.GetInt32(1);
cartItem.Quantity = reader.GetInt32(2);
cartItems.Add(cartItem);
}
return(cartItems);
}
public Task DeleteAsync(vCartItem parameters)
{
throw new NotImplementedException();
}
public HashSet <string> DeleteValidation(vCartItem parameters)
{
return(ValidationMessages);
}
public async Task UpdateAsync(vCartItem entity)
{
await Uow.RegisterDirtyAsync(entity);
await Uow.CommitAsync();
}
public HashSet <string> UpdateValidation(vCartItem entity)
{
return(ValidationMessages);
}
public async Task <object> GetBy(vCartItem parameters)
{
return(await Uow.Repository <vCartItem>().FindByAsync(t => t.PaytmUserId == parameters.PaytmUserId));
}
public async Task <object> GetAsync(vCartItem parameters)
{
return(await Uow.Repository <vCartItem>().AllAsync());
}
