/// <summary> /// Add a new library /// </summary> /// <param name="library">The library to add</param> /// <returns>True if library is added successfuly otherwise false</returns> public bool AddNewLibrary(Library library) { if (library != null) { db.Library.Add(library); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// Add a new student /// </summary> /// <param name="student">The student to add</param> /// <returns>True if student is added successfuly otherwise false</returns> public bool AddNewStudent(Student student) { if (student != null) { db.Student.Add(student); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// Add a new CD_DVD_BR /// </summary> /// <param name="cD_DVD_BR">The CD_DVD_BR to add</param> /// <returns>True if CD_DVD_BR is added successfuly otherwise false</returns> public bool AddNewCD_DVD_BR(CD_DVD_BR cD_DVD_BR) { if (cD_DVD_BR != null) { db.CD_DVD_BR.Add(cD_DVD_BR); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// Add a new patron /// </summary> /// <param name="patron">The patron to add</param> /// <returns>True if patron is added successfuly otherwise false</returns> public bool AddNewPatron(Patron patron) { if (patron != null) { db.Patron.Add(patron); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// Add a new parent /// </summary> /// <param name="parent">The parent to add</param> /// <returns>True if parent is added successfuly otherwise false</returns> public bool AddNewParent(Parent parent) { if (parent != null) { db.Parent.Add(parent); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// Add a new address /// </summary> /// <param name="address">The address to add</param> /// <returns>True if address is added successfuly otherwise false</returns> public bool AddNewAddress(Address address) { if (address != null) { db.Address.Add(address); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// Add a new Author /// </summary> /// <param name="author">The Author to add</param> /// <returns>True if Author is added successfuly otherwise false</returns> public bool AddNewAuthor(Author author) { if (author != null) { db.Author.Add(author); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// Add a new Library_Material /// </summary> /// <param name="library_Material">The Library Material to add</param> /// <returns>True if Library Material is added successfuly otherwise false</returns> public bool AddNewLibraryMaterial(Library_Material library_Material) { if (library_Material != null) { db.Library_Material.Add(library_Material); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// Add a new notification /// </summary> /// <param name="notification">The notification to add</param> /// <returns>True if notification is added successfuly otherwise false</returns> public bool AddNewNotification(Notification notification) { if (notification != null) { db.Notification.Add(notification); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// Add a new employee /// </summary> /// <param name="employee">The employee to add</param> /// <returns>True if employee is added successfuly otherwise false</returns> public bool AddNewEmployee(Employee employee) { if (employee != null) { db.Employee.Add(employee); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// Add a new teacher /// </summary> /// <param name="teacher">The teacher to add</param> /// <returns>True if teacher is added successfuly otherwise false</returns> public bool AddNewTeacher(Teacher teacher) { if (teacher != null) { db.Teacher.Add(teacher); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// Add a new borrowing /// </summary> /// <param name="borrowing">The borrowing to add</param> /// <returns>True if borrowing is added successfuly otherwise false</returns> public bool AddNewBorrowing(Borrowing borrowing) { if (borrowing != null) { db.Borrowing.Add(borrowing); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// Add a new Journal /// </summary> /// <param name="journal">The Journal to add</param> /// <returns>True if Journal is added successfuly otherwise false</returns> public bool AddNewJournal(Journal journal) { if (journal != null) { db.Journal.Add(journal); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// Add a new Publisher /// </summary> /// <param name="publisher">The Publisher to add</param> /// <returns>True if Publisher is added successfuly otherwise false</returns> public bool AddNewPublisher(Publisher publisher) { if (publisher != null) { db.Publisher.Add(publisher); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// Add a new Book /// </summary> /// <param name="book">The Book to add</param> /// <returns>True if Book is added successfuly otherwise false</returns> public bool AddNewBook(Book book) { if (book != null) { db.Book.Add(book); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// Add a new Schedule /// </summary> /// <param name="schedule">The Schedule to add</param> /// <returns>True if Schedule is added successfuly otherwise false</returns> public bool AddNewSchedule(Schedule schedule) { if (schedule != null) { db.Schedule.Add(schedule); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// Add a new Donor /// </summary> /// <param name="donor">The Donor to add</param> /// <returns>True if Donor is added successfuly otherwise false</returns> public bool AddNewDonor(Donor donor) { if (donor != null) { db.Donor.Add(donor); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// Add content to library material author /// </summary> /// <param name="materialAuthor">The library material author to add</param> /// <returns>True if materialAuthor is added successfuly otherwise false</returns> public bool AddNewLibraryMaterialAuthor(LibraryMaterial_Author materialAuthor) { if (materialAuthor != null) { db.LibraryMaterial_Author.Add(materialAuthor); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// Add a new hold /// </summary> /// <param name="hold">The hold to add</param> /// <returns>True if hold is added successfuly otherwise false</returns> public bool AddNewHold(Hold hold) { if (hold != null) { db.Hold.Add(hold); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// Add a new appointment /// <returns>True if address is added successfuly otherwise false</returns> public bool AddNewAppointment(Time_Slot t) { if (t != null) { db.Time_Slot.Add(t); db.SaveChanges(); return(true); } return(false); }
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 void Create() { new DefaultEditionCreator(_context).Create(); new DefaultLanguagesCreator(_context).Create(); new HostRoleAndUserCreator(_context).Create(); new DefaultSettingsCreator(_context).Create(); _context.SaveChanges(); }
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(); }
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 void AddEmployeeLeave(EmployeeLeave employeeLeave) { var empRepMang = context.Employees.Where(m => m.ID == employeeLeave.EmpID).FirstOrDefault(); employeeLeave.NoOfDays = (decimal)((employeeLeave.ToDate - employeeLeave.FromDate).TotalDays); context.EmployeeLeaves.Add(employeeLeave); context.SaveChanges(); if (employeeLeave.Status == LeaveStatus.Pending) { context.EmployeeLeaveApprovals.Add(new EmployeeLeaveApproval { ApproverID = empRepMang.ReportingManager, LeaveID = employeeLeave.ID, Status = LeaveStatus.Pending }); context.Entry(employeeLeave.employeeLeaveApproval).Reference(e => e.Approver).Load(); } //employeeLeave = context.EmployeeLeaves.Include(p => p.LeaveType).Include(p=>p.employeeLeaveApproval.Approver).Where(p => p.ID == employeeLeave.ID).FirstOrDefault(); context.Entry(employeeLeave).Reference(e => e.LeaveType).Load(); context.Entry(employeeLeave).Reference(e => e.employeeLeaveApproval).Load(); context.SaveChanges(); }
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(); } }
protected bool DeleteDocs(FileDocument[] files) { bool result = true; string path = Server.MapPath("~/Uploads/"); try { foreach (FileDocument f in files) { string fullname = path + f.Id.Encode(); if (System.IO.File.Exists(fullname)) { System.IO.File.Delete(fullname); } db.Files.Remove(f); } db.SaveChanges(); } catch (Exception) { result = false; } return(result); }
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 LMSAuthorizationProvider()) .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 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 LMSAuthorizationProvider()) .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(); } }