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)); }