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