public void DeletePrivileges(string roleCode)
{
SecurityDataContext context = new SecurityDataContext();
var tobeDeleted = context.RoleCanPerforms.Where(x => x.RoleCode == roleCode);
context.RoleCanPerforms.DeleteAllOnSubmit(tobeDeleted);
context.SubmitChanges();
}
public void DeleteAccount(Guid accountId)
{
SecurityDataContext context = new SecurityDataContext();
var result = context.Accounts.Single(x => x.Id == accountId);
result.IsDeleted = true;
context.SubmitChanges();
}
public void DeleteReference(Guid id)
{
SecurityDataContext context = new SecurityDataContext();
//var result = context.References.Single(x => x.ReferenceTypeCode == referenceTypeCode && x.ReferenceCode == referenceCode);
var result = context.References.Single(x => x.Id == id);
result.IsDeleted = true;
context.SubmitChanges();
}
public void UpdateReference(Reference entity)
{
SecurityDataContext context = new SecurityDataContext();
var result = context.References.Single(x => x.ReferenceTypeCode == entity.ReferenceTypeCode && x.ReferenceCode == entity.ReferenceCode);
result.ReferenceValue = entity.ReferenceValue;
result.Sequence = entity.Sequence;
context.SubmitChanges();
}
public void ChangePassword(Guid accountId, string newPassword)
{
SecurityDataContext context = new SecurityDataContext();
var result = context.Accounts.Single(x => x.Id == accountId);
result.Password = newPassword;
result.ChangePasswordOnFirstLogon = false;
context.SubmitChanges();
}
public void AddPrivilege(string operationCode, string roleCode)
{
var entity = new RoleCanPerform();
entity.OperationCode = operationCode;
entity.RoleCode = roleCode;
SecurityDataContext context = new SecurityDataContext();
context.RoleCanPerforms.InsertOnSubmit(entity);
context.SubmitChanges();
}
public void DeleteAccountProfile(Guid accountProfileId,bool softDelete)
{
SecurityDataContext context = new SecurityDataContext();
var result = context.AccountProfiles.Single(x => x.Id == accountProfileId);
if (softDelete)
{
result.IsDeleted = true;
}
else
{
context.AccountProfiles.DeleteOnSubmit(result);
}
context.SubmitChanges();
}
public void AddRoles(Guid accountId, List<string> roleCodes)
{
SecurityDataContext context = new SecurityDataContext();
DeleteRoles(accountId);
foreach (string roleCode in roleCodes)
{
AccountHasRole ahr = new AccountHasRole()
{
AccountId = accountId,
RoleCode = roleCode
};
context.AccountHasRoles.InsertOnSubmit(ahr);
}
context.SubmitChanges();
}
public Guid? CreateAccountProfile(AccountProfile entity)
{
Guid? result = null;
try
{
SecurityDataContext context = new SecurityDataContext();
if (entity.Id == Guid.Empty)
entity.Id = Guid.NewGuid();
context.AccountProfiles.InsertOnSubmit(entity);
context.SubmitChanges();
result = entity.Id;
}
catch
{
}
return entity.Id;
}
public void UpdateAccountProfile(AccountProfile entity)
{
try
{
SecurityDataContext context = new SecurityDataContext();
var profile = context.AccountProfiles.Where(x => x.Id == entity.Id).FirstOrDefault();
profile.Id = entity.Id;
profile.FirstName = entity.FirstName;
profile.LastName = entity.LastName;
profile.FullName = entity.FullName;
profile.Title = entity.Title;
profile.JobTitle = entity.JobTitle; ;
profile.IsMale = entity.IsMale;
profile.IsDeleted = entity.IsDeleted;
context.SubmitChanges();
}
catch
{
}
}
public void CreateReference(Reference entity)
{
SecurityDataContext context = new SecurityDataContext();
context.References.InsertOnSubmit(entity);
context.SubmitChanges();
}
public void DeleteRoles(Guid accountId)
{
try
{
SecurityDataContext context = new SecurityDataContext();
var roles = context.AccountHasRoles.Where(x => x.AccountId == accountId).ToList();
context.AccountHasRoles.DeleteAllOnSubmit(roles);
context.SubmitChanges();
context.Dispose();
}
catch(Exception ex)
{
throw ex;
}
}
public void CreateAccount(Account entity)
{
SecurityDataContext context = new SecurityDataContext();
context.Accounts.InsertOnSubmit(entity);
context.SubmitChanges();
}
