public static List <RestaurantMenuEntity> RestaurantMenusubCategory(subMenuModel _SubCategory) { List <RestaurantMenuEntity> _ListingEntity = new List <RestaurantMenuEntity>(); using (var connection = SQLConnection.GetOpenSQLConnection()) { string sqlQuery = "RestaurantMenusubCategory @category"; _ListingEntity = connection.Query <RestaurantMenuEntity>(sqlQuery, new { category = _SubCategory.category }).ToList <RestaurantMenuEntity>(); } return(_ListingEntity); }
public HttpResponseMessage SubCategory(subMenuModel _SubCategory) { HttpResponseMessage response; List <RestaurantMenuEntity> userData = new List <RestaurantMenuEntity>(); try { if (string.IsNullOrEmpty(_SubCategory.category)) { response = Request.CreateResponse(HttpStatusCode.PreconditionFailed, "Category can not be zero or null!"); } else { userData = RestaurantMenuProcCall.RestaurantMenusubCategory(_SubCategory); response = Request.CreateResponse(HttpStatusCode.OK, userData); } } catch (Exception) { response = Request.CreateResponse(HttpStatusCode.InternalServerError); } return(response); }