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();
}
}
internal static void CheckInDoc(IManDocument imDoc)
{
//using (new TransactionScope(
// TransactionScopeOption.Required,
// new TransactionOptions { IsolationLevel = IsolationLevel.ReadUncommitted }))
//{
using (var db = new ActiveDbContext())
{
var itemToRemove = db.CHECKOUT.SingleOrDefault(x => x.DOCNUM == imDoc.Number);
if (itemToRemove != null)
{
db.CHECKOUT.Remove(itemToRemove);
db.SaveChanges();
}
var original = db.DOCMASTER.SingleOrDefault(x => x.DOCNUM == imDoc.Number);
original.CHECKEDOUT = "N";
original.DOCINUSE = "N";
original.INUSEBY = null;
db.SaveChanges();
AddImHistoryInfo(imDoc, HistoryInfoType.CHECKIN);
}
//}
}
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 override Task SaveChangesAsync()
{
if (ActiveDbContext != null)
{
return(ActiveDbContext.SaveChangesAsync());
}
return(Task.CompletedTask);
}
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());
}
}
}
protected override void DisposeUow()
{
ActiveTransaction?.Dispose();
ActiveDbContext?.Dispose();
}
public override void SaveChanges()
{
ActiveDbContext?.SaveChanges();
}
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;
}
