public Pilgrim GetOnePilgrim(string QRID)
{
Pilgrim p = new Pilgrim();
try
{
string connectionString = ConfigurationManager.ConnectionStrings["ConnDB"].ConnectionString;
//List<string>[] list = new List<string>[8];
//////////////////////////////
MySqlConnection conn = new MySqlConnection(connectionString);
//string query = "SELECT * FROM Pilgrims where QRID =@QRID"; //'" + QRID + "'
string query = @"SELECT Pilgrims.PID,Pilgrims.QRID,Pilgrims.PASSPORTID,Pilgrims.FULLNAME,Pilgrims.NATIONALITY,
Pilgrims.BLOOD,Pilgrims.ADDRESS,
Offices.OID OFFOID,Offices.LIC_NUM,Offices.NAME,Offices.ADDRESS OFFADDRESS,Offices.PHONE,Offices.MOBILE
FROM Pilgrims,Offices
where QRID = @QRID AND Pilgrims.OID = Offices.OID";
MySqlCommand cmd = new MySqlCommand(query, conn);
cmd.Parameters.Add("@QRID", QRID);
conn.Open();
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows == false)
{
p.MSG = "FALSE";
p.CODE = "200";
}
while (dr.Read())
{
p.MSG = "TRUE";
p.CODE = "100";
p.PID = dr["PID"].ToString();
p.QRID = dr["QRID"].ToString();
//p.OID = dr["OID"].ToString();
p.PASSPORTID = dr["PASSPORTID"].ToString();
p.FULLNAME = dr["FULLNAME"].ToString();
p.NATIONALITY = dr["NATIONALITY"].ToString();
p.BLOOD = dr["BLOOD"].ToString();
p.ADDRESS = dr["ADDRESS"].ToString();
p.OFFOID = dr["OFFOID"].ToString();
p.OFFLIC_NUM = dr["LIC_NUM"].ToString();
p.OFFNAME = dr["NAME"].ToString();
p.OFFADDRESS = dr["OFFADDRESS"].ToString();
p.OFFPHONE = dr["PHONE"].ToString();
p.OFFMOBILE = dr["MOBILE"].ToString();
}
//Close Connection
dr.Close();
conn.Close();
return(p);
}
catch (Exception ex)
{
p.MSG = ex.Message;
p.CODE = "500";
return(p);
}
}
protected void editPilgrimInfo_Click(object sender, EventArgs e)
{
string pilgrimId = Session["adminPilgrimID"].ToString();
BsonDocument document = operations.findPilgrim(pilgrimId);
string fullName = txt_edit_fullName.Text;
string userId = txt_edit_userId.Text;
string nationality = txt_edit_nationality.Text;
string residency = txt_edit_residency.Text;
double credit = Convert.ToDouble(txt_edit_credit.Text);
string phone = txt_edit_phone.Text;
BsonBinaryData fpdata = document["fingerprintData"].AsBsonBinaryData;
Pilgrim newP = new Pilgrim(fullName, txt_edit_pilgrimId.Text, userId, nationality, residency, fpdata, credit, phone);
operations.editPilgrimInfo(pilgrimId, newP.getBsonDoc());
}
public List <Pilgrim> GetAllPilgrim()
{
string connectionString = ConfigurationManager.ConnectionStrings["ConnDB"].ConnectionString;
List <string>[] list = new List <string> [8];
//////////////////////////////
MySqlConnection conn = new MySqlConnection(connectionString);
string query = "SELECT * FROM Pilgrims";
MySqlCommand cmd = new MySqlCommand(query, conn);
conn.Open();
List <Pilgrim> Pilmm = new List <Pilgrim>();
MySqlDataReader dr = cmd.ExecuteReader();
//PID QRID OID PASSPORTID FULLNAME NATIONALITY BLOOD ADDRESS
while (dr.Read())
{
var Pilm = new Pilgrim
{
PID = dr["PID"].ToString(),
QRID = dr["QRID"].ToString(),
OID = dr["OID"].ToString(),
PASSPORTID = dr["PASSPORTID"].ToString(),
FULLNAME = dr["FULLNAME"].ToString(),
BLOOD = dr["BLOOD"].ToString(),
ADDRESS = dr["ADDRESS"].ToString()
};
Pilmm.Add(Pilm);
}
//Close Connection
dr.Close();
conn.Close();
return(Pilmm);
}
protected void registerBtn_Click(object sender, EventArgs e)
{
string fullName = txt_new_fullName.Text;
string pilgrimId = txt_new_pilgrimId.Text;
string userId = txt_new_userId.Text;
string nationality = txt_new_nationality.Text;
string residency = txt_new_residency.Text;
double credit = Convert.ToDouble(txt_new_credit.Text);
string phone = txt_new_phone.Text;
Bitmap fpImage = new Bitmap(fingerPrint.PostedFile.InputStream);
byte[] data;
using (MemoryStream stream = new MemoryStream())
{
fpImage.Save(stream, System.Drawing.Imaging.ImageFormat.Png);
data = stream.ToArray();
}
// test
//BsonDocument pilgrim = operations.findPilgrim(pilgrimId);
if (operations.findPilgrim(pilgrimId) == null)
{
Pilgrim newP = new Pilgrim(fullName, pilgrimId, userId, nationality, residency, data, credit, phone);
operations.createNewPilgrimAccount(newP.getBsonDoc());
}
else
{
// the id already exists
}
}
