public DataTable GetFoodList() { try { return(DBOperate.GetDataTable("usp_GetFoodList")); } catch { throw; } }
public DataTable GetClientDetails(int ReportID) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@ReportID", ReportID) }; return(DBOperate.GetDataTable("csp_GetDashboardData", parameter)); } catch { throw; } }
public DataTable GetRecallDietDetails(int CustID) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@CustID", CustID) }; return(DBOperate.GetDataTable("usp_GetRecallDietDetails", parameter)); } catch { throw; } }
public DataTable GetRecallDietDetailsHistory(int CustID, string date) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@CustID", CustID), new SqlParameter("@date", date) }; return(DBOperate.GetDataTable("usp_GetRecallDietDetailsHistory", parameter)); } catch { throw; } }
public DataTable GetFoodMajorNutrients(string foodName, double foodQuantity, string foodUnit) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@foodName", foodName), new SqlParameter("@foodQuantity", foodQuantity), new SqlParameter("@foodUnit", foodUnit) }; return(DBOperate.GetDataTable("usp_GetFoodMajorNutrients", parameter)); } catch { throw; } }
/// <summary> /// Function to search for Patients /// </summary> /// <param name="searchText">string searchText</param> /// /// <param name="searchCriteria">string searchCriteria</param> /// <returns>DataTable</returns> public DataTable SearchPatients(string searchText, string searchCriteria, string session) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@searchText", searchText), new SqlParameter("@searchCriteria", searchCriteria), new SqlParameter("@Session", session) }; return(DBOperate.GetDataTable("csp_SearchPatients", parameter)); } catch { throw; } }