Example #1
0
 public static List<CUSTOM6> GetTableData_C6(string tableName)
 {
     using (new TransactionScope(
             TransactionScopeOption.Required,
             new TransactionOptions { IsolationLevel = IsolationLevel.ReadUncommitted }))
     {
         using (var db = new ActiveDbContext())
         {
             return db.CUSTOM6.ToList();
         }
     }
 }
Example #2
0
        public static void CreateWS(AuditManager.Model.WsCreate wsCreate)
        {
            //IM.Mgr.WsUtility.CreateWS(wsCreate)

            //using (new TransactionScope(
            //        TransactionScopeOption.Required,
            //        new TransactionOptions { IsolationLevel = IsolationLevel.ReadUncommitted }))
            //{
            using (var db = new ActiveDbContext())
            {
                var p = wsCreate.PartnerId.ToUserIdFromDnsName();
                var m = wsCreate.ManagerId.ToUserIdFromDnsName();

                var c4 = db.CUSTOM4.Where(x => x.CUSTOM_ALIAS.Equals(p)).FirstOrDefault();
                if (c4 == null)
                {
                    var p_db = WsUsrMgmt.SearchUsr(p, Model.UsrSearchBy.Email, true);

                    if (p_db != null && p_db.Count > 0)
                    {
                        var p_2_In = p_db.FirstOrDefault();

                        var p_In = db.CUSTOM4.Add(new CUSTOM4
                        {
                            CUSTOM_ALIAS = p_2_In.Name,
                            C_DESCRIPT = p_2_In.FullName,
                            EDITWHEN = DateTime.Now,
                            ENABLED = "Y",
                            IS_HIPAA = "N"
                        });

                        db.SaveChanges();
                    }
                    else
                    {
                        throw new Exception(string.Format("Failure creating workspace: Partner => {0} not defined in [DOCUSERS] table.", p));
                    }
                }

                var c6 = db.CUSTOM6.Where(x => x.CUSTOM_ALIAS.Equals(m)).FirstOrDefault();
                if (c6 == null)
                {
                    var m_db = WsUsrMgmt.SearchUsr(m, Model.UsrSearchBy.Email, true);

                    if (m_db != null && m_db.Count > 0)
                    {
                        var m_2_In = m_db.FirstOrDefault();

                        var m_In = db.CUSTOM6.Add(new CUSTOM6
                        {
                            CUSTOM_ALIAS = m_2_In.Name,
                            C_DESCRIPT = m_2_In.FullName,
                            EDITWHEN = DateTime.Now,
                            ENABLED = "Y",
                            IS_HIPAA = "N"
                        });

                        db.SaveChanges();
                    }
                    else
                    {
                        throw new Exception(string.Format("Failure creating workspace: Manager => {0} not defined in [DOCUSERS] table.", m));
                    }
                }
            }
            //}

            //var cur_Eng = AuditManager.Rep.Workspace.GetEngByEngNum(wsCreate.EngagementNumber, Model.WsLoadType.None, true);

            //if (cur_Eng == null
            //    || cur_Eng.Count == 0)
            //{
            //    IM.Mgr.WsUtility.CreateWS(wsCreate);
            //    AuditManager.Rep.WsOperation.UpdateWsProfile(wsCreate.EngagementNumber, wsCreate.WsProfile_TP, Model.UpdateProfileFrom.CreateWs);
            //    return;
            //}
            //else
            //{
            //    throw new Exception(string.Format("Workspace => {0} already exists.", wsCreate.EngagementNumber));
            //}

            IM.Mgr.WsUtility.CreateWS(wsCreate);

            //AuditManager.Rep.WsOperation.UpdateWsProfile(wsCreate.EngagementNumber, wsCreate.WsProfile_TP, Model.UpdateProfileFrom.CreateWs);

            return;
        }
Example #3
0
        public static dynamic GetProjectIdForEngNum(List<string> engNums)
        {
            using (new TransactionScope(
                    TransactionScopeOption.Required,
                    new TransactionOptions { IsolationLevel =  System.Transactions.IsolationLevel.ReadUncommitted }))
            {
                using (var db = new ActiveDbContext())
                {
                    var result = (
                            from dm in db.Set<DOCMASTER>()
                            join prj in db.Set<PROJECT>() on
                            dm.DOCNUM equals prj.DOCNUM
                            where
                            engNums.Contains(dm.C2ALIAS) &&
                            dm.C_ALIAS.Equals("WEBDOC", StringComparison.OrdinalIgnoreCase) &&
                            dm.DOCNAME.Equals("", StringComparison.OrdinalIgnoreCase)

                            select new { EngNum = dm.C2ALIAS, EngId = prj.PRJ_ID }).ToList();

                    return result;
                }
            }
        }
Example #4
0
        public static void GetEngNumWhereC4OrC6IsNull()
        {
            List<DOCMASTER> docMaster = null;

            using (new TransactionScope(
                    TransactionScopeOption.Required,
                    new TransactionOptions { IsolationLevel = IsolationLevel.ReadUncommitted }))
            {
                using (var db = new ActiveDbContext())
                {
                    //using (var tran = db.Database.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted))
                    //{

                    //}
                    docMaster = db.DOCMASTER.Where(x => (x.C6ALIAS == null) &&
                        (x.SUBCLASS_ALIAS.Equals("AUDIT", StringComparison.OrdinalIgnoreCase) ||
                        x.SUBCLASS_ALIAS.Equals("EAUDIT ENGAGEMENT", StringComparison.OrdinalIgnoreCase))).ToList();
                }
            }

            using (var db = new ActiveDbContext())
            {
                foreach (var dM in docMaster)
                {
                    dM.C6ALIAS = dM.C4ALIAS;
                }

                db.SaveChanges();
            }
        }