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