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 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);
}
}