public bool Create(List <SYS_Logger_Layer> models)
{
try
{
using (var context = new SystemEntities())
{
if (models != null && models.Count > 0)
{
var addModel = context.SYS_Logger_Layer.AddRange(models);
var result = context.SaveChanges();
return(result > 0);
}
else
{
return(false);
}
}
}
catch (Exception e)
{
throw e;
}
}
public bool Delete(long id)
{
try
{
using (var context = new SystemEntities())
{
var model = context.SYS_Logger_Capability.FirstOrDefault(f => f.ID.Equals(id));
if (model != null)
{
context.SYS_Logger_Capability.Remove(model);
return(context.SaveChanges() > 0);
}
else
{
return(false);
}
}
}
catch (Exception e)
{
throw e;
}
}
public bool Delete(string id)
{
try
{
using (var context = new SystemEntities())
{
var model = context.SYS_Version.FirstOrDefault(f => f.VersionCode.Equals(id));
if (model != null)
{
context.SYS_Version.Remove(model);
return(context.SaveChanges() > 0);
}
else
{
return(false);
}
}
}
catch (Exception e)
{
throw e;
}
}
public SYS_Version Create(SYS_Version model)
{
using (var context = new SystemEntities())
{
if (model != null)
{
var addModel = context.SYS_Version.Add(model);
var result = context.SaveChanges();
if (result > 0)
{
return(addModel);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
}
public bool Update(string id, SYS_Version model)
{
if (model == null)
{
throw new ArgumentNullException();
}
using (var context = new SystemEntities())
{
var baseModel = context.SYS_Version.FirstOrDefault(f => f.VersionCode.Equals(id));
if (baseModel == null)
{
throw new NullReferenceException("Không tìm thấy đối tượng trong cơ sở dữ liệu");
}
else
{
model.VersionCode = id;
context.Entry(baseModel).CurrentValues.SetValues(model);
//context.Entry(model).State = System.Data.Entity.EntityState.Modified;
//context.SYS_Layer.Attach(model);
return(context.SaveChanges() > 0);
}
}
}
public SYS_Version CheckUpdate(string applicationId, string version)
{
using (var context = new SystemEntities())
{
var currentModel = this.Get(version);
if (currentModel == null)
{
return(null);
}
if (currentModel == null)
{
return(null);
}
var lastVersion = context.SYS_Version
.Where(w => w.ApplicationId.Equals(applicationId))
.OrderByDescending(o => o.Date)
.Take(1)
.FirstOrDefault();
if (lastVersion != null)
{
// nếu là version mới
if (currentModel.Date < lastVersion.Date)
{
return(lastVersion);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
}
public LoginInfo GetDataAggTraceInfo(string dataSourceId, ref string retsLoginURL)
{
//RdcCode is data source id.
LoginInfo loginInfo = null;
using (SystemEntities se = new SystemEntities())
{
try
{
var loginTraceInfo = se.spDA_RETSConnectionInfo_sel(dataSourceId.ToString(CultureInfo.InvariantCulture),
false).FirstOrDefault();
//var dataSourceResult =
// se.spDA_TCSDatasource_sel(moduleId.ToString(CultureInfo.InvariantCulture), false).ToList();
//if (dataSourceResult.Count == 0)
//{
// return null;
//}
//string traceName = string.Empty;
//foreach (var item in dataSourceResult)
//{
// if (!item.OriginalDataSourceID.Equals(dataSourceId)) continue;
// traceName = item.datasourcename.Trim();
// break;
//}
//if (string.IsNullOrEmpty(traceName) || traceName.EndsWith("Test", StringComparison.OrdinalIgnoreCase))
//{
// return null;
//}
if (loginTraceInfo != null)
{
loginInfo = new LoginInfo
{
UserName = loginTraceInfo.RETSUserName,
Password = loginTraceInfo.RETSPassword,
UserAgent = loginTraceInfo.RETSUserAgent,
UaPassword = loginTraceInfo.RETSUserAgentPassword,
ByPassAuthentication = "1"
};
retsLoginURL = loginTraceInfo.RETSLoginURL;
}
//se.Connection.Open();
//ObjectResult<spDA_RETSConnectionInfo_sel_Result> loginTrace =
// se.spDA_TCSDatasource_sel(dataSourceId, false);
//foreach (var connInfo in loginTrace)
//{
// ModuleLoginContainer connection = new ModuleLoginContainer();
// connection.LoginURL = connInfo.RETSLoginURL;
// connection.LoginUserName = connInfo.RETSUserName;
// connection.LoginPassword = connInfo.RETSPassword;
// connection.UserAgent = connInfo.RETSUserAgent;
// connection.UserAgentPW = connInfo.RETSUserAgentPassword;
// connections.Add(connection);
//}
}
catch (Exception ex)
{
}
}
return(loginInfo);
}
/// <summary>
/// Overridden to ensure that a connection to the database can be established.
/// Waits as long as a connection becomes available so that further flow can execute as intended.
/// </summary>
protected override void InitializeOverride()
{
base.InitializeOverride();
SystemEntities.EnsureDatabaseReachable();
}
