public static User castUserTableToUser(UsersTable userTable) { try { User user = new User() { id = userTable.id, cityCode = LookupBL.getLookupByCode(Constants.CitiesTableName, userTable.cityCode), address = userTable.address, birthDate = DateTime.Parse(userTable.birthDate.ToString()), email = userTable.email, firstName = userTable.firstName, genderId = LookupBL.getLookupByCode(Constants.GenderTableName, int.Parse(userTable.genderId.ToString())), houseNumber = userTable.houseNumber, lastName = userTable.lastName, neighborhood = userTable.neighborhood, password = userTable.password, phone = userTable.phone }; return(user); } catch (Exception) { return(null); } }
public UsersTable UseLogin(LoginTable login) { // String pass = "******"; //String email ="*****@*****.**"; SqlConn(); conn.Open(); Response response = new Response(); SqlCommand cmd = new SqlCommand("Select * From UsersTable Where Email=@UEmail And Password=@UPass ", conn); cmd.Parameters.AddWithValue("@UEmail", login.Email); cmd.Parameters.AddWithValue("@UPass", login.Password); SqlDataReader rdr = cmd.ExecuteReader(); UsersTable NewUser = new UsersTable(); if (rdr.Read()) { NewUser.Id = Convert.ToInt32(rdr["Id"]); NewUser.Name = rdr["Name"].ToString(); NewUser.Surname = rdr["Surname"].ToString(); NewUser.Address = rdr["Address"].ToString(); NewUser.Email = rdr["Email"].ToString(); NewUser.Mobile = rdr["Mobile"].ToString(); NewUser.Password = rdr["Password"].ToString(); return(NewUser); conn.Close(); } else { } conn.Close(); return(NewUser); }
public IHttpActionResult PutUsersTable(string id, UsersTable usersTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != usersTable.userid) { return(BadRequest()); } db.Entry(usersTable).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!UsersTableExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Registered([Bind(Include = "UserID,UserName, Password")] UsersTable _usersTable) { using (SqlConnection Conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["CGH"].ConnectionString)) { Conn.Open(); if ((_usersTable != null) && (ModelState.IsValid)) // ModelState.IsValid,通過表單驗證(Server-side validation)需搭配 Model底下類別檔的 [驗證] { string hash = GetSHA1.GetSHA1Hash(_usersTable.Password); _usersTable.Password = hash; string sqlstr = "INSERT INTO [UsersTable] ( [UserID],[UserName],[Password])"; sqlstr += " VALUES (@UserID,@UserName,@Password)"; int affectedRows = Conn.Execute(sqlstr, new { UserID = _usersTable.UserID, UserName = _usersTable.UserName, Password = _usersTable.Password }); return(RedirectToAction("Index")); } else { // 搭配 ModelState.IsValid,如果驗證沒過,就出現錯誤訊息。 ModelState.AddModelError("Value1", " 自訂錯誤訊息(1) "); // 第一個輸入值是 key,第二個是錯誤訊息(字串) ModelState.AddModelError("Value2", " 自訂錯誤訊息(2) "); return(View()); // 將錯誤訊息,返回並呈現在「新增」的檢視畫面上 } } }
/// <summary> /// get a single user from the Db acording to User name and password /// </summary> /// <param name="Usernameparam"></param> /// <param name="passwordparam"></param> /// <returns>A single User model object</returns> public static UserModel GetSpesificUser(string Usernameparam, string passwordparam) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { UsersTable dbUser = db.UsersTables.SingleOrDefault(a => a.UserName == Usernameparam && a.UserPassword == passwordparam); if (dbUser == null) { return(null); } return(new UserModel { UserID = dbUser.ID, FullName = dbUser.FullName, UserIdNumber = dbUser.UserIdNumber, UserAuthorization = dbUser.UserAuthorization, UserBirthDate = dbUser.UserBirthDate, UserEmail = dbUser.UserEmail, UserName = dbUser.UserName, UserPassword = dbUser.UserPassword, UserSex = dbUser.UserSex, UserImg = dbUser.UserImg }); } } catch { return(null); } }
public UsersTable userget(int EmpID) { UsersTable NewUser = new UsersTable(); try { SqlConn(); SqlCommand cmd = new SqlCommand("Select * From UsersTable Where Id=@UId ", conn); cmd.Parameters.AddWithValue("@UId", EmpID); conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); rdr.Read(); NewUser.Id = Convert.ToInt32(rdr["Id"]); NewUser.Name = rdr["Name"].ToString(); NewUser.Surname = rdr["Surname"].ToString(); NewUser.Address = rdr["Address"].ToString(); NewUser.Email = rdr["Email"].ToString(); NewUser.Mobile = rdr["Mobile"].ToString(); NewUser.Password = rdr["Password"].ToString(); rdr.Close(); conn.Close(); return(NewUser); } catch { return(NewUser); } }
protected void Page_Load(object sender, EventArgs e) { var userId = Session["UserID"]; if (userId == null) { FormsAuthentication.SignOut(); Session.Abandon(); Response.Redirect("~/Account/Login.aspx"); } CompetitionDataContext competitionDataBase = new CompetitionDataContext(); UsersTable user = (from usersTables in competitionDataBase.UsersTable where usersTables.ID == (int)userId select usersTables).FirstOrDefault(); if (user != null) { Session["UserID"] = user.ID; Directions(user); } else { FormsAuthentication.SignOut(); Session.Abandon(); Response.Redirect("~/Account/Login.aspx"); } }
/// <summary> /// set a new rent to the DB /// </summary> /// <param name="newrentparam">a rent model object</param> /// <returns>true if the actions secseed false if it didnt</returns> public static bool AddNewRent(RentModel newrentparam) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { UsersTable dbUser = db.UsersTables.FirstOrDefault(a => a.UserName == newrentparam.UserInfo.UserName); CarsTable dbCar = db.CarsTables.FirstOrDefault(a => a.CarlicenseNumber == newrentparam.CarInfo.CarlicenseNumber); if (dbUser == null || dbCar == null) { return(false); } RentTable NewRent = new RentTable { StartDate = newrentparam.StartDate, EndDate = newrentparam.EndDate, ReturnDate = newrentparam.ReturnDate, UserID = dbUser.ID, CarID = dbCar.ID }; db.RentTables.Add(NewRent); db.SaveChanges(); return(true); } } catch { return(false); } }
public ActionResult Delete(string id, FormCollection collection) { try { // TODO: Add delete logic here using (VC_LMSEntities d = new VC_LMSEntities()) { var row = d.UsersTables.Where(x => x.EMPLOYEE_ID == id && x.ROLES == "Admin").FirstOrDefault(); if (row != null) { ViewBag.Message = "Cannot delete Admin"; return(View()); } foreach (var item in d.Leaves) { if (item.Employee_Id == id) { d.Leaves.Remove(item); } } UsersTable usertable = d.UsersTables.Where(x => x.EMPLOYEE_ID == id).FirstOrDefault(); d.UsersTables.Remove(usertable); d.SaveChanges(); } return(RedirectToAction("view")); } catch { return(View()); } }
/// <summary> /// Insert an instance of User into storage /// </summary> /// <param name="iUser">The instance of user to insert</param> /// <returns>True if the insert was successful</returns> public Boolean InsertUser(User iUser) { Boolean pBlnCreatedTable = UsersTable.CreateIfNotExists(); try { TableOperation pTOnInsert = TableOperation.Insert(iUser); TableResult pTRtResult = UsersTable.Execute(pTOnInsert); switch (pTRtResult.HttpStatusCode) { case 200: case 204: { Boolean pBlnRetVal; pBlnRetVal = CreateDefaultUserProfile(iUser); return(pBlnRetVal); } default: { return(false); } } } catch { return(false); } }
public static string[] AccountNotAcceptedUsers(int id) { UsersTable table = new UsersTable(); string[] users = table.GetNotAcceptedUsers(id); table.Dispose(); return(users); }
public static bool confirmBorrow(int idBorrow) { bool res = LenderData.confirmBorrow(idBorrow); if (res == true) { LendsTable lendTable = LenderData.getLendsByIdBorrow(idBorrow); //השואל UsersTable borrow = UserData.getUserById(lendTable.borrowerId); BooksTable bt = BooksData.getBookById(lendTable.bookId); //המשאיל UsersTable ut = UserData.getUserById(bt.lenderId); string bookName = LookupBL.getLookupByCode(Constants.BooksNameTableName, bt.nameId).Desc; string message = "הספר " + bookName + " שביקשת אושר על ידי בעל הספר : "; message += " פרטי בעל הספר ליצירת קשר : "; message += ut.firstName + " " + ut.lastName + ", "; message += "טלפון: " + ut.phone + " מייל " + ut.email; message += "<br/> מיקום הספר: רחוב " + ut.address + " " + ut.houseNumber + " " + ut.neighborhood + " " + LookupBL.getLookupByCode(Constants.CitiesTableName, ut.cityCode).Desc; //פניה לפונקציה ששולחת מייל על אישור השאלת הספר sendEmailFunc.sendEmailAsync(borrow.email, borrow.firstName + " " + borrow.lastName, message, "אישור השאלת ספר " + bookName); } return(false); }
protected void Page_Load(object sender, EventArgs e) { string guid = Request["confirm"]; if (guid == null) { angryLabel.Text = "Confirmation Failed, no ID provided. Please use the link contained in your confirmation email."; } else { UsersTable userTable = new UsersTable(new DatabaseConnection()); int userID = userTable.authenticateConfirmationID(guid); if (userID == 0) { angryLabel.Text = "Confirmation ID not found. Please use the link contained in your confirmation email."; return; } else { userTable.confirmUser(userID); userTable.deleteConfirmationID(guid); angryLabel.Text = "Congratulations, your account is now confirmed and you may login."; } } }
public List <UsersTable> GetUser(int EmpID) { List <UsersTable> UserData = new List <UsersTable>(); SqlConn(); SqlCommand cmd = new SqlCommand("Select * From UsersTable Where Id=@UId ", conn); cmd.Parameters.AddWithValue("@UId", EmpID); conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.Read()) { UsersTable NewUser = new UsersTable(); NewUser.Id = Convert.ToInt32(rdr["Id"]); NewUser.Name = rdr["Name"].ToString(); NewUser.Surname = rdr["Surname"].ToString(); NewUser.Address = rdr["Address"].ToString(); NewUser.Email = rdr["Email"].ToString(); NewUser.Mobile = rdr["Mobile"].ToString(); NewUser.Password = rdr["Password"].ToString(); UserData.Add(NewUser); } else { } conn.Close(); return(UserData); }
//Sends email to dungeonbuddy inbox protected void sendMessageButton_Click(object sender, EventArgs e) { UsersTable userTable = new UsersTable(new DatabaseConnection()); string username = "******"; if (messageTextField.Text == "") { angryLabel.ForeColor = System.Drawing.Color.Red; angryLabel.Text = "No message provided."; return; } string contactType = contactTypeList.SelectedValue; string message = $"Username: {userID.ToString()}\n" + $"User Email: Not Done Yet.\n" + $"Contact Type: {contactType}\n\n" + $"Message:\n"; message += messageTextField.Text; bool isSuccessful = Email.sendEmail("*****@*****.**", "New Contact Form Submission", message, username); if (isSuccessful) { angryLabel.ForeColor = System.Drawing.Color.Green; angryLabel.Text = "Message Sent!"; messageTextField.Text = ""; } else { angryLabel.ForeColor = System.Drawing.Color.Red; angryLabel.Text = "Uh oh, something went wrong. I'd tell you to contact the administrator but that's what you just failed to do..."; } }
public ActionResult LogIn([FromForm] User model) { try { bool result = CheckIfLoginAndPasswordAreCorrect(model); if (result) { var logins = UsersTable.GetDataByLogin(model.Login); var data = GetIdAndRole(logins[0].Login); Properties.UserId = data.Item1; Properties.UserRole = data.Item2; if (data.Item2 == 1) { return(RedirectToAction("DoctorIndex", "Doctor")); } else { return(RedirectToAction("PatientView", "Patient")); } } else { return(View()); } } catch { return(View()); } }
public ActionResult Register(UserModel objectuser) { if (ModelState.IsValid) { if (objectUserEntities.UsersTables.Where(m1 => m1.Email == objectuser.Email).FirstOrDefault() == null) { UsersTable UserTable1 = new UsersTable(); UserTable1.CreatedOn = (DateTime.Now); UserTable1.FirstName = objectuser.FirstName; UserTable1.LastName = objectuser.LastName; UserTable1.Email = objectuser.Email; UserTable1.PassWord = objectuser.PassWord; objectUserEntities.UsersTables.Add(UserTable1); objectUserEntities.SaveChanges(); objectuser.successmessage = "User Registered successfully"; return(RedirectToAction("Login", "Account")); } else { ModelState.AddModelError("Error", "Email Already exists"); return(View()); } } return(View()); }
// POST: api/UsersTable //[ResponseType(typeof(UsersTable))] public HttpResponseMessage PostUsersTable(UsersTable usersTable) { if (!ModelState.IsValid) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } db.userTables.Add(usersTable); try { db.SaveChanges(); } catch (DbUpdateException) { if (UsersTableExists(usersTable.userid)) { return(Request.CreateResponse(HttpStatusCode.Conflict, "User Already Exist")); } else { throw; } } //return CreatedAtRoute("DefaultApi", new { id = usersTable.userid }, usersTable); return(Request.CreateResponse(HttpStatusCode.OK, "Success...")); }
//Quits the game on behalf of the player protected void leaveGameButton_Click(object sender, EventArgs e) { PartyMembersTable partyMembersTable = new PartyMembersTable(new DatabaseConnection()); UsersTable userTable = new UsersTable(new DatabaseConnection()); foreach (PartyMember pc in party.PartyMembers.Keys) { if (pc.UserID == (int)Session["userID"]) { partyMembersTable.deletePartyMember(pc); } } userTable.deleteUserPlayerGame((int)Session["userID"], game.GameID); Session.Remove("savedContent"); Session.Remove("activeGame"); //Load Home page and eat cookie so no error from controls not existing this.Page.Session.Remove("gameLinkID"); this.Page.Session.Remove("gameCategoryID"); this.Page.Session.Remove("gamePanelID"); this.Page.Session.Remove("gameTypePanelID"); this.Page.Session.Remove("page"); Response.Redirect("~/Home"); }
public IEnumerable <UsersTable> GetUsersList() { List <UsersTable> UserData = new List <UsersTable>(); SqlConn(); SqlCommand cmd = new SqlCommand("Select * From UsersTable", conn); conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { UsersTable user = new UsersTable(); user.Id = Convert.ToInt32(rdr["Id"]); user.Name = rdr["Name"].ToString(); user.Surname = rdr["Surname"].ToString(); user.Email = rdr["Email"].ToString(); user.Mobile = rdr["Mobile"].ToString(); user.Address = rdr["Address"].ToString(); user.Password = rdr["Password"].ToString(); UserData.Add(user); } conn.Close(); return(UserData); }
public static Books CastBookTableToBook(BooksTable bookTable) { try { Books book = new Books() { numberOfViewers = bookTable.numberOfViewers, picNAme = bookTable.picNAme, //שליפת פרטי מחבר לפי קוד מחבר autherId = LookupBL.getLookupByCode(Constants.AutherTableName, bookTable.autherId), //שליפת פרטי קטגורית ספר לפי קוד קטגוריה categoryId = LookupBL.getLookupByCode(Constants.BooksCategoryTableName, bookTable.categoryId), id = bookTable.id, description = bookTable.description, numOfPages = bookTable.numOfPages, isBorrowed = bookTable.isBorrowed, lenderId = bookTable.lenderId, //שליפת פרטי שם ספר לפי קוד שם nameId = LookupBL.getLookupByCode(Constants.BooksNameTableName, bookTable.nameId), //שליפת פרטי מוציא לאור לפי קוד מוציא לאור publishingId = LookupBL.getLookupByCode(Constants.PuplishingTableName, bookTable.publishingId) // city=LookupBL.getLookupByCode(Constants.CitiesTableName,bookTable.UsersTable.cityCode) }; UsersTable lender = UserData.getUserById(bookTable.lenderId); book.city = LookupBL.getLookupByCode(Constants.CitiesTableName, lender.cityCode); return(book); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// Get a user from storage by its given user principal /// </summary> /// <param name="iUserPrincipal">User principal of the user to get</param> /// <returns>The requested user, if found in storage, otherwise null</returns> public User GetUser(ClaimsPrincipal iUserPrincipal) { Boolean pBlnCreatedTable = UsersTable.CreateIfNotExists(); TableResult pTRtResult = new TableResult() { HttpStatusCode = 404 }; if (pBlnCreatedTable) { return(null); } else { String pStrPartitionKey = iUserPrincipal.GetUserPartitionKey(ClaimsPrincipalExtensions.KeySource.email); String pStrRowKey = iUserPrincipal.GetUserRowKey(ClaimsPrincipalExtensions.KeySource.email); TableOperation pTOnRetrieve = TableOperation.Retrieve <User>(pStrPartitionKey, pStrRowKey); pTRtResult = UsersTable.Execute(pTOnRetrieve); switch (pTRtResult.HttpStatusCode) { case 200: { return((User)pTRtResult.Result); } } return(null); } }
/// <summary> /// Edit a user Info /// </summary> /// <param name="Usernameparam">the User name</param> /// <param name="userparam">the User model object</param> /// <returns>true if the actions secseed false if it didnt</returns> public static bool EditUser(string Usernameparam, UserModel userparam) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { UsersTable dbUser = db.UsersTables.SingleOrDefault(a => a.UserName == Usernameparam); if (dbUser == null) { return(false); } dbUser.UserAuthorization = userparam.UserAuthorization; dbUser.FullName = userparam.FullName; dbUser.UserIdNumber = userparam.UserIdNumber; dbUser.UserBirthDate = userparam.UserBirthDate; dbUser.UserEmail = userparam.UserEmail; dbUser.UserName = userparam.UserName; dbUser.UserPassword = userparam.UserPassword; dbUser.UserSex = userparam.UserSex; dbUser.UserImg = userparam.UserImg; db.SaveChanges(); return(true); } } catch { return(false); } }
public void Directions(UsersTable user) { FormsAuthentication.SetAuthCookie(user.Email, true); int accessLevel = (int)user.AccessLevel; if (accessLevel == 0) { Response.Redirect("~/User/UserMainPage.aspx"); } else if (accessLevel == 10) { Response.Redirect("~/Admin/Main.aspx"); } else if (accessLevel == 5) { Response.Redirect("~/Expert/Main.aspx"); } else if (accessLevel == 15) { Response.Redirect("~/Curator/CuratorMainPage.aspx"); } else //если входим сюда то что то не так) скорей всего пользователю не присвоен уровень в UsersTable { FormsAuthentication.SignOut(); Session.Abandon(); Response.Redirect("~/Account/Login.aspx"); } }
/// <summary> /// Add a new User to the DB /// </summary> /// <param name="NewUser">A User model object</param> /// <returns>true if the actions secseed false if it didnt</returns> public static bool AddNewUser(UserModel NewUser) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { UsersTable dbUser = new UsersTable { FullName = NewUser.FullName, UserIdNumber = NewUser.UserIdNumber, UserAuthorization = NewUser.UserAuthorization, UserBirthDate = NewUser.UserBirthDate, UserEmail = NewUser.UserEmail, UserName = NewUser.UserName, UserPassword = NewUser.UserPassword, UserSex = NewUser.UserSex, UserImg = NewUser.UserImg }; db.UsersTables.Add(dbUser); db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// edit a rent acording to a rent id sent by the cient /// </summary> /// <param name="RentId">the rent id sent by the client</param> /// <param name="rentparam">a rent model contains all the rent data</param> /// <returns>true if the actions secseed false if it didnt</returns> public static bool EditRent(int RentId, RentModel rentparam) { try { using (CarRentalDbV2Entities db = new CarRentalDbV2Entities()) { RentTable dbrent = db.RentTables.SingleOrDefault(a => a.ID == RentId); UsersTable dbuser = db.UsersTables.SingleOrDefault(a => a.UserName == rentparam.UserInfo.UserName); CarsTable dbcar = db.CarsTables.SingleOrDefault(a => a.CarlicenseNumber == rentparam.CarInfo.CarlicenseNumber); if (dbrent == null || dbuser == null || dbcar == null) { return(false); } dbrent.CarID = dbcar.ID; dbrent.UserID = dbuser.ID; dbrent.EndDate = rentparam.EndDate; dbrent.ReturnDate = rentparam.ReturnDate; dbrent.StartDate = rentparam.StartDate; db.SaveChanges(); return(true); } } catch { return(false); } }
public async Task <string> UpdateUserById(UsersTable model) { try { UsersTable user = await db.Users.FindAsync(model.UserId); if (user != null) { user.DisplayName = model.DisplayName; user.EmailAddress = model.EmailAddress; user.FirstName = model.FirstName; user.LastName = model.LastName; user.JobTitle = model.JobTitle; await db.SaveChangesAsync(); return("Succesfully edit " + model.DisplayName); } else { return("Cannot find detail user with ID " + model.UserId); } } catch (Exception x) { return(x.Message.ToString()); } }
public override async Task <IdentityResult> DeleteAsync(ApplicationUser <TKey> user, CancellationToken cancellationToken) { cancellationToken.ThrowIfCancellationRequested(); ThrowIfDisposed(); user.ThrowIfNull(nameof(user)); return(await UsersTable.DeleteAsync(user)); }
/// <inheritdoc/> public override async Task <TUser> FindByNameAsync(string normalizedUserName, CancellationToken cancellationToken) { cancellationToken.ThrowIfCancellationRequested(); ThrowIfDisposed(); var user = await UsersTable.FindByNameAsync(normalizedUserName); return(user); }
public ActionResult DeleteConfirmed(int id) { UsersTable usersTable = db.UsersTables.Find(id); db.UsersTables.Remove(usersTable); db.SaveChanges(); return(RedirectToAction("Index")); }
/// <inheritdoc/> protected override async Task <TUser> FindUserAsync(TKey userId, CancellationToken cancellationToken) { cancellationToken.ThrowIfCancellationRequested(); ThrowIfDisposed(); var user = await UsersTable.FindByIdAsync(userId); return(user); }
public async Task InsertedUserToDb() { var googleAuthenticatorService = new AuthenticationGoogle(); var userTable = new UsersTable(); await googleAuthenticatorService.LoginGoogle(_testUsername); var user = userTable.GetRow(_testUsername); Assert.AreEqual(user.name, _testUsername); }
public async Task UpdateSpecificUser() { var googleAuthenticatorService = new AuthenticationGoogle(); var userTable = new UsersTable(); await googleAuthenticatorService.LoginGoogle(_testUsername); var user = googleAuthenticatorService.GetCurrentUser(); userTable.InsertRow(user); var updatedUser = AuthenticationGoogle.GetSpecificUser(_testUsername); Assert.AreNotEqual(user.expireDate, updatedUser.expireDate); }
//[TestMethod] public void DeleteSpecificUserFromDb() { var userTable = new UsersTable(); userTable.DeleteRow(_testUsername); GetSpecificUser(); }
//TODO: Check if DB is cleared public void ClearUserDb() { var userTable = new UsersTable(); userTable.ClearUserDatabase(true); }
public static void AddUser(int id, string username, bool accept) { UsersTable table = new UsersTable(); table.Insert(id, username, accept); table.Dispose(); }
public static bool UserIsInList(int id, string username) { UsersTable table = new UsersTable(); bool present = table.IsPresent(id, username); table.Dispose(); return(present); }
private AcceptUserType OnAcceptUser(PeerSocket peer, UserInfo userInfo) { if (userInfo.SecureAuthentication == false) return(AcceptUserType.Ask); UsersTable usersDb = new UsersTable(); // If User isn't into DB if (usersDb.IsPresent(myAccountId, userInfo.Name) == false) { usersDb.Dispose(); return(AcceptUserType.Ask); } // Get User Accept Status bool acceptUser = usersDb.GetAccept(myAccountId, userInfo.Name); usersDb.Dispose(); return(acceptUser ? AcceptUserType.Yes : AcceptUserType.No); }