public async Task <ManagementObjectSearcher> GetCardHolder(string idLenel)
{
ManagementScope cardHolderScope = _dataConduITMgr.GetManagementScope();
ObjectQuery cardHolderSearcher = new ObjectQuery("SELECT * FROM Lnl_CardHolder WHERE ID = " + idLenel);
ManagementObjectSearcher getCardHolder = new ManagementObjectSearcher(cardHolderScope, cardHolderSearcher);
try { return(getCardHolder); }
catch (Exception ex) { throw new Exception(ex.Message); }
}
public async Task <ManagementObjectSearcher> GetBuildings(string path, string user, string password, int?id)
{
ManagementScope buildingScope = _dataConduITMgr.GetManagementScope(path, user, password);
ObjectQuery buildingSearcher = new ObjectQuery();
if (id != null)
{
buildingSearcher.QueryString = @"SELECT * FROM Lnl_Edificio WHERE ID = " + id;
}
else
{
buildingSearcher.QueryString = @"SELECT * FROM Lnl_Edificio";
}
ManagementObjectSearcher getBuildings = new ManagementObjectSearcher(buildingScope, buildingSearcher);
try { return(getBuildings); }
catch (Exception ex) { throw new Exception("error: " + ex.Message + " " + ex.StackTrace + " " + ex.InnerException); }
}
public async Task <object> AddBadge(AddBadge_DTO newBadge, string path, string user, string pass)
{
try
{
ManagementScope badgeScope = _dataConduITMgr.GetManagementScope(path, user, pass);
ManagementClass badgeClass = new ManagementClass(badgeScope, new ManagementPath("Lnl_Badge"), null);
ManagementObject newBadgeInstance = badgeClass.CreateInstance();
string fechaDesactivacion = newBadge.fechaActivacion.ToString("yyyyMMdd") + "000000.000000-300";
newBadgeInstance["ID"] = newBadge.id;
newBadgeInstance["PERSONID"] = newBadge.personId;
newBadgeInstance["STATUS"] = newBadge.status; //Active
newBadgeInstance["TYPE"] = newBadge.type; // Employee
newBadgeInstance["DEST_EXEMPT"] = newBadge.dest_exemp; // Sometimes teh value is required
newBadgeInstance["ACTIVATE"] = newBadge.fechaActivacion.ToString("yyyyMMdd") + "000000.000000-300";
newBadgeInstance["DEACTIVATE"] = newBadge.fechaDesactivacion.ToString("yyyyMMdd") + "000000.000000-300";
ManagementBaseObject inParams = badgeClass.GetMethodParameters("AddBadge");
inParams.Properties["BadgeIn"].Value = newBadgeInstance;
//Execute the method
ManagementBaseObject outParamObject = badgeClass.InvokeMethod("AddBadge", inParams, null);
if (outParamObject != null)
{
//Display results
object outObj = outParamObject["BadgeOut"];
ManagementBaseObject addedBadge = (ManagementBaseObject)outObj;
return(addedBadge["BADGEKEY"]);
}
else
{
throw new Exception("No se pudo crear el nuevo Badge");
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public async Task <ManagementObjectSearcher> GetCardHolder(string idLenel, string path, string user, string password)
{
ManagementScope cardHolderScope = _dataConduITMgr.GetManagementScope(path, user, password);
ObjectQuery cardHolderSearcher = new ObjectQuery(@"SELECT * FROM Lnl_CardHolder WHERE OPHONE = '" + idLenel + "'");
ManagementObjectSearcher getCardHolder = new ManagementObjectSearcher(cardHolderScope, cardHolderSearcher);
try { return(getCardHolder); }
catch (Exception ex) { throw new Exception("error: " + ex.Message + " " + ex.StackTrace + " " + ex.InnerException); }
}
public async Task <ManagementObjectSearcher> GetCardHolder(string documento, string ssno,
string path, string user, string password)
{
ManagementScope cardHolderScope = _dataConduITMgr.GetManagementScope(path, user, password);
ObjectQuery cardHolderSearcher =
new ObjectQuery(@"SELECT * FROM Lnl_CardHolder WHERE OPHONE = '" + documento + /*"' AND SSNO = '" + ssno +*/ "'");
ManagementObjectSearcher getCardHolder = new ManagementObjectSearcher(cardHolderScope, cardHolderSearcher);
try { return(getCardHolder); }
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public async Task <ManagementObjectSearcher> GetReaderData(string panelID, string readerID,
string path, string user, string pass)
{
ManagementScope readerScope = _dataConduITMgr.GetManagementScope(path, user, pass);
if (readerScope == null)
{
throw new Exception("No fue posible establecer conexion con OnGuard");
}
ObjectQuery readerSearcher = new ObjectQuery("SELECT * FROM Lnl_Reader WHERE PanelID='" + panelID + "' " +
"AND ReaderID='" + readerID + "'");
ManagementObjectSearcher getReader = new ManagementObjectSearcher(readerScope, readerSearcher);
try { return(getReader); }
catch (Exception ex) { throw new Exception(ex.Message); }
}