///<summary>Inserts one row per UserOD if they do not have one already.</summary> private static void InsertMissingValues() { //No need to check RemotingRole; private static. string command = "SELECT * FROM userod WHERE IsHidden=0 AND UserNum NOT IN (SELECT UserNum from cdsPermission)"; List <Userod> uods = Crud.UserodCrud.SelectMany(command); CDSPermission cdsp; for (int i = 0; i < uods.Count; i++) { cdsp = new CDSPermission(); cdsp.UserNum = uods[i].UserNum; CDSPermissions.Insert(cdsp); } return; }
///<summary>Inserts one row per UserOD if they do not have one already.</summary> private static void InsertMissingValues() { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { Meth.GetVoid(MethodBase.GetCurrentMethod()); return; } string command = "SELECT * FROM userod WHERE IsHidden=0 AND UserNum NOT IN (SELECT UserNum from cdsPermission)"; List <Userod> uods = Crud.UserodCrud.SelectMany(command); CDSPermission cdsp; for (int i = 0; i < uods.Count; i++) { cdsp = new CDSPermission(); cdsp.UserNum = uods[i].UserNum; CDSPermissions.Insert(cdsp); } return; }