/// <summary> /// Gets the users system admin identifier. /// </summary> /// <param name="db">The database.</param> /// <param name="userId">The user identifier.</param> /// <returns></returns> internal static IUserRegistration GetAdminByUserId(PitalyticsEntities db, int userId) { var result = (from d in db.AdminUserTables where d.UserId == userId join f in db.UserRegistrations on d.AdminId equals f.UserRegistrationId select new Models.UserRegistrationModel { IsActive = f.IsActive, UserRegistrationId = f.UserRegistrationId, DateCreated = f.DateCreated, Email = f.Email, FirstName = f.FirstName, IsUserVerified = f.IsUserVerified, LastName = f.LastName, PhoneNumber = f.PhoneNumber, }).SingleOrDefault(); return(result); }
/// <summary> /// Gets the system admin users. /// </summary> /// <param name="db">The database.</param> /// <param name="userId">The user identifier.</param> /// <returns></returns> internal static IEnumerable <IUserRegistration> GetSystemAdminUsers(PitalyticsEntities db, int userId) { var result = (from d in db.AdminUserTables where d.AdminId == userId join f in db.UserRegistrations on d.UserId equals f.UserRegistrationId select new Models.UserRegistrationModel { IsActive = f.IsActive, UserRegistrationId = f.UserRegistrationId, DateCreated = f.DateCreated, Email = f.Email, FirstName = f.FirstName, IsUserVerified = f.IsUserVerified, LastName = f.LastName, PhoneNumber = f.PhoneNumber, }).OrderBy(x => x.UserRegistrationId); return(result); }
/// Gets the tax return by jurisidction identifier. /// </summary> /// <param name="db">The database.</param> /// <param name="jurisdictionId">The jurisdiction identifier.</param> /// <returns></returns> internal static IEnumerable <ITaxReturn> GetTaxReturnList(PitalyticsEntities db) { var result = (from d in db.TaxReturns join f in db.Branches on d.BranchId equals f.BranchId join s in db.UserRegistrations on d.UserRegistrationId equals s.UserRegistrationId join m in db.IncomeTypes on d.IncomeTypeId equals m.IncomeTypeId select new Models.TaxReturnModel { TaxReturnId = d.TaxReturnId, BeneficiaryTin = d.BeneficiaryTin, BeneficiaryAddress = d.BeneficiaryAddress, BeneficiaryName = d.BeneficiaryName, BranchName = f.BranchName, BVN = d.BVN, ContractAmount = d.ContractAmount, ContractDate = d.ContractDate, IncomeTypeName = m.IncomeTypeName, Email = s.Email, WHT_Amount = d.WHT_Amount, WHT_Rate = d.WHT_Rate, InvoiceNo = d.InvoiceNo, AgentOfDeductionId = d.AgentOfDeductionId, BranchId = d.BranchId, IncomeTypeId = d.IncomeTypeId, JurisdictionId = d.JurisdictionId }).OrderBy(x => x.TaxReturnId); return(result); }
/// <summary> /// Gets the user role action collection identifier. /// </summary> /// <param name="db">The database.</param> /// <param name="Id">The identifier.</param> /// <returns></returns> internal static IEnumerable <int> GetUserRoleActionCollectionId(PitalyticsEntities db, string email) { var result = (from d in db.UserRoles // join s in db.AppRoles on d.AppRoleId equals s.AppRoleId where d.Email == email select d.RoleId); return(result); }
internal static IInlandRevenue getInlandRevenueNameByValue(PitalyticsEntities db, string inlandRevenueName) { var result = (from d in db.InlandRevenues where d.InlandRevenueName.Equals(inlandRevenueName) select new InlandRevenueModel { InlandRevenueName = d.InlandRevenueName }).FirstOrDefault(); return(result); }
/// </summary> /// <summar /// <summary> /// Gets the branch description by value. /// </summary> /// <param name="db">The database.</param> /// <param name="description">The description.</param> /// <returns></returns> internal static IBranch getBranchDescriptionByValue(PitalyticsEntities db, string description) { var result = (from d in db.Branches where d.Description.Equals(description) select new BranchModel { Description = d.Description }).FirstOrDefault(); return(result); }
/// <summary> /// Gets the industry description by value. /// </summary> /// <param name="db">The database.</param> /// <param name="description">The description.</param> /// <returns></returns> internal static IIndustry getIndustryDescriptionByValue(PitalyticsEntities db, string industryName) { var result = (from d in db.Industries where d.IndustryName.Equals(industryName) select new IndustryModel { IndustryName = d.IndustryName, Description = d.Description }).FirstOrDefault(); return(result); }
/// <summary> /// Gets the type of the file. /// </summary> /// <param name="db">The database.</param> /// <returns></returns> internal static IEnumerable <IFileType> GetFileType(PitalyticsEntities db) { var result = (from d in db.FileTypes select new Models.FileTypeModel { FileTypeId = d.FileTypeId, FileName = d.FileTypeName, Description = d.Description, }).OrderBy(x => x.Description); return(result); }
/// <summary> /// Gets the income type jurisdiction. /// </summary> /// <param name="db">The database.</param> /// <param name="jurisidctionId">The jurisidction identifier.</param> /// <param name="incomeTypeId">The income type identifier.</param> /// <returns></returns> internal static IJurisdictionIncomeType getIncomeTypeJurisdiction(PitalyticsEntities db, int jurisidctionId, int incomeTypeId) { var result = (from d in db.JurisdictionIncomeTypes where d.JurisdictionId.Equals(jurisidctionId) && d.IncomeTypeId == incomeTypeId select new JurisdictionIncomeTypeModel { IncomeTypeId = d.IncomeTypeId } ).FirstOrDefault(); return(result); }
/// <summary> /// Gets the jurisdiction description by value. /// </summary> /// <param name="db">The database.</param> /// <param name="description">The description.</param> /// <returns></returns> internal static IJurisdiction GetJurisdictionDescriptionByValue(PitalyticsEntities db, string description) { var result = (from d in db.Jurisdictions where d.JurisdictionName.Equals(description) select new JurisdictionModel { JurisdictionName = d.JurisdictionName, Description = d.Description }).FirstOrDefault(); return(result); }
/// <summary> /// Gets the jurisdiction by branch identifier. /// </summary> /// <param name="db">The database.</param> /// <param name="Id">The identifier.</param> /// <returns></returns> internal static IBranchJurisdiction GetJurisdictionByBranchId(PitalyticsEntities db, int Id) { var result = (from d in db.BranchJurisdictions where d.BranchId == Id select new BranchJurisdictionModel { JurisdictionId = d.JurisdictionId } ).SingleOrDefault(); return(result); }
internal static IEnumerable <IInlandRevenue> getInlandRevenue(PitalyticsEntities db) { var result = (from d in db.InlandRevenues select new Models.InlandRevenueModel { InlandRevenueId = d.InlandRevenueId, InlandRevenueName = d.InlandRevenueName, DateCreated = d.DateCreated, IsActive = d.IsActive, }).OrderBy(x => x.InlandRevenueName); return(result); }
/// <summary> /// Gets the branch by identifier. /// </summary> /// <param name="db">The database.</param> /// <param name="Id">The identifier.</param> /// <returns></returns> internal static IBranch GetBranchById(PitalyticsEntities db, int Id) { var result = (from d in db.Branches where d.BranchId.Equals(Id) select new BranchModel { BranchId = d.BranchId, Description = d.Description } ).SingleOrDefault(); return(result); }
/// </summary> /// <param name="db">The database.</param> /// <returns></returns> internal static IEnumerable <IUserBranch> GetBranchUser(PitalyticsEntities db) { var result = (from d in db.UserBranches join s in db.Branches on d.BranchId equals s.BranchId join u in db.UserRegistrations on d.UserRegistrationId equals u.UserRegistrationId select new Models.UserBranchModel { BranchName = s.BranchName, UserName = u.Email }).OrderBy(x => x.UserBranchId); return(result); }
/// <summary> /// Gets the agent of deduction by branch identifier. /// </summary> /// <param name="db">The database.</param> /// <param name="Id">The identifier.</param> /// <returns></returns> internal static IAgentOfDeductionBranch GetAgentOfDeductionByBranchId(PitalyticsEntities db, int Id) { var result = (from d in db.AgentOfDeductionBranches where d.BranchId.Equals(Id) select new AgentOfDeductionBranchModel { BranchId = d.BranchId, AgentOfDeductionId = d.AgentOfDeductionId } ).SingleOrDefault(); return(result); }
/// <summary> /// Gets the agent of deduction identifier. /// </summary> /// <param name="db">The database.</param> /// <param name="userId">The user identifier.</param> /// <returns></returns> internal static IAgentOfDeduction GetAgentOfDeductionId(PitalyticsEntities db, int userId) { var result = (from d in db.AgentOfDeductionInfoes where d.UserRegistrationId == userId select new AgentOfDeductionModel { AgentOfDeductionId = d.AgentOfDeductionId }).FirstOrDefault(); var a = result; return(result); }
/// <summary> /// Gets the industry. /// </summary> /// <param name="db">The database.</param> /// <returns></returns> internal static IEnumerable <IIndustry> GetIndustry(PitalyticsEntities db) { var result = (from d in db.Industries select new Models.IndustryModel { IndustryId = d.IndustryId, IndustryName = d.IndustryName, Description = d.Description, IsActive = d.IsActive, DateCreated = d.DateCreated }).OrderBy(x => x.Description); return(result); }
/// <summary> /// Gets the tax authority information. /// </summary> /// <param name="db">The database.</param> /// <param name="inlandRevenueId">The inland revenue identifier.</param> /// <param name="jurisidctionId">The jurisidction identifier.</param> /// <returns></returns> internal static IEnumerable <ITaxAuthority> GetTaxAuthorityInfo(PitalyticsEntities db, int inlandRevenueId, int jurisidctionId) { var result = (from d in db.TaxAuthorities where d.InlandRevenueId == inlandRevenueId && d.JurisdictionId == jurisidctionId select new Models.TaxAuthorityModel { InlandRevenueId = d.InlandRevenueId, JurisdictionId = d.InlandRevenueId, DateCreated = d.DateCreated, IsActive = d.IsActive, }).OrderBy(x => x.JurisdictionId); return(result); }
/// <summary> /// Gets the branch. /// </summary> /// <param name="db">The database.</param> /// <returns></returns> internal static IEnumerable <IBranch> getBranch(PitalyticsEntities db) { var result = (from d in db.Branches select new Models.BranchModel { BranchId = d.BranchId, BranchName = d.BranchName, IsActive = d.IsActive, DateCreated = d.DateCreated, Description = d.Description }).OrderBy(x => x.Description); return(result); }
/// <summary> /// /// </summary> /// <param name="db"></param> /// <param name="Id"></param> /// <returns></returns> internal static IInlandRevenue GetInlandRevenueById(PitalyticsEntities db, int Id) { var result = (from d in db.InlandRevenues where d.InlandRevenueId.Equals(Id) select new InlandRevenueModel { InlandRevenueId = d.InlandRevenueId, InlandRevenueName = d.InlandRevenueName, DateCreated = d.DateCreated, IsActive = d.IsActive, } ).SingleOrDefault(); return(result); }
/// <summary> /// Gets the color. /// </summary> /// <param name="db">The database.</param> /// <returns></returns> internal static IEnumerable <IJurisdiction> GetJurisdictions(PitalyticsEntities db) { var result = (from d in db.Jurisdictions select new JurisdictionModel { JurisdictionId = d.JurisdictionId, JurisdictionName = d.JurisdictionName, DateCreated = d.DateCreated, IsActive = d.IsActive, Description = d.Description }).OrderBy(x => x.Description); return(result); }
/// <summary> /// Gets the jurisdiction by identifier. /// </summary> /// <param name="db">The database.</param> /// <param name="Id">The identifier.</param> /// <returns></returns> internal static IJurisdiction GetJurisdictionById(PitalyticsEntities db, int Id) { var result = (from d in db.Jurisdictions where d.JurisdictionId.Equals(Id) select new JurisdictionModel { JurisdictionId = d.JurisdictionId, JurisdictionName = d.JurisdictionName, Description = d.Description, IsActive = d.IsActive } ).SingleOrDefault(); return(result); }
/// <param name="db">The database.</param> /// <param name="Id">The identifier.</param> /// <returns></returns> internal static IEnumerable <IIncomeType> GetIncomeTypeByBranchId(PitalyticsEntities db, int branchId) { var result = (from d in db.BranchJurisdictions where d.BranchId == branchId join s in db.JurisdictionIncomeTypes on d.JurisdictionId equals s.JurisdictionId join w in db.IncomeTypes on s.IncomeTypeId equals w.IncomeTypeId select new IncomeTypeModel { IncomeTypeId = w.IncomeTypeId, IncomeTypeName = w.IncomeTypeName } ).OrderBy(x => x.IncomeTypeId); return(result); }
/// <summary> /// Gets the type of the income. /// </summary> /// <param name="db">The database.</param> /// <returns></returns> internal static IEnumerable <IIncomeType> GetIncomeType(PitalyticsEntities db) { var result = (from d in db.IncomeTypes select new Models.IncomeTypeModel { IncomeTypeId = d.IncomeTypeId, IncomeTypeName = d.IncomeTypeName, Description = d.Description, WHT_Rate = d.WHT_Rate, IsActive = d.IsActive, DateCreated = d.DateCreated }).OrderBy(x => x.Description); return(result); }
/// <summary> /// Gets the tax authority by identifier. /// </summary> /// <param name="db">The database.</param> /// <param name="userId">The user identifier.</param> /// <returns></returns> internal static ITaxAuthority GetTaxAuthorityById(PitalyticsEntities db, int userId) { var result = (from d in db.TaxAuthorities where d.UserRegistrationId == userId select new TaxAuthorityModel { JurisdictionId = d.JurisdictionId } ).SingleOrDefault(); return(result); }
/// <summary> /// Gets the user roles collection. /// </summary> /// <param name="db">The database.</param> /// <returns></returns> internal static IEnumerable <IUserRolesModel> GetUserRolesCollection(PitalyticsEntities db) { var result = (from d in db.Roles select new UserRolesModel { UserRolesDescription = d.RoleName, UserRolesId = d.RoleId } ).OrderBy(x => x.UserRolesId); return(result); }
/// <summary> /// Gets the branch user by user identifier. /// </summary> /// <param name="db">The database.</param> /// <param name="userId">The user identifier.</param> /// <returns></returns> internal static IEnumerable <IBranch> GetBranchByJurisdictionId(PitalyticsEntities db, int jurisidictionId) { var result = (from d in db.BranchJurisdictions where d.JurisdictionId == jurisidictionId join s in db.Branches on d.BranchId equals s.BranchId where s.IsActive == true select new Models.BranchModel { BranchName = s.BranchName, BranchId = s.BranchId, }).OrderBy(x => x.BranchId); return(result); }
/// <summary> /// Gets the branch user by user identifier. /// </summary> /// <param name="db">The database.</param> /// <param name="userId">The user identifier.</param> /// <returns></returns> internal static IEnumerable <IBranch> GetBranchUserByUserId(PitalyticsEntities db, int userId) { var result = (from d in db.UserBranches where d.UserRegistrationId == userId join s in db.Branches on d.BranchId equals s.BranchId where s.IsActive == true select new Models.BranchModel { BranchName = s.BranchName, BranchId = s.BranchId, IsActive = d.IsActive }).OrderBy(x => x.BranchId); return(result); }
/// <summary> /// Gets the industry by identifier. /// </summary> /// <param name="db">The database.</param> /// <param name="Id">The identifier.</param> /// <returns></returns> internal static IIndustry GetIndustryById(PitalyticsEntities db, int Id) { var result = (from d in db.Industries where d.IndustryId.Equals(Id) select new IndustryModel { IndustryId = d.IndustryId, IndustryName = d.IndustryName, Description = d.Description, IsActive = d.IsActive, DateCreated = d.DateCreated } ).SingleOrDefault(); return(result); }
/// <summary> /// Gets the income type by identifier. /// </summary> /// <param name="db">The database.</param> /// <param name="Id">The identifier.</param> /// <returns></returns> internal static IIncomeType GetIncomeTypeById(PitalyticsEntities db, int Id) { var result = (from d in db.IncomeTypes where d.IncomeTypeId.Equals(Id) select new IncomeTypeModel { IncomeTypeId = d.IncomeTypeId, IncomeTypeName = d.IncomeTypeName, Description = d.Description, WHT_Rate = d.WHT_Rate, IsActive = d.IsActive, DateCreated = d.DateCreated } ).SingleOrDefault(); return(result); }