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