public ActionResult Create([Bind(Include = "EntryNo,AlbumNo,RecordCompany,ReleaseCode")] Release release) { if (ModelState.IsValid) { db.Release.Add(release); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AlbumNo = new SelectList(db.Album, "EntryNo", "Author", release.AlbumNo); return(View(release)); }
public ActionResult Create([Bind(Include = "UserNo,AlbumNo,ReleaseNo,Comment")] CollectionEntry collectionEntry) { if (ModelState.IsValid) { collectionEntry.HashControlValue = Utils.GetStringSha256Hash(collectionEntry.UserNo + collectionEntry.AlbumNo + collectionEntry.ReleaseNo); db.CollectionEntry.Add(collectionEntry); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AlbumNo = new SelectList(db.Album, "EntryNo", "Author", collectionEntry.AlbumNo); ViewBag.ReleaseNo = new SelectList(db.Release, "EntryNo", "RecordCompany", collectionEntry.ReleaseNo); ViewBag.UserNo = new SelectList(db.Users, "Id", "Email", collectionEntry.UserNo); return(View(collectionEntry)); }
private void CreateEditions() { var defaultEdition = _context.Editions.IgnoreQueryFilters().FirstOrDefault(e => e.Name == EditionManager.DefaultEditionName); if (defaultEdition == null) { defaultEdition = new Edition { Name = EditionManager.DefaultEditionName, DisplayName = EditionManager.DefaultEditionName }; _context.Editions.Add(defaultEdition); _context.SaveChanges(); /* Add desired features to the standard edition, if wanted... */ } }
public bool RemoveFavourite(string userName, int productId) { MyApplicationDbContext ctx = new MyApplicationDbContext(); ApplicationUser user = applicationUserManager.FindByName(userName); ctx.FavouritesList.Remove(ctx.FavouritesList.Where(p => p.UserId == user.Id && p.ProductID == productId).First()); try { ctx.SaveChanges(); return(true); } catch (DbEntityValidationException exc) { foreach (var err in exc.EntityValidationErrors) { foreach (var errrr in err.ValidationErrors) { string st = errrr.ErrorMessage; } } return(false); } }
private void AddLanguageIfNotExists(ApplicationLanguage language) { if (_context.Languages.IgnoreQueryFilters().Any(l => l.TenantId == language.TenantId && l.Name == language.Name)) { return; } _context.Languages.Add(language); _context.SaveChanges(); }
public ActionResult Create([Bind(Include = "EntryNo,AlbumNo,ReleaseNo,FilePath,UserUploaded,PostedFile,IsMain")] Photo photo) { if (ModelState.IsValid) { if (photo.PostedFile != null && photo.AlbumNo != null) { photo.FilePath = Upload(photo.PostedFile, (int)photo.AlbumNo); } //photo.UserUploaded = User.Identity.Name; db.Photos.Add(photo); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AlbumNo = new SelectList(db.Album, "EntryNo", "MetaDescription", photo.AlbumNo); ViewBag.ReleaseNo = new SelectList(db.Release, "EntryNo", "MetaDescription", photo.ReleaseNo); //ViewBag.UserUploaded = User.Identity.Name; return(View(photo)); }
//public ActionResult Create([Bind(Include = "EntryNo,Author,Title,Duration")] Album album) //public ActionResult Create([Bind(Include = "Author,Title,Duration,YearOfProduction", Prefix ="Duration")] Album album) public ActionResult Create(Album album, string CoverArtHidden) { //bind include (albo exclude) definiuje kolumny, jakie można ustawić daną funkcją. //dzięki temu zaboiega sie próbom atakowania np. przez fidller, gdzię można przypisać wartości do propertisów, //którym nie chcemy na to pozwolic if (ModelState.IsValid) { db.Album.Add(album); db.SaveChanges(); if (!String.IsNullOrEmpty(CoverArtHidden)) { Photo photo = new Photo(); photo.AlbumNo = album.EntryNo; photo.IsMain = true; photo.UserUploaded = HttpContext.User.Identity.Name; //zapis obrazka na dysku do pliku if (!Directory.Exists(MusicCollector.Properties.Resources.PHOTO_PATH + "/" + album.EntryNo)) { Directory.CreateDirectory(MusicCollector.Properties.Resources.PHOTO_PATH + "/" + album.EntryNo); } string fileName = DateTime.Now.Subtract(DateTime.MinValue.AddYears(1969)).TotalMilliseconds + ".jpg"; string filePath = Path.Combine(MusicCollector.Properties.Resources.PHOTO_PATH + "/" + album.EntryNo, fileName); filePath = filePath.Replace(@"\", "/"); var bytes = Convert.FromBase64String(CoverArtHidden); using (var imageFile = new FileStream(filePath, FileMode.Create)) { imageFile.Write(bytes, 0, bytes.Length); imageFile.Flush(); } photo.FilePath = album.EntryNo + "/" + fileName; db.Photos.Add(photo); db.SaveChanges(); } return(RedirectToAction("Index")); } return(View(album)); }
public void Create() { new DefaultEditionCreator(_context).Create(); new DefaultLanguagesCreator(_context).Create(); new HostRoleAndUserCreator(_context).Create(); new DefaultSettingsCreator(_context).Create(); new ToDoListDefaultDataCreator(_context).Create(); _context.SaveChanges(); }
private void AddSettingIfNotExists(string name, string value, int?tenantId = null) { if (_context.Settings.IgnoreQueryFilters().Any(s => s.Name == name && s.TenantId == tenantId && s.UserId == null)) { return; } _context.Settings.Add(new Setting(tenantId, null, name, value)); _context.SaveChanges(); }
public ActionResult Delete(int?id) { var page = db.SaDPages.Where(p => p.SaDPageId == id).FirstOrDefault(); if (page != null && page.SaDPageActive == false) { db.SaDPages.Remove(page); db.SaveChanges(); return(RedirectToAction("Index")); } return(RedirectToAction("NotFound", "Error")); }
public AdministrationServiceResult addOrUpdateLaboratory(LaboratoryInputModel inputData) { AdministrationServiceResult result = new AdministrationServiceResult(); if (inputData != null) { var city = context.Municipios.Where(c => c.Id == inputData.CityId).FirstOrDefault(); if (city == null) { result.Errors.Add("Municipio no válido"); } var state = context.Estados.Where(st => st.Id == inputData.StateId).FirstOrDefault(); if (state == null) { result.Errors.Add("Estado no válido"); } if (result.IsValid) { AdministrationServiceResult operationResult = null; if (inputData.Id > 0) { operationResult = this.updateLaboratory(inputData, city, state); } else { operationResult = this.createLaboratory(inputData, city, state); } context.SaveChanges(); result.Errors.AddRange(operationResult.Errors); } } else { result.Errors.Add("Datos de entrada no válidos"); } return(result); }
private void CreateToDoLists() { // Admin role for host var hasAnyToDo = _context.ToDoLists.FirstOrDefault() != null; if (!hasAnyToDo) { _context.ToDoLists.Add(new ToDo.ToDoList { TaskName = "Utility Bill", Desciption = "Pay Utility Bill", IsCompleted = true, Category = "category 1", UserId = 1 }); _context.ToDoLists.Add(new ToDo.ToDoList { TaskName = "Membership", Desciption = "Clear Membership due", IsCompleted = false, Category = "category 1", UserId = 1 }); _context.ToDoLists.Add(new ToDo.ToDoList { TaskName = "Utility Bill 1", Desciption = "Pay Utility Bill", IsCompleted = false, Category = "category 1", UserId = 1 }); _context.ToDoLists.Add(new ToDo.ToDoList { TaskName = "Utility Bill 2", Desciption = "Pay Utility Bill", IsCompleted = false, Category = "category 1", UserId = 1 }); _context.ToDoLists.Add(new ToDo.ToDoList { TaskName = "Utility Bill 3", Desciption = "Pay Utility Bill", IsCompleted = false, Category = "category 1", UserId = 1 }); _context.ToDoLists.Add(new ToDo.ToDoList { TaskName = "Utility Bill 4", Desciption = "Pay Utility Bill", IsCompleted = false, Category = "category 1", UserId = 1 }); _context.ToDoLists.Add(new ToDo.ToDoList { TaskName = "Utility Bill 5", Desciption = "Pay Utility Bill", IsCompleted = false, Category = "category 1", UserId = 1 }); _context.ToDoLists.Add(new ToDo.ToDoList { TaskName = "Utility Bill 6", Desciption = "Pay Utility Bill", IsCompleted = false, Category = "category 1", UserId = 1 }); _context.SaveChanges(); } // Grant all permissions to admin role for host _context.SaveChanges(); }
public AdministrationServiceResult PreviewPage(DoctorsOfficeInputModel inputModel) { AdministrationServiceResult result; var referencePage = this.getPage(inputModel.page.Id); if (referencePage != null) { result = CreatePageFromReference(inputModel, referencePage); if (result.IsValid == true) { WhoWeArePage page = result.ResultObject as WhoWeArePage; result.ResultObject = page; IFormatter formatter = new BinaryFormatter(); MemoryStream stream = new MemoryStream(); formatter.Serialize(stream, page); stream.Close(); var storedPagePreview = context.PagePreviews.Find("DoctorsOffice"); if (storedPagePreview != null) { context.PagePreviews.Remove(storedPagePreview); } context.PagePreviews.Add(new PagePreview { PageName = "DoctorsOffice", PageValue = stream.GetBuffer() }); context.SaveChanges(); } } else { result = new AdministrationServiceResult(); result.Errors.Add("Pagina no válida"); } return(result); }
private void CreateDefaultTenant() { // Default tenant var defaultTenant = _context.Tenants.IgnoreQueryFilters().FirstOrDefault(t => t.TenancyName == AbpTenantBase.DefaultTenantName); if (defaultTenant == null) { defaultTenant = new Tenant(AbpTenantBase.DefaultTenantName, AbpTenantBase.DefaultTenantName); var defaultEdition = _context.Editions.IgnoreQueryFilters().FirstOrDefault(e => e.Name == EditionManager.DefaultEditionName); if (defaultEdition != null) { defaultTenant.EditionId = defaultEdition.Id; } _context.Tenants.Add(defaultTenant); _context.SaveChanges(); } }
private void CreateHostRoleAndUsers() { // Admin role for host var adminRoleForHost = _context.Roles.IgnoreQueryFilters().FirstOrDefault(r => r.TenantId == null && r.Name == StaticRoleNames.Host.Admin); if (adminRoleForHost == null) { adminRoleForHost = _context.Roles.Add(new Role(null, StaticRoleNames.Host.Admin, StaticRoleNames.Host.Admin) { IsStatic = true, IsDefault = true }).Entity; _context.SaveChanges(); } // Grant all permissions to admin role for host var grantedPermissions = _context.Permissions.IgnoreQueryFilters() .OfType <RolePermissionSetting>() .Where(p => p.TenantId == null && p.RoleId == adminRoleForHost.Id) .Select(p => p.Name) .ToList(); var permissions = PermissionFinder .GetAllPermissions(new MyApplicationAuthorizationProvider()) .Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Host) && !grantedPermissions.Contains(p.Name)) .ToList(); if (permissions.Any()) { _context.Permissions.AddRange( permissions.Select(permission => new RolePermissionSetting { TenantId = null, Name = permission.Name, IsGranted = true, RoleId = adminRoleForHost.Id }) ); _context.SaveChanges(); } // Admin user for host var adminUserForHost = _context.Users.IgnoreQueryFilters().FirstOrDefault(u => u.TenantId == null && u.UserName == AbpUserBase.AdminUserName); if (adminUserForHost == null) { var user = new User { TenantId = null, UserName = AbpUserBase.AdminUserName, Name = "admin", Surname = "admin", EmailAddress = "*****@*****.**", IsEmailConfirmed = true, IsActive = true }; user.Password = new PasswordHasher <User>(new OptionsWrapper <PasswordHasherOptions>(new PasswordHasherOptions())).HashPassword(user, "123qwe"); user.SetNormalizedNames(); adminUserForHost = _context.Users.Add(user).Entity; _context.SaveChanges(); // Assign Admin role to admin user _context.UserRoles.Add(new UserRole(null, adminUserForHost.Id, adminRoleForHost.Id)); _context.SaveChanges(); _context.SaveChanges(); } }
private void buttonLoadCitiesInformation_Click(object sender, EventArgs e) { string fileName = "K:/csv.csv"; MyApplicationDbContext context = new MyApplicationDbContext(); //List<String> messages = new List<string>(); Dictionary <String, Estados> states = new Dictionary <string, Estados>(); Dictionary <String, Municipios> cities = new Dictionary <string, Municipios>(); StreamReader fileReader = new StreamReader(fileName, Encoding.UTF8); while (!fileReader.EndOfStream) { string line = fileReader.ReadLine(); string[] lineComponents = this.getLineComponents(line); string ceco = lineComponents[0]; string branchName = lineComponents[1].Trim(); string stateName = lineComponents[2].Trim(); string cityName = lineComponents[3].Trim(); string latitude = lineComponents[4].Trim(); string longitude = lineComponents[5].Trim(); Estados state = null; if (!states.ContainsKey(stateName)) { state = new Estados() { Name = stateName }; context.Estados.Add(state); context.SaveChanges(); states[stateName] = state; } else { state = states[stateName]; } Municipios city = null; if (!cities.ContainsKey(cityName)) { city = new Municipios() { Name = cityName }; var cs = new EstadosMunicipios() { Estado = state, Municipio = city }; context.Municipios.Add(city); context.EstadosMunicipios.Add(cs); context.SaveChanges(); cities[cityName] = city; } else { city = cities[cityName]; } Branch b = new Branch() { BranchName = branchName, BranchLatitude = latitude, BranchLongitude = longitude, BranchCeco = ceco, BranchActive = true, BranchConsult = true, BranchTwentyFourHours = true, BranchFose = true, City = city, State = state }; context.Branchs.Add(b); context.SaveChanges(); } //listBox1.DataSource = messages; fileReader.Close(); }
public IActionResult Create(Question question) { _db.Questions.Add(question); _db.SaveChanges(); return(RedirectToAction("Index")); }
private void CreateRolesAndUsers() { // Admin role var adminRole = _context.Roles.IgnoreQueryFilters().FirstOrDefault(r => r.TenantId == _tenantId && r.Name == StaticRoleNames.Tenants.Admin); if (adminRole == null) { adminRole = _context.Roles.Add(new Role(_tenantId, StaticRoleNames.Tenants.Admin, StaticRoleNames.Tenants.Admin) { IsStatic = true }).Entity; _context.SaveChanges(); } // Grant all permissions to admin role var grantedPermissions = _context.Permissions.IgnoreQueryFilters() .OfType <RolePermissionSetting>() .Where(p => p.TenantId == _tenantId && p.RoleId == adminRole.Id) .Select(p => p.Name) .ToList(); var permissions = PermissionFinder .GetAllPermissions(new MyApplicationAuthorizationProvider()) .Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Tenant) && !grantedPermissions.Contains(p.Name)) .ToList(); if (permissions.Any()) { _context.Permissions.AddRange( permissions.Select(permission => new RolePermissionSetting { TenantId = _tenantId, Name = permission.Name, IsGranted = true, RoleId = adminRole.Id }) ); _context.SaveChanges(); } // Admin user var adminUser = _context.Users.IgnoreQueryFilters().FirstOrDefault(u => u.TenantId == _tenantId && u.UserName == AbpUserBase.AdminUserName); if (adminUser == null) { adminUser = User.CreateTenantAdminUser(_tenantId, "*****@*****.**"); adminUser.Password = new PasswordHasher <User>(new OptionsWrapper <PasswordHasherOptions>(new PasswordHasherOptions())).HashPassword(adminUser, "123qwe"); adminUser.IsEmailConfirmed = true; adminUser.IsActive = true; _context.Users.Add(adminUser); _context.SaveChanges(); // Assign Admin role to admin user _context.UserRoles.Add(new UserRole(_tenantId, adminUser.Id, adminRole.Id)); _context.SaveChanges(); } }