public static Int32 CartUpSert(SqlConnection dbcon, Cart_Lineitem cart)
{
SqlCommand cmd = new SqlCommand("sp_cart_upsert", dbcon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@cartid", SqlDbType.Int).Value = cart.CartNumber;
cmd.Parameters.Add("@prodid", SqlDbType.VarChar).Value = cart.ProductId;
cmd.Parameters.Add("@qty", SqlDbType.Int).Value = cart.Quantity;
int intCnt = cmd.ExecuteNonQuery();
return(intCnt);
}
public static Int32 CUDCart_Lineitem(SqlConnection dbcon, string CUDAction, Cart_Lineitem cart)
{
SqlCommand cmd = new SqlCommand();
if (CUDAction == "update")
{
cmd.CommandText = "update Cart_LineItems set Quantity = @Quantity " +
"where ProductId = @ProductId";
cmd.Parameters.AddWithValue("@CartNumber", SqlDbType.Int).Value = cart.CartNumber;
cmd.Parameters.AddWithValue("@ProductId", SqlDbType.VarChar).Value = cart.ProductId;
cmd.Parameters.AddWithValue("@Quantity", SqlDbType.Int).Value = cart.Quantity;
}
else if (CUDAction == "delete")
{
cmd.CommandText = "delete Cart_LineItems where ProductId = @ProductId";
cmd.Parameters.AddWithValue("@ProductId", SqlDbType.Int).Value = cart.ProductId;
}
cmd.Connection = dbcon;
int intCnt = cmd.ExecuteNonQuery();
cmd.Dispose();
return(intCnt);
}