public static bool IsCodeExist(string originalValue, string currentValue, string table, string field, BTSS.Common.Core.Operation operation)
{
try
{
BTSSContext ctx = new BTSSContext(BTSS.Common.Core.ConnectionString);
return ctx.IsCodeExist(originalValue, currentValue, table, field, operation.ToString()).FirstOrDefault().IsExist.Value;
}
catch (Exception)
{
throw;
}
}
public void Save()
{
try
{
using (var transaction = new TransactionScope())
{
BTSSContext ctx = new BTSSContext(Global.ConnectionString);
ctx.SaveActiveDirectoryGroup(_Id, _Name, _Domain, _Operation.ToString());
transaction.Complete();
}
}
catch (Exception)
{
throw;
}
}
public void Save()
{
try
{
using (var transaction = new TransactionScope())
{
BTSSContext ctx = new BTSSContext(Global.ConnectionString);
ctx.SavePreferences(_Id, _Tag, _Value, _Operation.ToString());
transaction.Complete();
}
}
catch (Exception)
{
throw;
}
}
public void Save()
{
try
{
using (var transaction = new TransactionScope())
{
BTSSContext ctx = new BTSSContext(BTSS.Common.Core.ConnectionString);
if (_DataProvider == BTSS.Common.Core.DataProvider.OLEDB)
ctx.SaveProject(ref _Id, _Name, _Desc, _Version, _IsActive, _BusinessOwner, _Tester, _OtherContact, _DataProvider.ToString(), _File, _EnableBypassKey, _HasOtherDetails, _MDW, _Datasource, _SQLDatabaseName, _AccessUserId, _AccessPassword, _SharepointURL, _PathErrorLog, BTSS.Common.Core.UserName, _Operation.ToString());
else
ctx.SaveProject(ref _Id, _Name, _Desc, _Version, _IsActive, _BusinessOwner, _Tester, _OtherContact, _DataProvider.ToString(), _File, _EnableBypassKey, _HasOtherDetails, _MDW, _Datasource, _SQLDatabaseName, _SQLUserId, _SQLPassword, _SharepointURL, _PathErrorLog, BTSS.Common.Core.UserName, _Operation.ToString());
transaction.Complete();
}
}
catch (Exception)
{
throw;
}
}
private void Initialize()
{
try
{
preference = new Preference(Global.ConnectionString);
BTSSContext ctx = new BTSSContext(Global.ConnectionString);
var row = from s in ctx.Preferences
where s.Tag == Global.Preferences.AUDIT_TRAIL.ToString()
select new { s.Value };
if (row.Count() > 0)
{
checkBoxEnableAuditTrail.Checked = Convert.ToBoolean(row.FirstOrDefault().Value);
}
}
catch (Exception)
{
throw;
}
}
public void Save()
{
try
{
using (var transaction = new TransactionScope())
{
BTSSContext ctx = new BTSSContext(Global.ConnectionString);
ctx.SaveUser(ref _Id, _LastName, _FirstName, _MI, _UserName, _Password, Global.UserName, _Operation.ToString());
if (Operation != Global.Operation.DELETE)
{
if (_DataUserGroup.GetChanges() != null)
{
foreach (DataRow r in _DataUserGroup.GetChanges(DataRowState.Modified).Rows)
{
ctx.SaveUserGroup(r.Field<long?>("Id"), _Id, r.Field<string>("GroupId"));
}
}
if (_DataUserProject.GetChanges() != null)
{
foreach(DataRow r in _DataUserProject.GetChanges(DataRowState.Modified).Rows)
{
ctx.SaveUserProject(r.Field<long?>("Id"), _Id, r.Field<string>("ProjId"));
}
}
}
transaction.Complete();
}
}
catch (Exception)
{
throw;
}
}
public Project(string connectionString)
{
ctx = new BTSSContext(connectionString);
project = new BTSS.Data.Project(connectionString);
}
public ActiveDirectoryUsersList(string connectionString) { ctx = new BTSSContext(connectionString); }
public ClassProject(string connectionString) : base(connectionString, Global.DataProvider.SQL)
{
ctx = new BTSSContext(connectionString);
}
public Preference(string connectionString)
: base(connectionString, Global.DataProvider.SQL)
{
ctx = new BTSSContext(connectionString);
}
public Preferences(string connectionString)
{
ctx = new BTSSContext(connectionString);
}
public AuditTrail(string connectionString){ ctx = new BTSSContext(connectionString);}
public ActiveDirectoryGroup(string connectionString) { ctx = new BTSSContext(connectionString); }
public Group(string connectionString) {
ctx = new BTSSContext(connectionString);
group = new BTSS.Data.Group(connectionString);
}
public User(string connectionString) {
ctx = new BTSSContext(connectionString);
user = new BTSS.Data.User(connectionString);
}
