public static void SetActiveButton(InventoryModuleObject instance, string value)
{
foreach (var prop in instance.GetType().GetProperties().Where(prop => prop.Name.Contains("Active")))
{
prop.SetValue(instance, false, null);
}
foreach (var prop in instance.GetType().GetProperties().Where(prop => prop.Name.Equals((value + "Active"))))
{
prop.SetValue(instance, true, null);
}
}
public InventoryModuleObject GetInventoryNotifiers(int id)
{
try
{
InventoryModuleObject result = new InventoryModuleObject();
using (DbConnection = new MsSqlPersistence(DbConnectionSettings))
{
if (DbConnection.IsConnected())
{
using (DbCommand)
{
DbCommand.CommandText = @"
SELECT
COUNT(DISTINCT notes.id) AS NotesCount
FROM inventory_notes as notes
where notes.parentid = @ID AND notes.delete_date IS NULL
";
DbCommand.Parameters.Add("@ID", System.Data.SqlDbType.Int).Value = id;
var table = DbConnection.ExecuteQuery(DbCommand);
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
result.NotesCount = row["NotesCount"].ToString();
}
}
}
else
{
throw new Exception("Unable to Connect");
}
}
return result;
}
catch
{
throw;
}
}