public void Logout(UserSessionInfo session)
{
using (LoginService service = new LoginService())
{
service.Logout(session.SessionToken.Id);
}
}
public UserSessionInfo RenewSession(UserSessionInfo session)
{
using (LoginService service = new LoginService())
{
var newToken = service.Renew(session.SessionToken.Id);
return new UserSessionInfo(session.Principal, newToken);
}
}
/// <summary>
/// Adds a product to a user's inventory
/// </summary>
/// <param name="pD">Details about a product</param>
/// <param name="uSi">User session information</param>
/// <returns>True if the transaction is successful</returns>
public bool AddProductToInventory(ProductDetails pD, UserSessionInfo uSi)
{
try
{
DBConnection.Open();
SQLcmdSP = new SqlCommand("sp_AddProductToInventory", DBConnection);
SQLcmdSP.CommandType = CommandType.StoredProcedure;
SQLcmdSP.Parameters.Add(new SqlParameter("@inventoryID", SqlDbType.Int, 0));
SQLcmdSP.Parameters.Add(new SqlParameter("@productID", SqlDbType.Int, 0));
SQLcmdSP.Parameters.Add(new SqlParameter("@prodQuantity", SqlDbType.Int, 0));
SQLcmdSP.Parameters.Add(new SqlParameter("@prodPrice", SqlDbType.Int, 0));
SQLcmdSP.Parameters.Add(new SqlParameter("@providerID", SqlDbType.Int, 0));
SQLcmdSP.Parameters[0].Value = uSi.InventoryID;
SQLcmdSP.Parameters[1].Value = pD.ProductX.GTIN;
SQLcmdSP.Parameters[2].Value = pD.Quantity;
SQLcmdSP.Parameters[3].Value = pD.ProductPrice;
SQLcmdSP.Parameters[4].Value = pD.ProviderID;
int i = SQLcmdSP.ExecuteNonQuery();
evtWriter.writeInfo("Product " + pD.ProductX.GTIN + " successfully updated in DB");
return true;
}
catch (Exception exc)
{
evtWriter.writeError("Error adding product " + pD.ProductX.GTIN + " to DB" + Environment.NewLine + exc.Message);
return false;
}
finally
{
SQLcmdSP.Dispose();
DBConnection.Close();
}
}
