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