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