public static void DeleteKAppConfig(KAppConfig kAppConfig)
{
using (KDBContext db = new KDBContext())
{
db.KAppConfig.Remove(kAppConfig);
}
}
public static List<KeyValuePair<string, bool>> GetAllFailedEng()
{
List<KeyValuePair<string, bool>> result = new List<KeyValuePair<string, bool>>();
using (KDBContext db = new KDBContext())
{
using (var tran = db.Database.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted))
{
var faildedEng = db.KWSLog.Where(x =>
x.KWSLogType == KWSLogType.CreateWSFail
//&& !(x.Info.Contains("[NRTUser ][GetUser ]"))
//&& !(x.Info.Contains("Workspace already exists for "))
//&& !(x.Info.Contains("Client [ClientId"))
)
.Select(y => y.EngNum).Distinct().ToList();
var kpmgOnlyForFaildedEng = db.KWSInfo.Where(x => faildedEng.Contains(x.EngNum) && x.IsActive).ToList();
foreach (var item in kpmgOnlyForFaildedEng)
{
var info = KSerDSer.JDSerialize<List<KeyValuePair<string, object>>>(item.Info);
result.Add(new KeyValuePair<string, bool>(item.EngNum, bool.Parse(info.Find(x => x.Key.IsEquals("KPMGOnly")).Value.ToString())));
}
}
}
return result;
}
public static void AddKAppConfig(KAppConfig kAppConfig)
{
using (KDBContext db = new KDBContext())
{
kAppConfig.Value = KEncDec.EncryptText(kAppConfig.Value);
db.KAppConfig.Add(kAppConfig);
db.SaveChanges();
}
}
public static void DeletekWSLog(string strInfo)
{
using (KDBContext db = new KDBContext())
{
var dataToDelete = db.KWSLog.Where(x => x.Info.Contains(strInfo)).ToList();
db.KWSLog.RemoveRange(dataToDelete);
db.SaveChanges();
}
}
public static void DeleteKWSInfo()
{
using (KDBContext db = new KDBContext())
{
var dataToDelete = db.KWSInfo.Where(x => !(x.IsActive)).ToList();
db.KWSInfo.RemoveRange(dataToDelete);
db.SaveChanges();
}
}
public static void UpdateKAppConfig(KAppConfig kAppConfig)
{
using (KDBContext db = new KDBContext())
{
var found = db.KAppConfig.Find(kAppConfig.Key);
found.Value = kAppConfig.Value;
found.IsActive = kAppConfig.IsActive;
db.SaveChanges();
}
}
public static void KWSLog(KWSLog kWSLog)
{
kWSLog.InsertWhen = KConfig.GetKDateTimeUTC;
kWSLog.InsertWho = KConfig.GetCurrentUser;
using (KDBContext db = new KDBContext())
{
db.KWSLog.Add(kWSLog);
db.SaveChanges();
}
}
public static List<KAppConfig> GetKAppConfig()
{
using (KDBContext db = new KDBContext())
{
using (var tran = db.Database.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted))
{
var result = db.KAppConfig.ToList();
result.ForEach(x => x.Value = KEncDec.DecryptText(x.Value));
return result;
}
}
}
public static List<KWSLog> GetKWSLog(KWSLogType kWSLogType, string engNum = null, DateTime? fromDt = null, DateTime? toDt = null)
{
var fDate = fromDt.GetValueOrDefault(DateTime.MinValue).ToUniversalTime();
var tDate = toDt.GetValueOrDefault(DateTime.Now).GetToDate().ToUniversalTime();
using (KDBContext db = new KDBContext())
{
using (var tran = db.Database.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted))
{
List<KWSLog> result = null;
if (!string.IsNullOrWhiteSpace(engNum))
{
if (kWSLogType == KWSLogType.CreateWS)
result = db.KWSLog.Where(x => x.EngNum == engNum
&& (x.KWSLogType == KWSLogType.CreateWSAuto || x.KWSLogType == KWSLogType.CreateWSManual || x.KWSLogType == KWSLogType.CreateWSFail)
&& x.InsertWhen >= fDate
&& x.InsertWhen <= tDate
)
.OrderByDescending(x => x.InsertWhen).ToList();
else
result = db.KWSLog.Where(x => x.EngNum == engNum && x.KWSLogType == kWSLogType
&& x.InsertWhen >= fDate
&& x.InsertWhen <= tDate
).OrderByDescending(x => x.InsertWhen).ToList();
}
else
{
if (kWSLogType == KWSLogType.CreateWS)
result = db.KWSLog.Where(x => (x.KWSLogType == KWSLogType.CreateWSAuto || x.KWSLogType == KWSLogType.CreateWSManual || x.KWSLogType == KWSLogType.CreateWSFail)
&& x.InsertWhen >= fDate
&& x.InsertWhen <= tDate
)
.OrderByDescending(x => x.InsertWhen).ToList();
else
result = db.KWSLog.Where(x => x.KWSLogType == kWSLogType
&& x.InsertWhen >= fDate
&& x.InsertWhen <= tDate
).OrderByDescending(x => x.InsertWhen).ToList();
}
return result;
}
}
}
public static void KWSLogKFileActivity(KFileActivity kFileActivity)
{
kFileActivity.InsertWhen = KConfig.GetKDateTimeUTC;
kFileActivity.InsertWho = KConfig.GetCurrentUser;
kFileActivity.IsActive = true;
using (KDBContext db = new KDBContext())
{
db.KFileActivity.Add(kFileActivity);
db.SaveChanges();
}
}
public static void SendMail(int id, List<string> lstMailIds)
{
using (KDBContext db = new KDBContext())
{
using (var tran = db.Database.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted))
{
var kWSLogCreateWS = KSerDSer.JDSerialize<KWSLogCreateWS>(db.KWSLog.Where(x => x.Id == id).FirstOrDefault().Info);
lstMailIds.Add(KConfig.GetCurrentUser.ToKPMGEmail());
lstMailIds.ForEach(x =>
{
if (!kWSLogCreateWS.KMailModel.KMailInfo.To.Exists(y => y.Value.Key.IsEquals(x)))
{
kWSLogCreateWS.KMailModel.KMailInfo.To.Add(new KeyValuePair<UserType, KeyValuePair<string, string>>(UserType.Other, new KeyValuePair<string, string>(x, "")));
}
});
KMail.SendMail(kWSLogCreateWS.KMailModel.KMailInfo);
}
}
}
public static List<KWSInfo> GetKWSInfo(string num = null, DateTime? fromDt = null, DateTime? toDt = null)
{
var fDate = fromDt.GetValueOrDefault(DateTime.MinValue).ToUniversalTime();
var tDate = toDt.GetValueOrDefault(DateTime.Now).GetToDate().ToUniversalTime();
List<KWSInfo> result = null;
using (KDBContext db = new KDBContext())
{
using (var tran = db.Database.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted))
{
if (!string.IsNullOrWhiteSpace(num))
{
result = db.KWSInfo.Where(x => x.EngNum.Equals(num, StringComparison.OrdinalIgnoreCase)
&& x.InsertWhen >= fDate
&& x.InsertWhen <= tDate
)
.OrderByDescending(x => x.InsertWhen)
//.ThenBy(x => x.IsActive)
.ToList();
}
else
{
result = db.KWSInfo.Where(x =>
x.InsertWhen >= fDate
&& x.InsertWhen <= tDate
)
.OrderByDescending(x => x.InsertWhen)
//.ThenBy(x => x.IsActive)
.ToList();
}
}
}
if (result == null)
return null;
return result;
}
public static bool? GetKPMGOnly(string num)
{
KWSInfo result = null;
using (KDBContext db = new KDBContext())
{
using (var tran = db.Database.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted))
{
result = db.KWSInfo.Where(x => x.EngNum.Equals(num, StringComparison.OrdinalIgnoreCase) && x.IsActive).FirstOrDefault();
}
}
if (result == null)
return null;
var info = KSerDSer.JDSerialize<List<KeyValuePair<string, object>>>(result.Info);
return bool.Parse(info.Find(x => x.Key.IsEquals("KPMGOnly")).Value.ToString());
}
public static void UpdateWS(string num, bool? kPMGOnly)
{
List<KeyValuePair<string, object>> kvp = new List<KeyValuePair<string, object>>();
kvp.Add(new KeyValuePair<string, object>("KPMGOnly", kPMGOnly.Value));
using (KDBContext db = new KDBContext())
{
db.KWSInfo.Where(x => x.EngNum.Equals(num, StringComparison.OrdinalIgnoreCase)).ToList().ForEach(x => x.IsActive = false);
db.SaveChanges();
db.KWSInfo.Add(new KWSInfo { EngNum = num, InsertWhen = KConfig.GetKDateTimeUTC, InsertWho = KConfig.GetCurrentUser, IsActive = true, Info = KSerDSer.JSerialize<List<KeyValuePair<string, object>>>(kvp) });
db.SaveChanges();
}
}
