public async Task <ActionResult> RemoveLogin(string loginProvider, string providerKey) { var vm = new ManageLoginsViewModel(); var result = await UserManager.RemoveLoginAsync(User.Identity.GetUserId(), new UserLoginInfo(loginProvider, providerKey)); if (!result.Succeeded) { vm.Errors = InvalidResult("Nie udało się usunąć dostawcy logowania").Errors; return(PartialView("_manageLoginsPartial", vm)); } var user = await UserManager.FindByIdAsync(User.Identity.GetUserId()); if (user == null) { vm.Errors = InvalidResult("Nie odnaleziono użytkownika").Errors; return(PartialView("_manageLoginsPartial", vm)); } await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false); var userLogins = await UserManager.GetLoginsAsync(User.Identity.GetUserId()); var otherLogins = AuthenticationManager.GetExternalAuthenticationTypes().Where(auth => userLogins.All(ul => auth.AuthenticationType != ul.LoginProvider)).ToList(); vm.ShowRemoveButton = user.PasswordHash != null || userLogins.Count > 1; vm.CurrentLogins = userLogins; vm.OtherLogins = otherLogins; vm.Message = "Usługa logowania została usunięta"; return(PartialView("_manageLoginsPartial", vm)); }
public virtual async Task <IActionResult> ManageLogins() { if (!CurrentSite.HasAnySocialAuthEnabled()) { return(RedirectToAction("Index")); } var user = await UserManager.FindByIdAsync(HttpContext.User.GetUserId()); if (user == null) { return(View("Error")); } var userLogins = await UserManager.GetLoginsAsync(user); //var externalSchemes = await SignInManager.GetExternalAuthenticationSchemesAsync(); var externalSchemes = await AccountService.GetExternalAuthenticationSchemes(); var otherLogins = externalSchemes.Where(auth => userLogins.All(ul => auth.Name != ul.LoginProvider)).ToList(); var model = new ManageLoginsViewModel { CurrentLogins = userLogins, OtherLogins = otherLogins }; model.ShowRemoveButton = await UserManager.HasPasswordAsync(user) || model.CurrentLogins.Count > 1; return(View(model)); }
public async Task <IActionResult> ManageLogins(ManageMessageId?message = null) { ManageLoginsViewModel viewModel = new ManageLoginsViewModel { StatusMessage = message == ManageMessageId.RemoveLoginSuccess ? new Alert("The external login was removed.", AlertType.Success, AlertBehaviour.Remain) : message == ManageMessageId.AddLoginSuccess ? new Alert("The external login was added.", AlertType.Success, AlertBehaviour.Remain) : message == ManageMessageId.Error ? new Alert("An error occurred.", AlertType.Danger, AlertBehaviour.Remain) : null }; var user = await GetCurrentUserAsync(); if (user == null) { return(View("Error")); } var userLogins = await _userManager.GetLoginsAsync(user); var schemes = await _signInManager.GetExternalAuthenticationSchemesAsync(); var otherLogins = schemes.Where(auth => userLogins.All(ul => auth.Name != ul.LoginProvider)).ToList(); viewModel.ShowRemoveButton = user.PasswordHash != null || userLogins.Count > 1; return(View(new ManageLoginsViewModel { CurrentLogins = userLogins, OtherLogins = otherLogins })); }
public async Task <ManageLoginsViewModel> BuildManageLoginsAsync( IPrincipal principal, User currentUser, UserManager <User, int> userManager, IAuthenticationManager authenticationManager, ManageMessageId?message) { if (currentUser == null) { return(null); } var userLogins = await userManager.GetLoginsAsync(GetUserId(principal)); var otherLogins = authenticationManager .GetExternalAuthenticationTypes() .Where(auth => userLogins.All(ul => auth.AuthenticationType != ul.LoginProvider)) .ToList(); var model = new ManageLoginsViewModel { StatusMessage = message == ManageMessageId.RemoveLoginSuccess ? Rsx.ManageLogins.LoginRemoved : message == ManageMessageId.Error ? Rsx.ManageLogins.Error : "", CurrentLogins = userLogins, OtherLogins = otherLogins, ShowRemoveButton = currentUser.PasswordHash != null || userLogins.Count > 1 }; return(model); }
public async Task <ActionResult> ManageLogins(ManageMessageId?message) { var vm = new ManageLoginsViewModel(); switch (message) { case ManageMessageId.Error: vm.Errors = InvalidResult("Wystąpił błąd").Errors; break; case ManageMessageId.AddLoginSuccess: vm.Message = "Dodano nową usługe logowania"; break; } var user = await UserManager.FindByIdAsync(User.Identity.GetUserId()); if (user == null) { vm.Errors = InvalidResult("Nie odnaleziono użytkownika").Errors; return(View(vm)); } var userLogins = await UserManager.GetLoginsAsync(User.Identity.GetUserId()); var otherLogins = AuthenticationManager.GetExternalAuthenticationTypes().Where(auth => userLogins.All(ul => auth.AuthenticationType != ul.LoginProvider)).ToList(); vm.ShowRemoveButton = user.PasswordHash != null || userLogins.Count > 1; vm.CurrentLogins = userLogins; vm.OtherLogins = otherLogins; return(View(vm)); }
private async Task <ManageLoginsViewModel> GetManageLoginsViewModel(string statusMessage, ApplicationUser user) { const string title1 = "Manage your external logins"; var userId = user.Id; // User.Identity.GetUserId(); var applicationName = GetApplicationName(); var applicationVersion = GetApplicationVersion(); var area = GetAreaName(); var mvcActionName = GetActionName(); var loginProviders = HttpContext.GetOwinContext().Authentication.GetExternalAuthenticationTypes(); var userLogins = await UserManager.GetLoginsAsync(userId); var otherLogins = AuthenticationManager.GetExternalAuthenticationTypes().Where(auth => userLogins.All(ul => auth.AuthenticationType != ul.LoginProvider)).ToList(); var rolesForUser = await GetRolesForUserAsync(User.Identity.Name); var model = new ManageLoginsModel { CurrentLogins = userLogins, OtherLogins = otherLogins }; var vm = new ManageLoginsViewModel(applicationName, applicationVersion, mvcActionName, title1, area, () => GetMainMenus(area), rolesForUser) { StatusMessage = statusMessage, HasLoginProviders = loginProviders.Any(), CanShowRemoveButton = user.PasswordHash != null || userLogins.Any(), ManageLoginsModel = model }; return(vm); }
public void ManageLoginsViewModel() { var manageLoginsvm = new ManageLoginsViewModel() { CurrentLogins = new List <UserLoginInfo>(), OtherLogins = new List <AuthenticationDescription>() }; var currentLogins = manageLoginsvm.CurrentLogins; var otherLogins = manageLoginsvm.OtherLogins; }
public void TestManageLoginsViewModel() { IList <UserLoginInfo> logins = new List <UserLoginInfo>(); IList <AuthenticationDescription> otherLogins = new List <AuthenticationDescription>(); ManageLoginsViewModel viewModel = new ManageLoginsViewModel { CurrentLogins = logins, OtherLogins = otherLogins }; viewModel.Should().NotBeNull(); }
public void OtherLoginsProp_WhenValidParametersArePasedToId_ShouldSetCorerectly() { // Arrange var viewModel = new ManageLoginsViewModel(); var testOtherLogins = new List <AuthenticationDescription>(); // Act viewModel.OtherLogins = testOtherLogins; // Assert Assert.AreEqual(testOtherLogins, viewModel.OtherLogins); }
public void CurrentLoginsProp_WhenValidParametersArePasedToId_ShouldSetCorerectly() { // Arrange var viewModel = new ManageLoginsViewModel(); var testCurrentLogins = new List <UserLoginInfo>(); // Act viewModel.CurrentLogins = testCurrentLogins; // Assert Assert.AreEqual(testCurrentLogins, viewModel.CurrentLogins); }
public void ManageLoginsViewModel_ShouldSetAllPropertiesCorrectly() { // Arrange var manageLoginsViewModel = new ManageLoginsViewModel(); // Act manageLoginsViewModel.CurrentLogins = new List <UserLoginInfo>(); manageLoginsViewModel.OtherLogins = new List <AuthenticationDescription>(); // Assert Assert.AreEqual(new List <UserLoginInfo>(), manageLoginsViewModel.CurrentLogins); Assert.AreEqual(new List <AuthenticationDescription>(), manageLoginsViewModel.OtherLogins); }
public void Setters_ShouldSetPropertiesCorrectly() { // Arrange var expectedOther = new List <AuthenticationDescription>(); var expectedLogins = new List <UserLoginInfo>(); var sut = new ManageLoginsViewModel(); // Act sut.CurrentLogins = expectedLogins; sut.OtherLogins = expectedOther; // Assert Assert.AreSame(expectedLogins, sut.CurrentLogins); Assert.AreSame(expectedOther, sut.OtherLogins); }
public void ManageLoginsViewModel_Tests() { ManageLoginsViewModel model = new ManageLoginsViewModel() { CurrentLogins = new List <UserLoginInfo>(), OtherLogins = new List <AuthenticationDescription>() }; ManageLoginsViewModel modelGet = new ManageLoginsViewModel() { CurrentLogins = model.CurrentLogins, OtherLogins = model.OtherLogins }; Assert.IsTrue(true, modelGet.CurrentLogins.Count.ToString()); }
public void Models_ManageLoginsViewModel_Default_Instantiate_Should_Pass() { //arrange var test = new ManageLoginsViewModel(); var expectCurrentLogins = new List <UserLoginInfo>(); var expectOtherLogins = new List <AuthenticationDescription>(); //act test.CurrentLogins = expectCurrentLogins; test.OtherLogins = expectOtherLogins; //assert Assert.AreEqual(expectCurrentLogins, test.CurrentLogins, TestContext.TestName); Assert.AreEqual(expectOtherLogins, test.OtherLogins, TestContext.TestName); }
public async Task <JsonResult> ManageLoginsJson() { dynamic response = MakeInitialStatusResponse(); var user = await GetCurrentUserAsync(); if (user == null) { return(Json(response)); } var userLogins = await _userManager.GetLoginsAsync(user); var otherLogins = _signInManager.GetExternalAuthenticationSchemes().Where(auth => userLogins.All(ul => auth.AuthenticationScheme != ul.LoginProvider)).ToList(); dynamic mlvResponse = new ManageLoginsViewModel { CurrentLogins = userLogins, OtherLogins = otherLogins }; response.manageLoginsViewModel = mlvResponse; response.status.ok = true; return(Json(response)); }
public void Page_Load(object sender, EventArgs e) { Button1.BackColor = SystemColors.Control; Button2.BackColor = SystemColors.Control; Button3.BackColor = SystemColors.Control; Button4.BackColor = SystemColors.Control; Button5.BackColor = SystemColors.Control; Button6.BackColor = SystemColors.Control; Button7.BackColor = SystemColors.Control; Button8.BackColor = SystemColors.Control; Button9.BackColor = SystemColors.Control; Button10.BackColor = SystemColors.Control; Button11.BackColor = SystemColors.Control; Button12.BackColor = SystemColors.Control; Button13.BackColor = SystemColors.Control; Button14.BackColor = SystemColors.Control; Button15.BackColor = SystemColors.Control; Button16.BackColor = SystemColors.Control; Button17.BackColor = SystemColors.Control; Button18.BackColor = SystemColors.Control; Button19.BackColor = SystemColors.Control; Button20.BackColor = SystemColors.Control; Button21.BackColor = SystemColors.Control; Button22.BackColor = SystemColors.Control; Button23.BackColor = SystemColors.Control; Button24.BackColor = SystemColors.Control; Button25.BackColor = SystemColors.Control; Button26.BackColor = SystemColors.Control; Button27.BackColor = SystemColors.Control; Button28.BackColor = SystemColors.Control; Button29.BackColor = SystemColors.Control; Button30.BackColor = SystemColors.Control; Button31.BackColor = SystemColors.Control; Button32.BackColor = SystemColors.Control; Button33.BackColor = SystemColors.Control; Button34.BackColor = SystemColors.Control; Button35.BackColor = SystemColors.Control; Button36.BackColor = SystemColors.Control; Button37.BackColor = SystemColors.Control; Button38.BackColor = SystemColors.Control; Button39.BackColor = SystemColors.Control; Button40.BackColor = SystemColors.Control; Button41.BackColor = SystemColors.Control; Button42.BackColor = SystemColors.Control; Button43.BackColor = SystemColors.Control; Button44.BackColor = SystemColors.Control; Button45.BackColor = SystemColors.Control; Button46.BackColor = SystemColors.Control; Button47.BackColor = SystemColors.Control; Button48.BackColor = SystemColors.Control; Button49.BackColor = SystemColors.Control; Button50.BackColor = SystemColors.Control; ManageLoginsViewModel login = new ManageLoginsViewModel(); //HttpContext.Current.Response.Write(Session["UserName"]); DataSet ds = new DataSet(); SqlConnection sc = new SqlConnection("Data Source = mibi.database.windows.net; Initial Catalog = HotDesk; User ID = mibi; Password = MiB@4321; Integrated Security = False"); sc.Open(); SqlCommand cmd1 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 1", sc); if (cmd1.ExecuteScalar() != null) { Button1.BackColor = Color.Red; Button1.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd2 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 2", sc); if (cmd2.ExecuteScalar() != null) { Button2.BackColor = Color.Red; Button2.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd3 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 3", sc); if (cmd3.ExecuteScalar() != null) { Button3.BackColor = Color.Red; Button3.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd4 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 4", sc); if (cmd4.ExecuteScalar() != null) { Button4.BackColor = Color.Red; Button4.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd5 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 5", sc); if (cmd5.ExecuteScalar() != null) { Button5.BackColor = Color.Red; Button5.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd6 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 6", sc); if (cmd6.ExecuteScalar() != null) { Button6.BackColor = Color.Red; Button6.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd7 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 7", sc); if (cmd7.ExecuteScalar() != null) { Button7.BackColor = Color.Red; Button7.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd8 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 8", sc); if (cmd8.ExecuteScalar() != null) { Button8.BackColor = Color.Red; Button8.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd9 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 9", sc); if (cmd9.ExecuteScalar() != null) { Button9.BackColor = Color.Red; Button9.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd10 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 10", sc); if (cmd10.ExecuteScalar() != null) { Button10.BackColor = Color.Red; Button10.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd11 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 11", sc); if (cmd11.ExecuteScalar() != null) { Button11.BackColor = Color.Red; Button11.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd12 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 12", sc); if (cmd12.ExecuteScalar() != null) { Button12.BackColor = Color.Red; Button12.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd13 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 13", sc); if (cmd13.ExecuteScalar() != null) { Button13.BackColor = Color.Red; Button13.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd14 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 14", sc); if (cmd14.ExecuteScalar() != null) { Button14.BackColor = Color.Red; Button14.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd15 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 15", sc); if (cmd15.ExecuteScalar() != null) { Button15.BackColor = Color.Red; Button15.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd16 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 16", sc); if (cmd16.ExecuteScalar() != null) { Button16.BackColor = Color.Red; Button16.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd17 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 17", sc); if (cmd17.ExecuteScalar() != null) { Button17.BackColor = Color.Red; Button17.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd18 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 18", sc); if (cmd18.ExecuteScalar() != null) { Button18.BackColor = Color.Red; Button18.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd19 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 19", sc); if (cmd19.ExecuteScalar() != null) { Button19.BackColor = Color.Red; Button19.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd20 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 20", sc); if (cmd20.ExecuteScalar() != null) { Button20.BackColor = Color.Red; Button20.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd21 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 21", sc); if (cmd21.ExecuteScalar() != null) { Button21.BackColor = Color.Red; Button21.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd22 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 22", sc); if (cmd22.ExecuteScalar() != null) { Button22.BackColor = Color.Red; Button22.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd23 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 23", sc); if (cmd23.ExecuteScalar() != null) { Button23.BackColor = Color.Red; Button23.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd24 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 24", sc); if (cmd24.ExecuteScalar() != null) { Button24.BackColor = Color.Red; Button24.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd25 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 25", sc); if (cmd25.ExecuteScalar() != null) { Button25.BackColor = Color.Red; Button25.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd26 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 26", sc); if (cmd26.ExecuteScalar() != null) { Button26.BackColor = Color.Red; Button26.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd27 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 27", sc); if (cmd27.ExecuteScalar() != null) { Button27.BackColor = Color.Red; Button27.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd28 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 28", sc); if (cmd28.ExecuteScalar() != null) { Button28.BackColor = Color.Red; Button28.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd29 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 29", sc); if (cmd29.ExecuteScalar() != null) { Button29.BackColor = Color.Red; Button29.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd30 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 30", sc); if (cmd30.ExecuteScalar() != null) { Button30.BackColor = Color.Red; Button30.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd31 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 31", sc); if (cmd31.ExecuteScalar() != null) { Button31.BackColor = Color.Red; Button31.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd32 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 32", sc); if (cmd32.ExecuteScalar() != null) { Button32.BackColor = Color.Red; Button32.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd33 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 33", sc); if (cmd33.ExecuteScalar() != null) { Button33.BackColor = Color.Red; Button33.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd34 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 34", sc); if (cmd34.ExecuteScalar() != null) { Button34.BackColor = Color.Red; Button34.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd35 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 35", sc); if (cmd35.ExecuteScalar() != null) { Button35.BackColor = Color.Red; Button35.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd36 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 36", sc); if (cmd36.ExecuteScalar() != null) { Button36.BackColor = Color.Red; Button36.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd37 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 37", sc); if (cmd37.ExecuteScalar() != null) { Button37.BackColor = Color.Red; Button37.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd38 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 38", sc); if (cmd38.ExecuteScalar() != null) { Button38.BackColor = Color.Red; Button38.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd39 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 39", sc); if (cmd39.ExecuteScalar() != null) { Button39.BackColor = Color.Red; Button39.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd40 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 40", sc); if (cmd40.ExecuteScalar() != null) { Button40.BackColor = Color.Red; Button40.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd41 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 41", sc); if (cmd41.ExecuteScalar() != null) { Button41.BackColor = Color.Red; Button41.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd42 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 42", sc); if (cmd42.ExecuteScalar() != null) { Button42.BackColor = Color.Red; Button42.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd43 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 43", sc); if (cmd43.ExecuteScalar() != null) { Button43.BackColor = Color.Red; Button43.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd44 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 44", sc); if (cmd44.ExecuteScalar() != null) { Button44.BackColor = Color.Red; Button44.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd45 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 45", sc); if (cmd45.ExecuteScalar() != null) { Button45.BackColor = Color.Red; Button45.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd46 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 46", sc); if (cmd46.ExecuteScalar() != null) { Button46.BackColor = Color.Red; Button46.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd47 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 47", sc); if (cmd47.ExecuteScalar() != null) { Button47.BackColor = Color.Red; Button47.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd48 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 48", sc); if (cmd48.ExecuteScalar() != null) { Button48.BackColor = Color.Red; Button48.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd49 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 49", sc); if (cmd49.ExecuteScalar() != null) { Button49.BackColor = Color.Red; Button49.Enabled = false; } sc.Close(); sc.Open(); SqlCommand cmd50 = new SqlCommand("SELECT seat_id FROM tblBooking WHERE seat_id = 50", sc); if (cmd50.ExecuteScalar() != null) { Button50.BackColor = Color.Red; Button50.Enabled = false; } sc.Close(); }