public async Task ParnershipApproval_Categoryofuserchanges()
{
//Arrange
string userid = "222", userName = "******";
string RequestID = "";
Random ObjRan = new Random();
RequestID = Convert.ToString(ObjRan.Next(1000000, 99999999));
PartnershipApproval objPartnershipApproval = new PartnershipApproval();
objPartnershipApproval.RequestID = RequestID;
objPartnershipApproval.UserID = userid;
objPartnershipApproval.UserName = userName;
PartnershipApprovalResponse objPartnershipApprovalResponse = new PartnershipApprovalResponse();
objPartnershipApprovalResponse.UserID = userid;
objPartnershipApprovalResponse.UserName = userName;
objPartnershipApprovalResponse.RequestID = RequestID;
objPartnershipApprovalResponse.ResponseMessage = "User has been approved for partnership";
_eventBookingService.Setup(x => x.ParnershipApproval(objPartnershipApproval)).ReturnsAsync(objPartnershipApprovalResponse);
//Act
var customer = await _EventBookingController.ParnershipApproval(objPartnershipApproval);
//Assert
Assert.NotNull(customer);
}
public async Task ParnershipApproval_Categoryofuserchanges()
{
//Arrange
string userid = "222", userName = "******";
string RequestID = "";
Random ObjRan = new Random();
RequestID = Convert.ToString(ObjRan.Next(1000000, 99999999));
PartnershipApproval objPartnershipApproval = new PartnershipApproval();
objPartnershipApproval.RequestID = RequestID;
objPartnershipApproval.UserID = userid;
objPartnershipApproval.UserName = userName;
string queryString = "";
queryString = "sp_PartnershipApprovalupdate @UserID,@userName,@BookingID,@ResponseMessage OUT";
_eventDBMock.Setup(x => x.ExecuteAsyncSql(It.IsAny <SqlParameter[]>(), queryString, 3)).ReturnsAsync("User has been approved for partnership");
PartnershipApprovalResponse objPartnershipApprovalResponse = new PartnershipApprovalResponse();
objPartnershipApprovalResponse.UserID = userid;
objPartnershipApprovalResponse.UserName = userName;
objPartnershipApprovalResponse.RequestID = RequestID;
objPartnershipApprovalResponse.ResponseMessage = "User has been approved for partnership";
//Act
var customer = await _eventBookingRepository.ParnershipApprovalDB(objPartnershipApproval);
//Assert
Assert.Equal(objPartnershipApprovalResponse.ResponseMessage, customer);
}
public async Task <PartnershipApprovalResponse> ParnershipApproval(PartnershipApproval objPartnershipApproval)
{
PartnershipApprovalResponse objPartnershipApprovalResponse = new PartnershipApprovalResponse();
string ResponseMessage = await _eventBookingRepository.ParnershipApprovalDB(objPartnershipApproval);
objPartnershipApprovalResponse.ResponseMessage = ResponseMessage;
objPartnershipApprovalResponse.UserID = objPartnershipApproval.UserID;
objPartnershipApprovalResponse.UserName = objPartnershipApproval.UserName;
objPartnershipApprovalResponse.RequestID = objPartnershipApproval.RequestID;
return(objPartnershipApprovalResponse);
}
public async Task <string> ParnershipApprovalDB(PartnershipApproval objPartnershipApproval)
{
string ResponseMessage = "";
try
{
var param = new SqlParameter[] {
new SqlParameter()
{
ParameterName = "@userID",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 10,
Direction = System.Data.ParameterDirection.Input,
Value = string.IsNullOrEmpty(objPartnershipApproval.UserID)?String.Empty:objPartnershipApproval.UserID
},
new SqlParameter()
{
ParameterName = "@userName",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 100,
Direction = System.Data.ParameterDirection.Input,
Value = string.IsNullOrEmpty(objPartnershipApproval.UserName)?String.Empty:objPartnershipApproval.UserName
},
new SqlParameter()
{
ParameterName = "@BookingID",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 30,
Direction = System.Data.ParameterDirection.Input,
Value = string.IsNullOrEmpty(objPartnershipApproval.RequestID)?String.Empty:objPartnershipApproval.RequestID
},
new SqlParameter()
{
ParameterName = "@ResponseMessage",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = -1,
Direction = System.Data.ParameterDirection.Output
}
};
string queryString = "";
queryString = "sp_PartnershipApprovalupdate @UserID,@userName,@BookingID,@ResponseMessage OUT";
ResponseMessage = await _IDBLayercs.ExecuteAsyncSql(param, queryString, 3);
//var _Context = new AuthenticationContext();
//int affectedRows = await _Context.Database.ExecuteSqlRawAsync("sp_PartnershipApprovalupdate @UserID,@userName,@BookingID,@ResponseMessage OUT", param);
//ResponseMessage = Convert.ToString(param[3].Value);
}
catch (Exception ex)
{
ResponseMessage = ex.Message.ToString();
}
return(ResponseMessage);
}
public async Task <IActionResult> ParnershipApproval(PartnershipApproval objPartnershipApproval)
{
var bookEntities = await _eventBookingService.ParnershipApproval(objPartnershipApproval);
return(Ok(bookEntities));
}