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