Beispiel #1
0
        //public IConfiguration Configuration { get; }
        //public UserImpl(IConfiguration configuration)
        //{
        //    Configuration = configuration;
        //    MysqlConn = new MySqlConnection(Configuration.GetConnectionString("MsSqlDemo"));
        //    MysqlConn.Open();
        //}

        public ResponseT <long> Create(RequestT <UserAdd> userAdd)
        {
            var response = new ResponseT <long>();

            using (MysqlConn)
            {
                response.data = MysqlConn.Execute(@"insert  into `user`(name, sex) values (@name, @sex)", userAdd.data);
            }
            return(response);
        }
Beispiel #2
0
        public ResponseT <int> Delete(RequestT <UserDelete> userDelete)
        {
            var response = new ResponseT <int>();

            using (MysqlConn)
            {
                response.data = MysqlConn.Execute($"delete from user where userid=@ids", userDelete.data);
            }

            return(response);
        }
Beispiel #3
0
        public ResponseT <int> Edit(RequestT <UserUpdate> userUpdate)
        {
            var response = new ResponseT <int>();

            using (MysqlConn)
            {
                response.data = MysqlConn.Execute(@"update user set name=@name, sex=@sex where userid=@userid", userUpdate);
            }

            return(response);
        }
Beispiel #4
0
 public ResponseT <int> Delete(RequestT <UserDelete> request)
 {
     return(_user.Delete(request));
 }
Beispiel #5
0
 public ResponseT <int> Edit([FromBody] RequestT <UserUpdate> request)
 {
     return(_user.Edit(request));
 }
Beispiel #6
0
 public ResponseT <long> Create([FromBody] RequestT <UserAdd> request)
 {
     return(_user.Create(request));
 }