Exemple #1
0
        public long AddStoreInventory(AddStoreInventoryModel model)
        {
            var sqlQuery      = GetStoreInventoryExitsQuery(model.StoreId.ToString(), model.InventoryId.ToString());
            var numberOfUnits = GetAvailableUnit(model.StoreId.ToString(), model.InventoryId.ToString());
            var count         = _db.ExecuteScalar <long>(sqlQuery);

            if (count > 0)
            {
                sqlQuery = "";
                sqlQuery = GetEditStoreInventoryQuery();

                _db.ExecuteScalar <long>(sqlQuery, new
                {
                    @numberOfItems = numberOfUnits + model.NumberOfItems,
                    @modifiedBy    = _setupUser.GetUserData().Id,
                    @modifiedDate  = DateTime.Now,
                    @storeId       = model.StoreId.ToString(),
                    @inventoryId   = model.InventoryId.ToString()
                });
                return(1);
            }
            else
            {
                sqlQuery = "";
                sqlQuery = GetAddStoreInventoryQuery();

                var result = _db.ExecuteScalar <long>(sqlQuery, new
                {
                    @storeId       = model.StoreId.ToString(),
                    @inventoryId   = model.InventoryId.ToString(),
                    @numberOfItems = model.NumberOfItems,
                    @createdBy     = _setupUser.GetUserData().Id,
                    @createdDate   = DateTime.Now,
                    @modifiedBy    = _setupUser.GetUserData().Id,
                    @modifiedDate  = DateTime.Now
                });
                return(result);
            }
        }
Exemple #2
0
 public ActionResult Accept(InvitationModel model)
 {
     try
     {
         var user = _setupUser.GetUserData();
         if (ModelState.IsValid)
         {
             _employeeService.SendInvitation(model, user.Id);
             return(View().WithSuccess("En aktiveringslänk har sänts till din emailadress."));
         }
         else
         {
             return(View());
         }
     }
     catch (Exception ex)
     {
         _log.ErrorFormat("Error in requesting employee. Error : {0}", ex.Message);
         _log.Error(ex);
         return(RedirectToAction("Accept").WithError(ex.Message));
     }
 }