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