Beispiel #1
0
 public SubGroupDTO Create(SubGroupCreateDTO modelToCreate)
 {
     try
     {
         int newID        = UOW.SubGroupRepo.Create(modelToCreate);
         var createResult = UOW.SubGroupRepo.GetByID(newID);
         UOW.SaveChanges();
         return(createResult);
     }
     catch (Exception ex)
     {
         UOW.RollbackChanges();
         throw ex;
     }
 }
        public int Create(SubGroupCreateDTO entityToCreate)
        {
            try
            {
                string query = @"
                INSERT INTO SubGroups(SubGroupCode, SubGroupName, SubGroupDescription, ProductGroupID)
                VALUES (@SubGroupCode, @SubGroupName, @SubGroupDescription, @ProductGroupID)
                
                SELECT SCOPE_IDENTITY()";

                var queryParameters = new DynamicParameters();
                queryParameters.Add("@SubGroupCode", entityToCreate.SubGroupCode);
                queryParameters.Add("@SubGroupName", entityToCreate.SubGroupName);
                queryParameters.Add("@SubGroupDescription", entityToCreate.SubGroupDescription);
                queryParameters.Add("@ProductGroupID", entityToCreate.ProductGroupID);

                return(Connection.QueryFirst <int>(query, queryParameters, CurrentTrans));
            }
            catch (Exception ex)
            {
                throw SqlExceptionHandler.HandleSqlException(ex) ?? ex;
            }
        }
 public SubGroupDTO Create(SubGroupCreateDTO createModel)
 {
     return(_subGroupService.Create(createModel));
 }
 public ActionResult <SubGroupDTO> Create([FromBody] SubGroupCreateDTO userInput)
 {
     try { return(_subGroupManager.Create(userInput)); }
     catch (BaseCustomException ex) { return(BadRequest(ex.Message)); }
 }