Esempio n. 1
0
        // Group
        public ResponseBo SaveGroup(PersonTableGroupBo saveBo)
        {
            ResponseBo responseBo = new ResponseBo();

            try
            {
                using (SqlConnection conn = DbAccess.Connection.GetConn())
                {
                    var p = new DynamicParameters();
                    base.AddStandartSpParams(ref p, saveBo);

                    p.Add("@Id", saveBo.Id, DbType.Int64, ParameterDirection.Input);
                    p.Add("@PersonId", saveBo.PersonId, DbType.Int64, ParameterDirection.Input);

                    p.Add("@Name", saveBo.Name, DbType.String, ParameterDirection.Input, 50);
                    p.Add("@PersonTableGroupStatId", saveBo.PersonTableGroupStatId, DbType.Int32, ParameterDirection.Input);
                    p.Add("@PersonId", saveBo.PersonId, DbType.Int64, ParameterDirection.Input);
                    p.Add("@Order", saveBo.Order, DbType.Int32, ParameterDirection.Input);
                    p.Add("@Notes", saveBo.Notes, DbType.String, ParameterDirection.Input, 255);

                    conn.Execute("spPersonTableGroupSave", p, commandType: CommandType.StoredProcedure);
                    responseBo.Message    = p.Get <string>("@Message");
                    responseBo.IsSuccess  = p.Get <bool>("@IsSuccess");
                    responseBo.ReturnedId = p.Get <long?>("@ReturnedId");
                }
            }
            catch (Exception ex)
            {
                responseBo = base.SaveExLog(ex, this.GetType(), MethodBase.GetCurrentMethod().Name, saveBo);
            }

            return(responseBo);
        }
Esempio n. 2
0
        public ResponseDto SaveGroup(PersonTableGroupDto saveDto)
        {
            ResponseDto responseDto = new ResponseDto();

            PersonTableGroupBo saveBo = new PersonTableGroupBo()
            {
                Id       = saveDto.Id,
                PersonId = saveDto.PersonId,

                Name = saveDto.Name,
                PersonTableGroupStatId = saveDto.PersonTableGroupStatId,
                Order = saveDto.Order,
                Notes = saveDto.Notes,

                Session = Session
            };

            ResponseBo responseBo = personTableBusiness.SaveGroup(saveBo);

            responseDto = responseBo.ToResponseDto();

            return(responseDto);
        }