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