public List <CcSipBuddies> ListCcSipBuddies()
{
using (var context = new Mya2billingContext(options.Options))
{
List <CcSipBuddies> result = new List <CcSipBuddies>();
result = context.Set <CcSipBuddies>().ToList();
return(result);
}
}
public List <CcCard> GenerateMD5PasswordForAllAccounts()
{
using (var context = new Mya2billingContext(options.Options))
{
var users = context.Set <CcCard>().ToList();
foreach (var user in users)
{
var checkPass = Regex.IsMatch(user.Uipass, "^[0-9a-fA-F]{32}$", RegexOptions.Compiled);
if (checkPass || user.Status != 1)
{
continue;
}
string passwordGenerated = GenerateMD5FromString(user.Username + ":a2billing:" + user.Uipass);
user.Uipass = passwordGenerated;
context.Set <CcCard>().Update(user);
context.SaveChanges();
}
users = context.Set <CcCard>().ToList();
return(users);
}
}
public CcCard GenerateMD5PasswordForAccount(string accountNumber)
{
using (var context = new Mya2billingContext(options.Options))
{
var user = context.Set <CcCard>().FirstOrDefault(p => p.Username == accountNumber);
if (user == null)
{
return(null);
}
var checkPass = Regex.IsMatch(user.Uipass, "^[0-9a-fA-F]{32}$", RegexOptions.Compiled);
if (checkPass || user.Status != 1)
{
return(user);
}
string passwordGenerated = GenerateMD5FromString(user.Username + ":a2billing:" + user.Uipass);
user.Uipass = passwordGenerated;
context.Set <CcCard>().Update(user);
context.SaveChanges();
user = context.Set <CcCard>().FirstOrDefault(p => p.Username == accountNumber);
return(user);
}
}
public string CheckMD5Secret(string accountCode)
{
using (var context = new Mya2billingContext(options.Options))
{
var user = context.Set <CcSipBuddies>().FirstOrDefault(p => p.Username == accountCode);
if (user == null)
{
return("Account is not exist!");
}
if (user.Secret != "" && user.Md5secret == "")
{
return("Secret is still clear text. Please choose option 3 to generate md5secret");
}
else if (user.Secret != "" && user.Md5secret != "")
{
return("Secret still be clear text and md5secret has something. Please choose option 3 to generate md5secret and remove Secret!");
}
else
{
return("MD5Secret is generated!");
}
}
}
public List <CcSipBuddies> GenerateMD5SecretForAllAccounts()
{
using (var context = new Mya2billingContext(options.Options))
{
var users = context.Set <CcSipBuddies>().ToList();
foreach (var user in users)
{
if (user.Secret == "" && user.Md5secret != "")
{
continue;
}
string secret = user.Secret;
string accountCode = user.Accountcode;
string md5secret = GenerateMD5FromString(accountCode + ":asterisk:" + secret);
user.Md5secret = md5secret;
user.Secret = "";
context.Set <CcSipBuddies>().Update(user);
context.SaveChanges();
}
users = context.Set <CcSipBuddies>().ToList();
return(users);
}
}
public CcSipBuddies GenerateMD5SecretForAccount(string username)
{
using (var context = new Mya2billingContext(options.Options))
{
var user = context.Set <CcSipBuddies>().FirstOrDefault(p => p.Username == username);
if (user == null)
{
return(null);
}
if (user.Secret == "" && user.Md5secret != "")
{
return(user);
}
string secret = user.Secret;
string accountCode = user.Accountcode;
string md5secret = GenerateMD5FromString(accountCode + ":asterisk:" + secret);
user.Md5secret = md5secret;
user.Secret = "";
context.Set <CcSipBuddies>().Update(user);
context.SaveChanges();
user = context.Set <CcSipBuddies>().FirstOrDefault(p => p.Username == username);
return(user);
}
}
public PrefixController(Mya2billingContext dbContext, IMapper mapper)
{
_dbContext = dbContext;
_mapper = mapper;
}
public AuthorizeService(Mya2billingContext dbContext)
{
_dbContext = dbContext;
}
public VoucherController(Mya2billingContext dbcontext, IMapper mapper)
{
_dbContext = dbcontext;
_mapper = mapper;
}
public CustomAPIController(Mya2billingContext dbcontext, IMapper mapper)
{
_dbContext = dbcontext;
_mapper = mapper;
}
public TrunksController(Mya2billingContext dbContext, IMapper mapper)
{
_dbContext = dbContext;
_mapper = mapper;
}
