public static List <BrowseModel> executeLeaveRequsetBrowsequery(filtercriteria param)
{
using (MySqlConnection sqlconn = new MySqlConnection(connectionstring))
{
sqlconn.Open();
return(sqlconn.Query <BrowseModel>("GetLeaveApprovalRequestForBrowse", param, commandType: CommandType.StoredProcedure).ToList());
}
}
// GET api/values
//public IEnumerable<string> Get()
//{
// return new string[] { "value1", "value2" };
//}
// GET api/values/5
public List <BrowseModel> Get([FromBody] filtercriteria value)
{
Helpers.LeaveApproval leaveapproval = new Helpers.LeaveApproval();
return(leaveapproval.BrowseLeaveRequest(value));
}
public List <BrowseModel> BrowseLeaveRequest(filtercriteria value)
{
return(Repository.executeLeaveRequsetBrowsequery(value));
}