public NEDAP GetNEDAPAccess(string emp_id) { var objReturn = new NEDAP(); using (var con = new MySqlConnection(ConnectionHelper.BaseXConnection())) { con.Open(); using (var cmd = new MySqlCommand("SELECT name, name_ara, tap FROM nedap WHERE emp_id=@emp_id", con)) { cmd.Parameters.AddWithValue("@emp_id", emp_id); using (var dr = cmd.ExecuteReader()) { if (dr.HasRows) { while (dr.Read()) { var tap = dr["tap"].ToString().ToUpper(); var mace = "MACE:57000000380000000"; var qrImg = QRGeneratorHelper.GenerateQR(mace + "" + tap); byte[] imageBytes = null; var converter = new ImageConverter(); imageBytes = (byte[])converter.ConvertTo(qrImg, typeof(byte[])); objReturn = new NEDAP { emp_id = emp_id, generated = imageBytes, name = dr["name"].ToString(), name_ara = dr["name_ara"].ToString(), remarks = "record found" }; } } else { objReturn = new NEDAP { emp_id = emp_id, remarks = "record not found" }; } dr.Close(); } } con.Close(); } return(objReturn); }
public NEDAP GetNEDAPAEOSDBAcccess(string emp_id) { var objReturn = new NEDAP(); using (var cn = new SqlConnection(ConnectionHelper.AEOSDBConnection())) { cn.Open(); var cmd = cn.CreateCommand(); cmd.CommandText = "SELECT * FROM dbo.view_badgeadministration WHERE identifiertype = 'Mifare CSN' AND carrieroid=(SELECT TOP 1 objectid FROM dbo.employee WHERE personnelnr=@emp_id OR email=@emp_id)"; cmd.Parameters.AddWithValue("@emp_id", emp_id); var dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { var tap = dr["badgenumber"].ToString().ToUpper(); var mace = "MACE:57000000380000000"; var qrImg = QRGeneratorHelper.GenerateQR(mace + "" + tap); byte[] imageBytes = null; var converter = new ImageConverter(); imageBytes = (byte[])converter.ConvertTo(qrImg, typeof(byte[])); objReturn = new NEDAP { emp_id = emp_id, generated = imageBytes, remarks = "record found" }; } } else { objReturn = new NEDAP { emp_id = emp_id, remarks = "record not found" }; } } return(objReturn); }