public List <Medical_Rec> GetMedicalRec(string QRID)
{
//////////////////////////////
List <Medical_Rec> mr = new List <Medical_Rec>();
try
{
string connectionString = ConfigurationManager.ConnectionStrings["ConnDB"].ConnectionString;
//////////////////////////////
MySqlConnection conn = new MySqlConnection(connectionString);
//string query = "SELECT * FROM Pilgrims where QRID =@QRID"; //'" + QRID + "'
string query = @"SELECT MRID,MRTYPE,MRVALUE FROM `Medical_Rec` WHERE QRID = @QRID";
MySqlCommand cmd = new MySqlCommand(query, conn);
cmd.Parameters.Add("@QRID", QRID);
conn.Open();
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows == false)
{
var m = new Medical_Rec
{
CODE = "200",
MSG = "FALSE",
};
mr.Add(m);
return(mr);
}
while (dr.Read())
{
var m = new Medical_Rec
{
CODE = "100",
MSG = "TRUE",
MRID = dr["MRID"].ToString(),
MRTYPE = dr["MRTYPE"].ToString(),
MRVALUE = dr["MRVALUE"].ToString()
};
mr.Add(m);
}
//Close Connection
dr.Close();
conn.Close();
return(mr);
}
catch (Exception ex)
{
var m = new Medical_Rec
{
CODE = "500",
MSG = "FALSE",
};
mr.Add(m);
return(mr);
}
}
public Medical_Rec GetMedicalRec2(string QRID)
{
Medical_Rec MR = new Medical_Rec();
//////////////////////////////
try
{
string connectionString = ConfigurationManager.ConnectionStrings["ConnDB"].ConnectionString;
//////////////////////////////
MySqlConnection conn = new MySqlConnection(connectionString);
string query = @"SELECT MRID,MRTYPE,MRVALUE FROM `Medical_Rec` WHERE QRID = @QRID";
MySqlCommand cmd = new MySqlCommand(query, conn);
cmd.Parameters.Add("@QRID", QRID);
conn.Open();
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows == false)
{
MR.CODE = "200";
MR.MSG = "FALSE";
return(MR);
}
while (dr.Read())
{
MR.MRVALUE += dr["MRVALUE"].ToString() + '/';
}
MR.CODE = "100";
MR.MSG = "TRUE";
return(MR);
}
catch (Exception ex)
{
MR.CODE = "500";
MR.MSG = "FALSE";
return(MR);
}
}
