Exemplo n.º 1
0
        public int Insert(AccountItem item)
        {
            string        query = "Insert into account(email,password,state) VALUES(@Email,@Password,@State)";
            IDbParameters param = CreateDbParameters();

            param.AddWithValue("Password", item.Password).DbType = DbType.String;
            param.AddWithValue("Email", item.Email).DbType       = DbType.String;
            param.AddWithValue("State", item.State).DbType       = DbType.String;
            return(AdoTemplate.ExecuteNonQuery(CommandType.Text, query, param));
        }
Exemplo n.º 2
0
        public int Update(AccountItem item)
        {
            string        query = "UPDATE account SET password = @Password, email = @Email, state = @State where id = @Id";
            IDbParameters param = CreateDbParameters();

            param.AddWithValue("Id", item.Id).DbType             = DbType.Int32;
            param.AddWithValue("Password", item.Password).DbType = DbType.String;
            param.AddWithValue("Email", item.Email).DbType       = DbType.String;
            param.AddWithValue("State", item.State).DbType       = DbType.String;
            return(AdoTemplate.ExecuteNonQuery(CommandType.Text, query, param));
        }