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