public bool RegisterAll(string datalogin, string datalogin2, string dataBdd, string userCurrent)
{
bool answer = false;
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
DaUser odaUser = new DaUser();
string[] oIdMembreship_amount = odaUser.RegisterUser(connection, datalogin, datalogin).Split('¬');
string[] parameterPerson = dataBdd.Split('$');
string[] arraydata = parameterPerson[0].Split('|');
string[] arrayTypeaccount = parameterPerson[2].Split('|');
string[] arrayaccount = parameterPerson[3].Split('|');
string parameterAccount = arraydata[5].Trim() + "|" + arrayTypeaccount[7].Trim() + '|' + userCurrent + '|' + oIdMembreship_amount[0];
var newUserName = odaUser.GenerateAccount(connection, parameterAccount);
connection.Close();
}
}
catch (Exception e)
{
RecordLog(e.Message, e.StackTrace);
}
return(answer);
}
static public bool DeleteUser(DdUserExt item, RevisionInfo revisionInfo)
{
DaUser da = new DaUser(DataStore.DbConnection);
bool ok = da.DeleteById(item.Id);
if (ok) AddChangeLog(da.TableName, item.Id, item.Timestamp, revisionInfo); //delete
return ok;
}
private static void CreateGlobalSuperAdminUser()
{
IdentityResult result = null;
var userManager = new DaUserManager(new DaUserRepository(IdentityDbContext));
var user = new DaUser();
user.UserName = DaUser.GLOBAL_SUPER_ADMIN;
user.Email = "*****@*****.**";
user.Status = DaAccountStatus.Active;
result = userManager.Create(user, "Password#321");
if (!result.Succeeded)
{
if (result.Errors != null && result.Errors.Count() > 0)
{
StringBuilder sbMessage = new StringBuilder();
foreach (var err in result.Errors)
{
sbMessage.Append(err + " ");
}
throw new Exception(sbMessage.ToString());
}
}
}
static public DdUserExt GetUserInfo(int personREF)
{
DaUser da = new DaUser(DataStore.DbConnection);
if (da.GetById(personREF))
return new DdUserExt(da.GetBuffer());
else
return null;
}
static public BindingList<DdUserExt> GetUsers()
{
BindingList<DdUserExt> list = new BindingList<DdUserExt>();
DaUser da = new DaUser(DataStore.DbConnection);
DnUser dn = da.Fill();
foreach (DdUser dd in dn) list.Add(new DdUserExt(dd));
return list;
}
static public bool AddUser(ref DdUserExt item, RevisionInfo revisionInfo)
{
DaUser da = new DaUser(DataStore.DbConnection);
da.Clear();
da.Comment = item.Comment;
da.Credentials = item.Credentials;
da.FullName = item.FullName;
da.Inactive = item.Inactive;
da.Modified = item.Modified;
da.ModifiedBy = item.ModifiedBy;
da.UserID = item.UserID;
da.Title = item.Title;
bool ok = da.Insert();
if (ok) AddChangeLog(da.TableName, da.Id, da.Timestamp, revisionInfo); //add
if (ok) item = new DdUserExt(da.GetBuffer());
return ok;
}
public int putUser(string data)
{
int answer = 0;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
try
{
connection.Open();
DaUser odaUser = new DaUser();
answer = odaUser.putUser(connection, data);
}
catch (Exception e)
{
RecordLog(e.Message, e.StackTrace);
answer = 0;
}
}
return(answer);
}
static public bool SaveUser(ref DdUserExt item, RevisionInfo revisionInfo)
{
DaUser da = new DaUser(DataStore.DbConnection);
if (!da.GetById(item.Id)) return false;
da.Comment = item.Comment;
da.Credentials = item.Credentials;
da.FullName = item.FullName;
da.Inactive = item.Inactive;
da.UserID = item.UserID;
da.Title = item.Title;
bool ok = true;
if (da._IsModified)
{
da.Modified = DateTime.Now;
da.ModifiedBy = Environment.UserName;
ok = da.Save();
if (ok) AddChangeLog(da.TableName, da.Id, da.Timestamp, revisionInfo);
if (ok) item = new DdUserExt(da.GetBuffer());
}
return ok;
}
public string Login(Login login)
{
string request = "";
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
try
{
connection.Open();
DaUser daUser = new DaUser();
request = daUser.Login(connection, login);
connection.Close();
}
catch (Exception e)
{
return(e.Message);
}
}
return(request);
}
public async Task <ActionResult> ExternalLoginConfirmation(ExternalLoginConfirmationViewModel model, string returnUrl)
{
if (User.Identity.IsAuthenticated)
{
return(RedirectToAction("Index", "Manage"));
}
if (ModelState.IsValid)
{
// Get the information about the user from the external login provider
var info = await AuthenticationManager.GetExternalLoginInfoAsync();
if (info == null)
{
return(View("ExternalLoginFailure"));
}
var user = new DaUser {
UserName = model.Email, Email = model.Email
};
var result = await UserManager.CreateAsync(user);
if (result.Succeeded)
{
result = await UserManager.AddLoginAsync(user.Id, info.Login);
if (result.Succeeded)
{
await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false);
return(RedirectToLocal(returnUrl));
}
}
AddErrors(result);
}
ViewBag.ReturnUrl = returnUrl;
return(View(model));
}
static public void UpdateUser(BindingSource binding, RevisionInfo revInfo)
{
BindingList<DdUserExt> list = (BindingList<DdUserExt>)binding.DataSource;
try
{
using (TransactionScope scope = new TransactionScope())
{
DaUser da = new DaUser(DataStore.CloneDbConnection());
foreach (DdUserExt item in list)
{// do deletes first
bool existing = da.GetById(item.Id);
if (existing && item.DeleteFlag)
{// delete here - avoid validation
da.DeleteById(item.Id);
AddChangeLog(da.TableName, item.Id, da.Timestamp, revInfo);
}
}
foreach (DdUserExt item in list)
{
if (item.DeleteFlag) continue; // already done above
//if (item.UserID == string.Empty) continue; // already done above
bool existing = da.GetById(item.Id);
if (!existing)
{
da.Clear();
}
da.Comment = item.Comment;
da.Credentials = item.Credentials;
da.FullName = item.FullName;
da.Inactive = item.Inactive;
da.UserID = item.UserID;
da.Title = item.Title;
if (!existing)
{
da.Insert();
AddChangeLog(da.TableName, da.Id, da.Timestamp, revInfo);
}
else
{
if (!da._IsModified) continue;
da.Modified = DateTime.Now;
da.ModifiedBy = Environment.UserName;
da.Save();
AddChangeLog(da.TableName, da.Id, da.Timestamp, revInfo); }
}
scope.Complete();
}
binding.DataSource = GetUserList();
}
catch (AppEx)
{
throw;
}
catch (Exception exc)
{
throw new AppEx(exc, "Error updating User");
}
}
static public void LoadUserList()
{
UserList = new DropDownItemList();
DaUser daUser = new DaUser(DbConnection);
DnUser list = daUser.Fill("Id>1", "UserID", 0, true);
UserList = new DropDownItemList(list.Count);
UserList.Add(1, string.Empty, string.Empty);
foreach (DdUser dd in list)
UserList.Add(dd.Id, dd.UserID, dd.UserID);
}
protected override void OnInit()
{
base.OnInit();
_daUser = new DaUser(DbContext);
}
