public async Task GetBookingStatus_ShouldReturnValidmessage_ifnoBookingfound()
{
//Arrange
string name = "monica", emailID = "", phonenum = "";
Bookingstatus ObjBookingstatus = new Bookingstatus();
ObjBookingstatus.UserID = "123";
ObjBookingstatus.UserName = name;
ObjBookingstatus.Email = emailID;
ObjBookingstatus.PhoneNum = phonenum;
BookingstatusResponse objres = new BookingstatusResponse();
objres.ResponseMessage = "No Bookings found";
List <DBBookingstatusResponse> obj = new List <DBBookingstatusResponse>();
_eventRepoMock.Setup(x => x.GetBookingStatusDB(ObjBookingstatus)).ReturnsAsync(obj);
//Act
var customer = await _EventBookingService.GetBookingStatus(ObjBookingstatus);
//Assert
Assert.Equal(objres.ResponseMessage, customer.ResponseMessage);
}
public async Task <BookingstatusResponse> GetBookingStatus(Bookingstatus ObjBookingstatus)
{
BookingstatusResponse ObjBookingstatusResponse = new BookingstatusResponse();
var events = await _eventBookingRepository.GetBookingStatusDB(ObjBookingstatus);
if (events.Count > 0)
{
for (int i = 0; i < events.Count; i++)
{
statusResponse ObjResponse = new statusResponse();
ObjResponse.UserID = events[i].UserID;
ObjResponse.BookingID = events[i].BookingID;
ObjResponse.Status = events[i].Status;
ObjResponse.EventID = events[i].EventID;
ObjResponse.EventName = events[i].EventName;
ObjResponse.EventTimings = events[i].EventTimings;
ObjResponse.EventStatus = events[i].EventStatus;
ObjResponse.EventDetails = events[i].EventDetails;
ObjBookingstatusResponse.response.Add(ObjResponse);
}
ObjBookingstatusResponse.ResponseMessage = "Booking Status found successfully";
}
else
{
ObjBookingstatusResponse.ResponseMessage = "No Bookings found";
}
return(ObjBookingstatusResponse);
}
public async Task GetBookingStatus_ShouldReturnBookingStatusifpresent()
{
//Arrange
string name = "monica", emailID = "", phonenum = "";
Bookingstatus ObjBookingstatus = new Bookingstatus();
ObjBookingstatus.UserID = "123";
ObjBookingstatus.UserName = name;
ObjBookingstatus.Email = emailID;
ObjBookingstatus.PhoneNum = phonenum;
statusResponse ObjResponse = new statusResponse();
ObjResponse.EventID = "1";
ObjResponse.EventName = "IPL";
ObjResponse.EventStatus = "Open";
ObjResponse.EventTimings = "7 PM";
ObjResponse.EventDetails = "MI vs CSK";
ObjResponse.UserID = "222";
ObjResponse.BookingID = "222";
ObjResponse.Status = "Booking Confirmed";
BookingstatusResponse objres = new BookingstatusResponse();
objres.response.Add(ObjResponse);
objres.ResponseMessage = "Booking Status found successfully";
List <DBBookingstatusResponse> obj = new List <DBBookingstatusResponse>();
DBBookingstatusResponse objresp = new DBBookingstatusResponse();
objresp.EventID = "1";
objresp.EventName = "IPL";
objresp.EventStatus = "Open";
objresp.EventTimings = "7 PM";
objresp.EventDetails = "MI vs CSK";
objresp.UserID = "222";
objresp.BookingID = "222";
objresp.Status = "Booking Confirmed";
obj.Add(objresp);
string query = "sp_CustBookingStatus @userID,@userName,@EmailID,@PhoneNum";
_eventDBMock.Setup(x => x.ExecuteAsyncTableProcedure <DBBookingstatusResponse>(It.IsAny <SqlParameter[]>(), query)).ReturnsAsync(obj);
//Act
var customer = await _eventBookingRepository.GetBookingStatusDB(ObjBookingstatus);
//Assert
Assert.NotNull(customer);
}
public async Task GetBookingStatus_ShouldReturnBookingStatusifpresent()
{
//Arrange
string name = "monica", emailID = "", phonenum = "";
Bookingstatus ObjBookingstatus = new Bookingstatus();
ObjBookingstatus.UserID = "123";
ObjBookingstatus.UserName = name;
ObjBookingstatus.Email = emailID;
ObjBookingstatus.PhoneNum = phonenum;
statusResponse ObjResponse = new statusResponse();
ObjResponse.EventID = "1";
ObjResponse.EventName = "IPL";
ObjResponse.EventStatus = "Open";
ObjResponse.EventTimings = "7 PM";
ObjResponse.EventDetails = "MI vs CSK";
ObjResponse.UserID = "222";
ObjResponse.BookingID = "222";
ObjResponse.Status = "Booking Confirmed";
BookingstatusResponse objres = new BookingstatusResponse();
objres.response.Add(ObjResponse);
objres.ResponseMessage = "Booking Status found successfully";
List <DBBookingstatusResponse> obj = new List <DBBookingstatusResponse>();
DBBookingstatusResponse objresp = new DBBookingstatusResponse();
objresp.EventID = "1";
objresp.EventName = "IPL";
objresp.EventStatus = "Open";
objresp.EventTimings = "7 PM";
objresp.EventDetails = "MI vs CSK";
objresp.UserID = "222";
objresp.BookingID = "222";
objresp.Status = "Booking Confirmed";
obj.Add(objresp);
_eventBookingService.Setup(x => x.GetBookingStatus(ObjBookingstatus)).ReturnsAsync(objres);
//Act
var customer = await _EventBookingController.GetBookingStatus(ObjBookingstatus);
//Assert
Assert.NotNull(customer);
}
public async Task <List <DBBookingstatusResponse> > GetBookingStatusDB(Bookingstatus ObjBookingstatus)
{
var param = new SqlParameter[] {
new SqlParameter()
{
ParameterName = "@userID",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 100,
Direction = System.Data.ParameterDirection.Input,
Value = string.IsNullOrEmpty(ObjBookingstatus.UserID)?String.Empty:ObjBookingstatus.UserID
},
new SqlParameter()
{
ParameterName = "@userName",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 100,
Direction = System.Data.ParameterDirection.Input,
Value = string.IsNullOrEmpty(ObjBookingstatus.UserName)?String.Empty:ObjBookingstatus.UserName
},
new SqlParameter()
{
ParameterName = "@EmailID",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 100,
Direction = System.Data.ParameterDirection.Input,
Value = string.IsNullOrEmpty(ObjBookingstatus.Email)?String.Empty:ObjBookingstatus.Email
},
new SqlParameter()
{
ParameterName = "@PhoneNum",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 100,
Direction = System.Data.ParameterDirection.Input,
Value = string.IsNullOrEmpty(ObjBookingstatus.PhoneNum)?String.Empty:ObjBookingstatus.PhoneNum
}
};
string query = "sp_CustBookingStatus @userID,@userName,@EmailID,@PhoneNum";
var events = await _IDBLayercs.ExecuteAsyncTableProcedure <DBBookingstatusResponse>(param, query);
return(events);
//var _Context = new AuthenticationContext();
//var events = _Context.Set<DBBookingstatusResponse>().FromSqlRaw("sp_CustBookingStatus @userID,@userName,@EmailID,@PhoneNum", param).ToList();
//return events;
}
public async Task <IActionResult> GetBookingStatus(Bookingstatus ObjBookingstatus)
{
var bookEntities = await _eventBookingService.GetBookingStatus(ObjBookingstatus);
return(Ok(bookEntities));
}
