Пример #1
0
        public async Task <int> DeactiveCustomerUserAsync(MstrCustomerUsers cusUser)
        {
            DynamicParameters para = new DynamicParameters();

            para.Add("CusUserId", cusUser.AutoId);
            para.Add("IsActive", cusUser.IsActive);
            para.Add("UserId", cusUser.CreateUserId);
            para.Add("@Result", dbType: DbType.Int32, direction: ParameterDirection.Output);

            var result = await DbConnection.ExecuteAsync("spMstrCustomerUserDeactive", para
                                                         , commandType : CommandType.StoredProcedure);

            return(para.Get <int>("Result"));
        }
Пример #2
0
        public async Task <int> SaveCustomerUserAsync(MstrCustomerUsers customerUser)
        {
            DynamicParameters para = new DynamicParameters();

            para.Add("AutoId", customerUser.AutoId);
            para.Add("Title", customerUser.Title);
            para.Add("FirstName", customerUser.FirstName.Trim());
            para.Add("LastName", customerUser.LastName.Trim());
            para.Add("Email", customerUser.Email.Trim());
            para.Add("Designation", customerUser.Designation.Trim());
            para.Add("CustomerId", customerUser.CustomerId);
            para.Add("UserId", customerUser.CreateUserId);
            para.Add("@Result", dbType: DbType.Int32, direction: ParameterDirection.Output);

            var result = await DbConnection.ExecuteAsync("spMstrCustomerUserSave", para
                                                         , commandType : CommandType.StoredProcedure);

            return(para.Get <int>("Result"));
        }
Пример #3
0
        public async Task <IActionResult> DeactiveCustomerUser(MstrCustomerUsers cusUser)
        {
            var result = await _masterRepository.DeactiveCustomerUserAsync(cusUser);

            return(Ok(result));
        }