public void CheckAvailabitity(string SearchString, string TableName, string TableColumn)
{
objDataAccess = DataAccess.NewDataAccess();
objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.ReadCommitted);
var isValueExists = false;
var objCheckAvailable = new CheckAvailable();
objDbCommand.AddInParameter("SearchString", SearchString);
objDbCommand.AddInParameter("TableName", TableName);
objDbCommand.AddInParameter("TableColumn", TableColumn);
try
{
isValueExists =
Convert.ToBoolean(objDataAccess.ExecuteScalar(objDbCommand, "ams.uspGetIsAvailable",
CommandType.StoredProcedure));
}
catch (Exception ex)
{
throw new Exception("Error : " + ex.Message);
}
finally
{
objDataAccess.Dispose(objDbCommand);
}
objCheckAvailable.SearchString = SearchString;
objCheckAvailable.ValueExists = isValueExists;
var js = new JavaScriptSerializer();
Context.Response.Write(js.Serialize(objCheckAvailable));
}
public async Task <IEnumerable <TypeOfRoomView> > CheckAvailable([FromBody] CheckAvailable req)
{
IEnumerable <TypeOfRoomView> result = new List <TypeOfRoomView>();
try
{
//format datetime for 2 param CheckIn and CheckOut
var CheckInStr = req.CheckIn.ToString("yyyy-MM-dd");
var CheckOutStr = req.CheckOut.ToString("yyyy-MM-dd");
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@AmountAdults", req.AmountAdults);
parameters.Add("@AmountChild", req.AmountChild);
parameters.Add("@CheckIn", CheckInStr);
parameters.Add("@CheckOut", CheckOutStr);
result = await SqlMapper.QueryAsync <TypeOfRoomView>(cnn : connection,
sql : "sp_CheckAvailable",
param : parameters,
commandType : CommandType.StoredProcedure);
return(result);
}
catch (Exception)
{
return(result);
}
}
public IActionResult CheckAvailable(CheckAvailable req)
{
ViewBag.CheckIn = req.CheckIn;
ViewBag.CheckOut = req.CheckOut;
var data = ApiHelper <List <TypeofRoomView> > .HttpPostAsync($"TypeofRoom/CheckAvailable", "POST", req);
foreach (var item in data)
{
item.ServiceViews = ApiHelper <List <ServiceView> > .HttpGetAsync($"TypeOfRoom/getservicebyroomtypeid/{item.Id}");
}
return(View(data));
}
public async Task <IEnumerable <TypeOfRoomView> > CheckAvailable([FromBody] CheckAvailable req)
{
return(await typeOfRoomRepository.CheckAvailable(req));
}
public async Task <OkObjectResult> CheckAvailable([FromBody] CheckAvailable req)
{
var result = await typeOfRoomService.CheckAvailable(req);
return(Ok(result));
}
