public static List <Cases> ListOnline(string Q)
{
try
{
p.Clear();
MySqlDataReader Reader = MySQL.Reading(Q);
while (Reader.Read())
{
Cases ps = new Cases(Reader["id"].ToString(), Reader["date"].ToString(), Reader["no"].ToString(), Reader["provideNo"].ToString(), Reader["coverageID"].ToString(), Reader["customerID"].ToString(), Reader["practitionerID"].ToString(), Reader["practitionerType"].ToString(), Reader["roleType"].ToString(), Reader["type"].ToString(), Reader["place"].ToString(), Reader["information"].ToString(), Reader["created"].ToString(), Reader["reqStart"].ToString(), Reader["reqEnd"].ToString(), Reader["authStart"].ToString(), Reader["authEnd"].ToString(), Reader["sync"].ToString(), Reader["companyID"].ToString());
p.Add(ps);
}
DBConnect.CloseMySqlConn();
}
catch { }
return(p);
}
public static List <Cases> List(string Q)
{
//try
//{
p.Clear();
MySqlDataReader Reader = MySQL.Reading(Q);
while (Reader.Read())
{
Cases ps = new Cases(Reader["id"].ToString(), Reader["date"].ToString(), Reader["no"].ToString(), Reader["provideNo"].ToString(), Reader["coverageID"].ToString(), Reader["customerID"].ToString(), Reader["practitionerID"].ToString(), Reader["practitionerType"].ToString(), Reader["roleType"].ToString(), Reader["type"].ToString(), Reader["place"].ToString(), Reader["information"].ToString(), Reader["created"].ToString(), Reader["reqStart"].ToString(), Reader["reqEnd"].ToString(), Reader["authStart"].ToString(), Reader["authEnd"].ToString(), Reader["sync"].ToString(), Reader["companyID"].ToString());
p.Add(ps);
}
DBConnect.CloseMySqlConn();
//}
//catch (Exception e)
//{
// System.Diagnostics.Debug.WriteLine("" + e);
//}
return(p);
}