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