public DataTable WS_MSOGetProfileWithProgramId(int APP_ID, string programId) { int?appId = APP_ID; dt = new DataTable(); if (!IsMatchProgramId(programId)) { return(EmptyDataTable()); } ; if ((appId != null && appId == 5) || (appId != null && appId == 6)) { using (var cmd = new OleDbCommand(QueryDB.GetProfile(), Conn)) { Conn.Open(); using (var reader = cmd.ExecuteReader()) { dt.Load(reader); dt.TableName = "DPSDoctor"; insertLOG(APP_ID, "", 5); return(dt); } } } else { return(dt); } }
public DataTable WS_MSOGetMobilWithProgramId(int APP_ID, int PID, string programId) { int?appId = APP_ID; dt = new DataTable(); if (!IsMatchProgramId(programId)) { return(EmptyDataTable()); } if ((appId != null && appId == 5) || (appId != null && appId == 6)) { using (OleDbCommand cmd = new OleDbCommand(QueryDB.GetMobil(), Conn)) { Conn.Open(); cmd.Parameters.AddWithValue("PROFILE_ID", PID); using (var reader = cmd.ExecuteReader()) { dt.Load(reader); dt.TableName = "DPSMobile"; insertLOG(APP_ID, "", 8); } } } return(dt); }
public DataTable WS_MSOGetSpecialty(int APP_ID, int PID) { int?appId = APP_ID; dt = new DataTable(); if ((appId != null && appId == 5) || (appId != null && appId == 6)) { using (OleDbCommand cmd = new OleDbCommand(QueryDB.GetSpecialty(), Conn)) { Conn.Open(); cmd.Parameters.AddWithValue("PROFILE_ID", PID); using (var reader = cmd.ExecuteReader()) { dt.Load(reader); dt.TableName = "DPSSpecialty"; insertLOG(APP_ID, "", 7); } } } return(dt); }