public async Task <IActionResult> InsertOneToOneAsync() { var dt = new GroupOneToOneDTO { NAME = "One To One 1", USERS = new UserOneDTO { FiRST_NAME = "Eyüp One To One 1", LAST_NAME = "Ensar", EMAiL = "*****@*****.**", PASSWORD = "******", PHONE = "05550000000", GROUPiD = 1, USERTYPEiD = 1 }, }; var rs = await _userService.InsertOneToOneAsync(dt); return(View()); }
public async Task <bool> DeleteOneToOneAsync(GroupOneToOneDTO dt) { bool result = false; using (var transaction = _connection.DB.BeginTransaction()) { try { await _connection.DB.ExecuteAsync(@"DELETE FROM USER_GROUPS WHERE ID = @GROUPiD", dt, transaction); await _connection.DB.ExecuteAsync(@"DELETE FROM USERS WHERE GROUPID = @GROUPiD AND ID = @UseriD", dt.USERS, transaction); transaction.Commit(); result = true; } catch { transaction.Rollback(); } } return(result); }
public async Task <bool> UpdateOneToOneAsync(GroupOneToOneDTO dt) { bool result = false; using (var transaction = _connection.DB.BeginTransaction()) { try { await _connection.DB.ExecuteAsync(@"UPDATE USER_GROUPS SET NAME= @NAME WHERE ID = @GROUPiD", dt, transaction); await _connection.DB.ExecuteAsync(@"UPDATE USERS SET FIRST_NAME= @FiRST_NAME WHERE GROUPID = @GROUPiD AND ID = @UseriD", dt.USERS, transaction); transaction.Commit(); result = true; } catch { transaction.Rollback(); } } return(result); }
public async Task <bool> InsertOneToOneAsync(GroupOneToOneDTO dt) { bool result = false; using (var transaction = _connection.DB.BeginTransaction()) { try { dt.USERS.GROUPiD = await _connection.DB.ExecuteScalarAsync <int>(@"INSERT USER_GROUPS(NAME) values(@NAME) select SCOPE_IDENTITY()", dt, transaction); await _connection.DB.ExecuteAsync(@"INSERT USERS(USERTYPEID,GROUPID,FIRST_NAME,LAST_NAME,EMAIL,PASSWORD,PHONE) values(@USERTYPEiD,@GROUPiD,@FiRST_NAME,@LAST_NAME,@EMAiL,@PASSWORD,@PHONE); select SCOPE_IDENTITY();", dt.USERS, transaction); transaction.Commit(); result = true; } catch { transaction.Rollback(); } } return(result); }
public async Task <bool> InsertOneToOneAsync(GroupOneToOneDTO dt) { return(await _dapperUserDAL.InsertOneToOneAsync(dt)); }
public Task <bool> DeleteOneToOneAsync(GroupOneToOneDTO dt) { throw new NotImplementedException(); }