public async Task SubmitforPartnerShip_submitforApprovalofpartnership()
{
//Arrange
string userid = "222", userName = "******";
string RequestID = "";
Random ObjRan = new Random();
RequestID = Convert.ToString(ObjRan.Next(1000000, 99999999));
Submitforpartnership objSubmitforpartnership = new Submitforpartnership();
objSubmitforpartnership.UserID = userid;
objSubmitforpartnership.UserName = userName;
objSubmitforpartnership.AadharNum = "12341234";
objSubmitforpartnership.AadharPic = "";
objSubmitforpartnership.AddtionalDocument = "";
objSubmitforpartnership.AddtionalDocumentDetail = "";
SubmitforpartnershipResponse objSubmitforpartnershipResponse = new SubmitforpartnershipResponse();
objSubmitforpartnershipResponse.PartnerShipRequestID = RequestID;
objSubmitforpartnershipResponse.ResponseMessage = "Submitted User for ParnerShip";
objSubmitforpartnershipResponse.UserID = userid;
objSubmitforpartnershipResponse.UserName = userName;
_eventBookingService.Setup(x => x.SubmitforPartnerShip(objSubmitforpartnership, RequestID)).ReturnsAsync(objSubmitforpartnershipResponse);
//Act
var customer = await _EventBookingController.SubmitforPartnerShip(objSubmitforpartnership);
//Assert
Assert.NotNull(customer);
}
public async Task <SubmitforpartnershipResponse> SubmitforPartnerShip(Submitforpartnership ObjSubmitforpartnership, string RequestID)
{
SubmitforpartnershipResponse objSubmitforpartnershipResponse = new SubmitforpartnershipResponse();
string ResponseMessage = await _eventBookingRepository.SubmitforPartnerShipDB(ObjSubmitforpartnership, RequestID);
objSubmitforpartnershipResponse.ResponseMessage = ResponseMessage;
objSubmitforpartnershipResponse.UserID = ObjSubmitforpartnership.UserID;
objSubmitforpartnershipResponse.UserName = ObjSubmitforpartnership.UserName;
objSubmitforpartnershipResponse.PartnerShipRequestID = RequestID;
return(objSubmitforpartnershipResponse);
}
public async Task <IActionResult> SubmitforPartnerShip(Submitforpartnership ObjSubmitforpartnership)
{
string RequestID = "";
Random ObjRan = new Random();
RequestID = Convert.ToString(ObjRan.Next(1000000, 99999999));
var bookEntities = await _eventBookingService.SubmitforPartnerShip(ObjSubmitforpartnership, RequestID);
return(Ok(bookEntities));
}
public async Task SubmitforPartnerShip_submitforApprovalofpartnership()
{
//Arrange
string userid = "222", userName = "******";
string RequestID = "";
Random ObjRan = new Random();
RequestID = Convert.ToString(ObjRan.Next(1000000, 99999999));
Submitforpartnership objSubmitforpartnership = new Submitforpartnership();
objSubmitforpartnership.UserID = userid;
objSubmitforpartnership.UserName = userName;
objSubmitforpartnership.AadharNum = "12341234";
objSubmitforpartnership.AadharPic = "";
objSubmitforpartnership.AddtionalDocument = "";
objSubmitforpartnership.AddtionalDocumentDetail = "";
string queryString = "";
queryString = "sp_SubmitforPartnerShip @UserID,@userName,@AadharNum,@AadharImange,@AdditionalDocImage,@AddtionDocDetails,@BookingID,@ResponseMessage OUT";
_eventDBMock.Setup(x => x.ExecuteAsyncSql(It.IsAny <SqlParameter[]>(), queryString, 7)).ReturnsAsync("Submitted User for ParnerShip");
SubmitforpartnershipResponse objSubmitforpartnershipResponse = new SubmitforpartnershipResponse();
objSubmitforpartnershipResponse.PartnerShipRequestID = RequestID;
objSubmitforpartnershipResponse.ResponseMessage = "Submitted User for ParnerShip";
objSubmitforpartnershipResponse.UserID = userid;
objSubmitforpartnershipResponse.UserName = userName;
//Act
var customer = await _eventBookingRepository.SubmitforPartnerShipDB(objSubmitforpartnership, RequestID);
//Assert
Assert.Equal(objSubmitforpartnershipResponse.ResponseMessage, customer);
}
public async Task <string> SubmitforPartnerShipDB(Submitforpartnership ObjSubmitforpartnership, string RequestID)
{
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(ObjSubmitforpartnership.UserID)?String.Empty:ObjSubmitforpartnership.UserID
},
new SqlParameter()
{
ParameterName = "@userName",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 100,
Direction = System.Data.ParameterDirection.Input,
Value = string.IsNullOrEmpty(ObjSubmitforpartnership.UserName)?String.Empty:ObjSubmitforpartnership.UserName
},
new SqlParameter()
{
ParameterName = "@AadharNum",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 20,
Direction = System.Data.ParameterDirection.Input,
Value = string.IsNullOrEmpty(ObjSubmitforpartnership.AadharNum)?String.Empty:ObjSubmitforpartnership.AadharNum
},
new SqlParameter()
{
ParameterName = "@AadharImange",
SqlDbType = System.Data.SqlDbType.Image,
Size = 100,
Direction = System.Data.ParameterDirection.Input,
Value = string.IsNullOrEmpty(ObjSubmitforpartnership.AadharPic)? Convert.FromBase64String(string.Empty): Convert.FromBase64String(ObjSubmitforpartnership.AadharPic)
},
new SqlParameter()
{
ParameterName = "@AdditionalDocImage",
SqlDbType = System.Data.SqlDbType.Image,
Size = 100,
Direction = System.Data.ParameterDirection.Input,
Value = string.IsNullOrEmpty(ObjSubmitforpartnership.AddtionalDocument)?Convert.FromBase64String(string.Empty): Convert.FromBase64String(ObjSubmitforpartnership.AddtionalDocument)
},
new SqlParameter()
{
ParameterName = "@AddtionDocDetails",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 100,
Direction = System.Data.ParameterDirection.Input,
Value = string.IsNullOrEmpty(ObjSubmitforpartnership.AddtionalDocumentDetail)?String.Empty:ObjSubmitforpartnership.AddtionalDocumentDetail
},
new SqlParameter()
{
ParameterName = "@BookingID",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 30,
Direction = System.Data.ParameterDirection.Input,
Value = RequestID
},
new SqlParameter()
{
ParameterName = "@ResponseMessage",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = -1,
Direction = System.Data.ParameterDirection.Output
}
};
string queryString = "";
queryString = "sp_SubmitforPartnerShip @UserID,@userName,@AadharNum,@AadharImange,@AdditionalDocImage,@AddtionDocDetails,@BookingID,@ResponseMessage OUT";
ResponseMessage = await _IDBLayercs.ExecuteAsyncSql(param, queryString, 7);
//var _Context = new AuthenticationContext();
//int affectedRows = await _Context.Database.ExecuteSqlRawAsync("sp_SubmitforPartnerShip @UserID,@userName,@AadharNum,@AadharImange,@AdditionalDocImage,@AddtionDocDetails,@BookingID,@ResponseMessage OUT", param);
//ResponseMessage = Convert.ToString(param[7].Value);
}
catch (Exception ex)
{
ResponseMessage = ex.Message.ToString();
}
return(ResponseMessage);
}
