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