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