protected override void SeedData(BaseSeeder <BillPaymentStepsTemplate> builder)
{
builder.HasData(new BillPaymentStepsTemplate
{
ID = 1,
BillID = BillIDConstants.HomeLoanAmort,
Title = "7/11",
ShortDesc = "Go to nearest 7/11, ask cashier for instructions lol",
LongDesc = "Just kidding, see below very long instructions",
Keywords = "7/11,711"
});
builder.HasData(new BillPaymentStepsTemplate
{
ID = 2,
BillID = BillIDConstants.HomeLoanAmort,
Title = "GCash",
ShortDesc = "Payment using GCash, follow this instruction",
LongDesc = "See below very long instructions",
Keywords = "e-wallet,ewallet,wallet,gcash"
});
builder.HasData(new BillPaymentStepsTemplate
{
ID = 3,
BillID = BillIDConstants.HomeLoanAmort,
Title = "Paymaya",
ShortDesc = "Payment using Paymaya, follow this instruction",
LongDesc = "See below very long instructions",
Keywords = "e-wallet,ewallet,wallet,paymaya"
});
}
protected override void SeedData(BaseSeeder <PayRun> builder)
{
#region 2021
builder.HasData(new PayRun
{
ClientID = ClientConstant.Default,
PlanYear = 2021,
PayRunID = 1,
PayoutDate = new DateTime(2021, 1, 16),
CutOffStart = new DateTime(2020, 12, 1),
CutOffEnd = new DateTime(2020, 12, 31),
PeriodStart = new DateTime(2021, 1, 1),
PeriodEnd = new DateTime(2021, 1, 31)
});
builder.HasData(new PayRun
{
ClientID = ClientConstant.Default,
PlanYear = 2021,
PayRunID = 2,
PayoutDate = new DateTime(2021, 2, 16),
CutOffStart = new DateTime(2021, 1, 1),
CutOffEnd = new DateTime(2021, 1, 31),
PeriodStart = new DateTime(2021, 2, 1),
PeriodEnd = new DateTime(2021, 2, 28)
});
#endregion
}
protected override void SeedData(BaseSeeder <DeductionType> builder)
{
builder.HasData(new DeductionType
{
DeductionTypeID = 1,
ShortDesc = "Normal",
LongDesc = "Normal"
});
builder.HasData(new DeductionType
{
DeductionTypeID = 2,
ShortDesc = "Contribution",
LongDesc = "Contribution"
});
}
protected override void SeedData(BaseSeeder <User> builder)
{
builder.HasData(new User
{
ID = Guid.Empty.Increment(1),
FirstName = "Admin",
LastName = "Admin"
});
builder.HasData(new User
{
ID = Guid.Empty.Increment(2),
FirstName = "Vincent",
LastName = "Dagpin"
});
}
protected override void SeedData(BaseSeeder <Author> builder)
{
builder.HasData(new
{
ID = -1
});
}
protected override void SeedData(BaseSeeder <Client> builder)
{
builder.HasData(new Client
{
ClientID = ClientConstant.Default,
Name = "Aerish Inc."
});
}
protected override void SeedData(BaseSeeder <Table> builder)
{
builder.HasData(new Table
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
ShortDesc = "REVISED WITHHOLDING TAX TABLE",
LongDesc = "REVISED WITHHOLDING TAX TABLE",
EffectiveStartOn = new DateTime(2018, 1, 1),
EffectiveEndOn = new DateTime(2022, 12, 31)
});
builder.HasData(new Table
{
TableID = 2,
Code = TableCodeConstants.PhilHealth,
ShortDesc = "PhilHealth",
LongDesc = "PhilHealth",
EffectiveStartOn = new DateTime(2020, 1, 1),
EffectiveEndOn = new DateTime(2020, 12, 31),
Reference = "https://www.philhealth.gov.ph/circulars/2019/circ2019-0009.pdf"
});
builder.HasData(new Table
{
TableID = 3,
Code = TableCodeConstants.PhilHealth,
ShortDesc = "PhilHealth",
LongDesc = "PhilHealth",
EffectiveStartOn = new DateTime(2021, 1, 1),
EffectiveEndOn = new DateTime(2021, 12, 31),
Reference = "https://www.philhealth.gov.ph/circulars/2020/circ2020-0005.pdf"
});
builder.HasData(new Table
{
TableID = 4,
Code = TableCodeConstants.SSS,
ShortDesc = "SSS",
LongDesc = "PhilHSSSealth",
EffectiveStartOn = new DateTime(2021, 1, 1),
EffectiveEndOn = new DateTime(2021, 12, 31),
Reference = "https://www.sss.gov.ph/sss/DownloadContent?fileName=2021-CONTRIBUTION-SCHEDULE.pdf"
});
}
protected override void SeedData(BaseSeeder <OTRateType> builder)
{
builder.HasData(new OTRateType
{
OTRateTypeID = 1,
ShortDesc = "Night Differential",
LongDesc = "Night Differential"
});
}
protected override void SeedData(BaseSeeder <PlanYear> builder)
{
builder.HasData(new PlanYear
{
Year = 2020,
EffectivityStart = new DateTime(2020, 1, 1, 0, 0, 0, DateTimeKind.Utc),
EffectivityEnd = new DateTime(2020 + 1, 1, 1, 0, 0, 0, DateTimeKind.Utc).AddSeconds(-1),
IsActive = true
});
builder.HasData(new PlanYear
{
Year = 2021,
EffectivityStart = new DateTime(2021, 1, 1, 0, 0, 0, DateTimeKind.Utc),
EffectivityEnd = new DateTime(2021 + 1, 1, 1, 0, 0, 0, DateTimeKind.Utc).AddSeconds(-1),
IsActive = false
});
}
protected override void SeedData(BaseSeeder <LoanType> builder)
{
builder.HasData(new LoanType
{
LoanTypeID = 1,
ShortDesc = "Company Loan",
LongDesc = "Company Loan"
});
}
protected override void SeedData(BaseSeeder <Bill> builder)
{
builder.HasData(new Bill
{
ID = BillIDConstants.Globe,
Code = "Globe",
ShortDesc = "Globe",
LongDesc = "Globe"
});
builder.HasData(new Bill
{
ID = BillIDConstants.Meralco,
Code = "Meralco",
ShortDesc = "Meralco",
LongDesc = "Meralco"
});
builder.HasData(new Bill
{
ID = BillIDConstants.HomeLoanAmort,
Code = "Home Loan Amortization",
ShortDesc = "Home Loan Amortization",
LongDesc = "Home Loan Amortization"
});
builder.HasData(new Bill
{
ID = BillIDConstants.CarLoanAmort,
Code = "Car Loan Amortization",
ShortDesc = "Car Loan Amortization",
LongDesc = "Car Loan Amortization"
});
builder.HasData(new Bill
{
ID = BillIDConstants.CreditCard,
Code = "Credit Card",
ShortDesc = "Credit Card",
LongDesc = "Credit Card"
});
}
protected override void SeedData(BaseSeeder <Job> builder)
{
builder.HasData(new Job
{
ClientID = ClientConstant.Default,
JobID = MainConstants.Job.MainCalc,
ShortDesc = "Main Calc",
LongDesc = "Main Calc",
IsEnabled = true,
TaskHandlerProviderID = TaskHandlerProviderConstants.MainCalc
});
builder.HasData(new Job
{
ClientID = ClientConstant.Default,
JobID = 404,
ShortDesc = "Rollback Employee",
LongDesc = "Rollback Employee",
IsEnabled = true,
TaskHandlerProviderID = TaskHandlerProviderConstants.RollbackCalc
});
builder.HasData(new Job
{
ClientID = ClientConstant.Default,
JobID = MainConstants.Job.ImportPerson,
ShortDesc = "Import Person Data",
LongDesc = "Import Person Data",
IsEnabled = true,
TaskHandlerProviderID = TaskHandlerProviderConstants.ImportPerson
});
builder.HasData(new Job
{
ClientID = ClientConstant.Default,
JobID = MainConstants.Job.ImportBasicPay,
ShortDesc = "Import Basic Pay Data",
LongDesc = "Import Basic Pay Data",
IsEnabled = true,
TaskHandlerProviderID = TaskHandlerProviderConstants.ImportBasicPay
});
}
protected override void SeedData(BaseSeeder <User> builder)
{
builder.HasData(new
{
ID = -1,
FirstName = "Mar",
LastName = "Dagpin",
MiddleName = "",
Gender = Gender.Male
});
}
protected override void SeedData(BaseSeeder <TextTemplate> builder)
{
builder.HasData(new TextTemplate
{
ID = 1,
Code = TextTemplateCodeConstants.PayWithLynxTermsOfService,
Title = "Pay with Lynx Terms of Service",
Content = "Test",
RecordStatus = RecordStatus.Active,
UpdatedOn = new DateTime(2021, 3, 1),
Version = "1.0"
});
}
protected override void SeedData(BaseSeeder <Loan> builder)
{
builder.HasData(new Loan
{
LoanID = 1,
LoanTypeID = 1,
ShortDesc = "HMO Premium Payable",
LongDesc = "HMO Premium Payable",
ClientID = ClientConstant.Default,
Code = LoanCodeConstants.HMOPremiumPayable,
IsEnabled = true,
TaskHandlerProviderID = TaskHandlerProviderConstants.HMOPremiumPayableLoan
});
}
protected override void SeedData(BaseSeeder <EarningType> builder)
{
builder.HasData(new EarningType
{
EarningTypeID = 1,
ShortDesc = "Basic Pay",
LongDesc = "Basic Pay"
});
builder.HasData(new EarningType
{
EarningTypeID = 2,
ShortDesc = "Allowance",
LongDesc = "Allowance"
});
builder.HasData(new EarningType
{
EarningTypeID = 3,
ShortDesc = "Absence",
LongDesc = "Absence"
});
}
protected override void SeedData(BaseSeeder <EmailWorker> builder)
{
builder.HasData(new EmailWorker
{
ID = 1,
AssemblyName = typeof(ReadUserBillFromGlobeEmailCmdHandler).Assembly.FullName,
TypeName = typeof(ReadUserBillFromGlobeEmailCmdHandler).FullName
});
builder.HasData(new EmailWorker
{
ID = 5,
AssemblyName = typeof(ReadUserBillFromBDOCmdHandler).Assembly.FullName,
TypeName = typeof(ReadUserBillFromBDOCmdHandler).FullName
});
builder.HasData(new EmailWorker
{
ID = 6,
AssemblyName = typeof(ReadUserBillFromMetrobankCmdHandler).Assembly.FullName,
TypeName = typeof(ReadUserBillFromMetrobankCmdHandler).FullName
});
}
protected override void SeedData(BaseSeeder <ProviderType> builder)
{
builder.HasData(new ProviderType
{
ID = ProviderTypeConstants.Scheduled,
ShortDesc = "Scheduled",
LongDesc = "Scheduled"
});
builder.HasData(new ProviderType
{
ID = ProviderTypeConstants.WebService,
ShortDesc = "API",
LongDesc = "API"
});
builder.HasData(new ProviderType
{
ID = ProviderTypeConstants.Email,
ShortDesc = "Email",
LongDesc = "Email"
});
}
protected override void SeedData(BaseSeeder <UserLogin> builder)
{
var hasher = new PasswordHasher();
builder.HasData(new UserLogin
{
ID = Guid.Empty.Increment(1),
Salt = Encoding.ASCII.GetBytes(Guid.Empty.Increment(1).ToString()),
Password = hasher.HashPassword(Encoding.ASCII.GetBytes(Guid.Empty.Increment(1).ToString()), "k4m0t3"),
Username = "******",
IsTemporaryPassword = true,
TemporaryPassword = "******"
});
builder.HasData(new UserLogin
{
ID = Guid.Empty.Increment(2),
Salt = Encoding.ASCII.GetBytes(Guid.Empty.Increment(2).ToString()),
Password = hasher.HashPassword(Encoding.ASCII.GetBytes(Guid.Empty.Increment(2).ToString()), "k4m0t3"),
Username = "******",
IsTemporaryPassword = true,
TemporaryPassword = "******"
});
}
protected override void SeedData(BaseSeeder <BillProvider> builder)
{
builder.HasData(new BillProvider
{
ID = 1,
BillID = BillIDConstants.Globe,
ProviderTypeID = ProviderTypeConstants.Email
});
builder.HasData(new BillProvider
{
ID = 2,
BillID = BillIDConstants.Meralco,
ProviderTypeID = ProviderTypeConstants.Email
});
builder.HasData(new BillProvider
{
ID = 3,
BillID = BillIDConstants.HomeLoanAmort,
ProviderTypeID = ProviderTypeConstants.Scheduled
});
builder.HasData(new BillProvider
{
ID = 4,
BillID = BillIDConstants.CarLoanAmort,
ProviderTypeID = ProviderTypeConstants.Scheduled
});
builder.HasData(new BillProvider
{
ID = 5,
ShortDesc = "BDO",
LongDesc = "BDO",
BillID = BillIDConstants.CreditCard,
ProviderTypeID = ProviderTypeConstants.Email
});
builder.HasData(new BillProvider
{
ID = 6,
ShortDesc = "Metrobank",
LongDesc = "Metrobank",
BillID = BillIDConstants.CreditCard,
ProviderTypeID = ProviderTypeConstants.Email
});
}
protected override void SeedData(BaseSeeder <PaymentMode> builder)
{
builder.HasData(new PaymentMode
{
PaymentModeID = 1,
ShortDesc = "Weekly",
LongDesc = "Weekly"
});
builder.HasData(new PaymentMode
{
PaymentModeID = 2,
ShortDesc = "Bi-weekly",
LongDesc = "Bi-weekly"
});
builder.HasData(new PaymentMode
{
PaymentModeID = 3,
ShortDesc = "Semi-Monthly",
LongDesc = "Semi-Monthly"
});
builder.HasData(new PaymentMode
{
PaymentModeID = 4,
ShortDesc = "Monthly",
LongDesc = "Monthly"
});
builder.HasData(new PaymentMode
{
PaymentModeID = 5,
ShortDesc = "Daily",
LongDesc = "Daily"
});
builder.HasData(new PaymentMode
{
PaymentModeID = 6,
ShortDesc = "Annually",
LongDesc = "Annually"
});
}
protected override void SeedData(BaseSeeder <Earning> builder)
{
builder.HasData(new Earning
{
EarningID = 1,
EarningTypeID = EarningTypeIDConstants.BasicPay,
Code = EarningCodeConstants.BasicPay,
ClientID = ClientConstant.Default,
ShortDesc = "Basic Pay",
LongDesc = "Basic Pay",
IsTaxable = true,
IsReceivable = true,
IsEnabled = true,
TaskHandlerProviderID = TaskHandlerProviderConstants.BasicPay
});
builder.HasData(new Earning
{
EarningID = 2,
EarningTypeID = EarningTypeIDConstants.Absence,
Code = EarningCodeConstants.Absent,
ClientID = ClientConstant.Default,
ShortDesc = "Absent",
LongDesc = "Absent",
ComputedBy = ComputedBy.Hour,
IsComputed = true,
IsDeMinimis = false,
IsAdjustIfAbsent = true,
IsNegativeComputation = true,
IsPartOfBasicPay = true,
IsTaxable = true,
IsReceivable = false,
IsEnabled = false
});
builder.HasData(new Earning
{
EarningID = 3,
EarningTypeID = EarningTypeIDConstants.Allowance,
Code = EarningCodeConstants.InternetAllowance,
ClientID = ClientConstant.Default,
ShortDesc = "Internet Allowance",
LongDesc = "Internet Allowance",
IsDeMinimis = true,
IsTaxable = true,
IsReceivable = true,
IsEnabled = true,
TaskHandlerProviderID = TaskHandlerProviderConstants.DefaultEarning
});
builder.HasData(new Earning
{
EarningID = 4,
EarningTypeID = EarningTypeIDConstants.Allowance,
Code = EarningCodeConstants.ShiftAllowance,
ClientID = ClientConstant.Default,
ShortDesc = "Shift Allowance",
LongDesc = "Shift Allowance",
IsDeMinimis = true,
IsTaxable = true,
IsReceivable = true,
IsEnabled = true,
TaskHandlerProviderID = TaskHandlerProviderConstants.DefaultEarning
});
builder.HasData(new Earning
{
EarningID = 5,
EarningTypeID = EarningTypeIDConstants.Allowance,
Code = EarningCodeConstants.RiceAllowance,
ClientID = ClientConstant.Default,
ShortDesc = "Rice Allowance",
LongDesc = "Rice Allowance",
IsReceivable = true,
IsEnabled = true,
TaskHandlerProviderID = TaskHandlerProviderConstants.DefaultEarning
});
builder.HasData(new Earning
{
EarningID = 6,
EarningTypeID = EarningTypeIDConstants.Allowance,
Code = EarningCodeConstants.ClothingAllowance,
ClientID = ClientConstant.Default,
ShortDesc = "Clothing Allowance",
LongDesc = "Clothing Allowance",
IsReceivable = true,
IsEnabled = true,
TaskHandlerProviderID = TaskHandlerProviderConstants.DefaultEarning
});
}
protected override void SeedData(BaseSeeder <TableRange> builder)
{
#region TaxTable
#region Daily
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 1,
AmountBasis = AmountBasis.Daily,
Min = 0.0000001m,
Max = 685,
Rate = 0,
Fixed = 0
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 2,
AmountBasis = AmountBasis.Daily,
Min = 685.000001m,
Max = 1095,
Rate = 0.2m,
Fixed = 0
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 3,
AmountBasis = AmountBasis.Daily,
Min = 685.000001m,
Max = 1095,
Rate = 0.2m,
Fixed = 0
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 4,
AmountBasis = AmountBasis.Daily,
Min = 685.000001m,
Max = 1095,
Rate = 0.2m,
Fixed = 0
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 5,
AmountBasis = AmountBasis.Daily,
Min = 685.000001m,
Max = 1095,
Rate = 0.2m,
Fixed = 0
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 6,
AmountBasis = AmountBasis.Daily,
Min = 685.000001m,
Max = 1095,
Rate = 0.2m,
Fixed = 0
});
#endregion
#region Weekly
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 7,
AmountBasis = AmountBasis.Weekly,
Min = 0.0000001m,
Max = 685,
Rate = 0,
Fixed = 0
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 8,
AmountBasis = AmountBasis.Weekly,
Min = 685.000001m,
Max = 1095,
Rate = 0.2m,
Fixed = 0
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 9,
AmountBasis = AmountBasis.Weekly,
Min = 685.000001m,
Max = 1095,
Rate = 0.2m,
Fixed = 0
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 10,
AmountBasis = AmountBasis.Weekly,
Min = 685.000001m,
Max = 1095,
Rate = 0.2m,
Fixed = 0
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 11,
AmountBasis = AmountBasis.Weekly,
Min = 685.000001m,
Max = 1095,
Rate = 0.2m,
Fixed = 0
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 12,
AmountBasis = AmountBasis.Weekly,
Min = 685.000001m,
Max = 1095,
Rate = 0.2m,
Fixed = 0
});
#endregion
#region Semi-Monthly
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 13,
AmountBasis = AmountBasis.SemiMontly,
Min = 0.0000001m,
Max = 685,
Rate = 0,
Fixed = 0
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 14,
AmountBasis = AmountBasis.SemiMontly,
Min = 685.000001m,
Max = 1095,
Rate = 0.2m,
Fixed = 0
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 15,
AmountBasis = AmountBasis.SemiMontly,
Min = 685.000001m,
Max = 1095,
Rate = 0.2m,
Fixed = 0
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 16,
AmountBasis = AmountBasis.SemiMontly,
Min = 685.000001m,
Max = 1095,
Rate = 0.2m,
Fixed = 0
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 17,
AmountBasis = AmountBasis.SemiMontly,
Min = 685.000001m,
Max = 1095,
Rate = 0.2m,
Fixed = 0
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 18,
AmountBasis = AmountBasis.SemiMontly,
Min = 685.000001m,
Max = 1095,
Rate = 0.2m,
Fixed = 0
});
#endregion
#region Monthly
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 19,
AmountBasis = AmountBasis.Monthly,
Min = 0.0000001m,
Max = 20833,
Rate = 0,
Fixed = 0
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 20,
AmountBasis = AmountBasis.Monthly,
Min = 20833.000001m,
Max = 33332,
Rate = 0.2m,
Fixed = 0
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 21,
AmountBasis = AmountBasis.Monthly,
Min = 33332.000001m,
Max = 66666,
Rate = 0.2m,
Fixed = 2500
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 22,
AmountBasis = AmountBasis.Monthly,
Min = 66667,
Max = 166666.9999999m,
Rate = 0.3m,
Fixed = 10833.33m
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 23,
AmountBasis = AmountBasis.Monthly,
Min = 166666m,
Max = 666666.999999m,
Rate = 0.32m,
Fixed = 40833.33m
});
builder.HasData(new TableRange
{
TableID = 1,
Code = TableCodeConstants.TaxTable,
TableRangeID = 24,
AmountBasis = AmountBasis.Monthly,
Min = 666667m,
Max = 999999999,
Rate = 0.35m,
Fixed = 200833.33m
});
#endregion
#endregion
#region PHIC 2020
builder.HasData(new TableRange
{
TableID = 2,
Code = TableCodeConstants.PhilHealth,
TableRangeID = 25,
AmountBasis = AmountBasis.Monthly,
Min = 0.0001m,
Max = 10000,
Fixed = 275,
EmployeeFormula = "{Fixed} / 2",
EmployerFormula = "{Fixed} / 2"
});
builder.HasData(new TableRange
{
TableID = 2,
Code = TableCodeConstants.PhilHealth,
TableRangeID = 26,
AmountBasis = AmountBasis.Monthly,
Min = 10000.01m,
Max = 59999.99m,
Rate = 0.03m,
EmployeeFormula = "({MonthlyBasicPay} * {Rate}) / 2",
EmployerFormula = "({MonthlyBasicPay} * {Rate}) / 2"
});
builder.HasData(new TableRange
{
TableID = 2,
Code = TableCodeConstants.PhilHealth,
TableRangeID = 27,
AmountBasis = AmountBasis.Monthly,
Min = 60000,
Max = 99999999.99m,
Fixed = 1800,
EmployeeFormula = "{Fixed} / 2",
EmployerFormula = "{Fixed} / 2"
});
#endregion
#region PHIC 2021
builder.HasData(new TableRange
{
TableID = 3,
Code = TableCodeConstants.PhilHealth,
TableRangeID = 28,
AmountBasis = AmountBasis.Monthly,
Min = 0.0001m,
Max = 10000,
Fixed = 350,
EmployeeFormula = "{Fixed} / 2",
EmployerFormula = "{Fixed} / 2"
});
builder.HasData(new TableRange
{
TableID = 3,
Code = TableCodeConstants.PhilHealth,
TableRangeID = 29,
AmountBasis = AmountBasis.Monthly,
Min = 10000.01m,
Max = 69999.99m,
Rate = 0.035m,
EmployeeFormula = "({MonthlyBasicPay} * {Rate}) / 2",
EmployerFormula = "({MonthlyBasicPay} * {Rate}) / 2"
});
builder.HasData(new TableRange
{
TableID = 3,
Code = TableCodeConstants.PhilHealth,
TableRangeID = 30,
AmountBasis = AmountBasis.Monthly,
Min = 70000,
Max = 99999999.99m,
Fixed = 2450,
EmployeeFormula = "{Fixed} / 2",
EmployerFormula = "{Fixed} / 2"
});
#endregion
#region SSS 2021
builder.HasData(new TableRange
{
TableID = 4,
Code = TableCodeConstants.SSS,
TableRangeID = 31,
AmountBasis = AmountBasis.Monthly,
Min = 0.0001m,
Max = 3250,
Fixed = 3000,
EmployeeFormula = "135.00",
EmployerFormula = "255.00"
});
builder.HasData(new TableRange
{
TableID = 4,
Code = TableCodeConstants.SSS,
TableRangeID = 32,
AmountBasis = AmountBasis.Monthly,
Min = 24750m,
Max = 9999999999m,
Fixed = 20000,
EmployeeFormula = "1700.00",
EmployerFormula = "900.00"
});
#endregion
}
protected override void SeedData(BaseSeeder <TaskHandlerProvider> builder)
{
builder.HasData(new TaskHandlerProvider
{
ID = TaskHandlerProviderConstants.BasicPay,
TaskAssembly = typeof(CalcBasicPayCmd).Assembly.FullName,
TaskClass = typeof(CalcBasicPayCmd).FullName
});
builder.HasData(new TaskHandlerProvider
{
ID = TaskHandlerProviderConstants.DefaultEarning,
TaskAssembly = typeof(CalcEmployeeEarningCmd).Assembly.FullName,
TaskClass = typeof(CalcEmployeeEarningCmd).FullName
});
builder.HasData(new TaskHandlerProvider
{
ID = TaskHandlerProviderConstants.CashAdvanceDeduction,
TaskAssembly = typeof(CashAdvanceDeductionCmd).Assembly.FullName,
TaskClass = typeof(CashAdvanceDeductionCmd).FullName
});
builder.HasData(new TaskHandlerProvider
{
ID = TaskHandlerProviderConstants.OtherDeduction,
TaskAssembly = typeof(OtherDeductionCmd).Assembly.FullName,
TaskClass = typeof(OtherDeductionCmd).FullName
});
builder.HasData(new TaskHandlerProvider
{
ID = TaskHandlerProviderConstants.ContributionDeductionSSS,
TaskAssembly = typeof(ContributionDeductionCmd).Assembly.FullName,
TaskClass = typeof(ContributionDeductionCmd).FullName,
HandlerAssembly = typeof(SSSContributionDeductionCmdHandler).Assembly.FullName,
HandlerClass = typeof(SSSContributionDeductionCmdHandler).FullName
});
builder.HasData(new TaskHandlerProvider
{
ID = TaskHandlerProviderConstants.ContributionDeductionPagIBIG,
TaskAssembly = typeof(ContributionDeductionCmd).Assembly.FullName,
TaskClass = typeof(ContributionDeductionCmd).FullName,
HandlerAssembly = typeof(PagIBIGContributionDeductionCmdHandler).Assembly.FullName,
HandlerClass = typeof(PagIBIGContributionDeductionCmdHandler).FullName
});
builder.HasData(new TaskHandlerProvider
{
ID = TaskHandlerProviderConstants.ContributionDeductionPhilHealth,
TaskAssembly = typeof(ContributionDeductionCmd).Assembly.FullName,
TaskClass = typeof(ContributionDeductionCmd).FullName,
HandlerAssembly = typeof(PhilHealthContributionDeductionCmdHandler).Assembly.FullName,
HandlerClass = typeof(PhilHealthContributionDeductionCmdHandler).FullName
});
builder.HasData(new TaskHandlerProvider
{
ID = TaskHandlerProviderConstants.MainCalc,
TaskAssembly = typeof(MainCalcCmd).Assembly.FullName,
TaskClass = typeof(MainCalcCmd).FullName
});
builder.HasData(new TaskHandlerProvider
{
ID = TaskHandlerProviderConstants.RollbackCalc,
TaskAssembly = typeof(RollbackEmployeeCmd).Assembly.FullName,
TaskClass = typeof(RollbackEmployeeCmd).FullName
});
builder.HasData(new TaskHandlerProvider
{
ID = TaskHandlerProviderConstants.ImportPerson,
TaskAssembly = typeof(ImportPersonCmd).Assembly.FullName,
TaskClass = typeof(ImportPersonCmd).FullName
});
builder.HasData(new TaskHandlerProvider
{
ID = TaskHandlerProviderConstants.ImportBasicPay,
TaskAssembly = typeof(ImportBasicPayCmd).Assembly.FullName,
TaskClass = typeof(ImportBasicPayCmd).FullName
});
builder.HasData(new TaskHandlerProvider
{
ID = TaskHandlerProviderConstants.HMOPremiumPayableLoan,
TaskAssembly = typeof(HMOPremiumPayableLoanCmd).Assembly.FullName,
TaskClass = typeof(HMOPremiumPayableLoanCmd).FullName
});
}
protected override void SeedData(BaseSeeder <Deduction> builder)
{
builder.HasData(new Deduction
{
ClientID = ClientConstant.Default,
Code = DeductionCodeConstants.CashAdvance,
DeductionID = 1,
DeductionTypeID = 1,
ShortDesc = "Cash Advance",
LongDesc = "Cash Advance",
IsEnabled = false,
IsExcludedInTax = false,
TaskHandlerProviderID = TaskHandlerProviderConstants.CashAdvanceDeduction
});
builder.HasData(new Deduction
{
ClientID = ClientConstant.Default,
Code = DeductionCodeConstants.SSS,
DeductionID = 2,
DeductionTypeID = 2,
ShortDesc = "SSS Contribution",
LongDesc = "SSS Contribution",
IsEnabled = true,
IsExcludedInTax = true,
TaskHandlerProviderID = TaskHandlerProviderConstants.ContributionDeductionSSS
});
builder.HasData(new Deduction
{
ClientID = ClientConstant.Default,
Code = DeductionCodeConstants.PagIBIG,
DeductionID = 3,
DeductionTypeID = 2,
ShortDesc = "Pag-IBIG Contribution",
LongDesc = "Pag-IBIG Contribution",
IsEnabled = true,
IsExcludedInTax = true,
TaskHandlerProviderID = TaskHandlerProviderConstants.ContributionDeductionPagIBIG
});
builder.HasData(new Deduction
{
ClientID = ClientConstant.Default,
Code = DeductionCodeConstants.PhilHealth,
DeductionID = 4,
DeductionTypeID = 2,
ShortDesc = "PhilHealth Contribution",
LongDesc = "PhilHealth Contribution",
IsEnabled = true,
IsExcludedInTax = true,
TaskHandlerProviderID = TaskHandlerProviderConstants.ContributionDeductionPhilHealth
});
builder.HasData(new Deduction
{
ClientID = ClientConstant.Default,
Code = DeductionCodeConstants.Others,
DeductionID = 9,
DeductionTypeID = 1,
ShortDesc = "Others",
LongDesc = "Others",
IsEnabled = true,
IsExcludedInTax = true,
TaskHandlerProviderID = TaskHandlerProviderConstants.OtherDeduction
});
}
protected override void SeedData(BaseSeeder <Period> builder)
{
builder.HasData(new Period {
PeriodID = 1, PaymentModeID = 2, ShortDesc = "First Payroll", LongDesc = "First Payroll", Order = 1, IsEveryPayroll = false, IsNeedPayoutPlace = false
});
builder.HasData(new Period {
PeriodID = 2, PaymentModeID = 2, ShortDesc = "Third Payroll", LongDesc = "Third Payroll", Order = 3, IsEveryPayroll = false, IsNeedPayoutPlace = false
});
builder.HasData(new Period {
PeriodID = 3, PaymentModeID = 2, ShortDesc = "Every Payroll", LongDesc = "Every Payroll", Order = 4, IsEveryPayroll = true, IsNeedPayoutPlace = false
});
builder.HasData(new Period {
PeriodID = 4, PaymentModeID = 2, ShortDesc = "Second Payroll", LongDesc = "Second Payroll", Order = 2, IsEveryPayroll = false, IsNeedPayoutPlace = false
});
builder.HasData(new Period {
PeriodID = 5, PaymentModeID = 5, ShortDesc = "Every Payroll", LongDesc = "Every Payroll", Order = 1, IsEveryPayroll = true, IsNeedPayoutPlace = false
});
builder.HasData(new Period {
PeriodID = 6, PaymentModeID = 4, ShortDesc = "Every Payroll", LongDesc = "Every Payroll", Order = 1, IsEveryPayroll = true, IsNeedPayoutPlace = false
});
builder.HasData(new Period {
PeriodID = 7, PaymentModeID = 3, ShortDesc = "Every Payroll", LongDesc = "Every Payroll", Order = 3, IsEveryPayroll = true, IsNeedPayoutPlace = false
});
builder.HasData(new Period {
PeriodID = 8, PaymentModeID = 3, ShortDesc = "First Half", LongDesc = "First Half", Order = 1, IsEveryPayroll = false, IsNeedPayoutPlace = false
});
builder.HasData(new Period {
PeriodID = 9, PaymentModeID = 3, ShortDesc = "Second Half", LongDesc = "Second Half", Order = 2, IsEveryPayroll = false, IsNeedPayoutPlace = false
});
builder.HasData(new Period {
PeriodID = 10, PaymentModeID = 1, ShortDesc = "Fourth Week", LongDesc = "Fourth Week", Order = 4, IsEveryPayroll = false, IsNeedPayoutPlace = false
});
builder.HasData(new Period {
PeriodID = 11, PaymentModeID = 1, ShortDesc = "Fifth Week", LongDesc = "Fifth Week", Order = 5, IsEveryPayroll = false, IsNeedPayoutPlace = false
});
builder.HasData(new Period {
PeriodID = 12, PaymentModeID = 1, ShortDesc = "Second Week", LongDesc = "Second Week", Order = 2, IsEveryPayroll = false, IsNeedPayoutPlace = false
});
builder.HasData(new Period {
PeriodID = 13, PaymentModeID = 1, ShortDesc = "Every Payroll", LongDesc = "Every Payroll", Order = 6, IsEveryPayroll = true, IsNeedPayoutPlace = false
});
builder.HasData(new Period {
PeriodID = 14, PaymentModeID = 1, ShortDesc = "Third Week", LongDesc = "Third Week", Order = 3, IsEveryPayroll = false, IsNeedPayoutPlace = false
});
builder.HasData(new Period {
PeriodID = 15, PaymentModeID = 1, ShortDesc = "First Week", LongDesc = "First Week", Order = 1, IsEveryPayroll = false, IsNeedPayoutPlace = false
});
builder.HasData(new Period {
PeriodID = 16, PaymentModeID = 6, ShortDesc = "January", LongDesc = "January", Order = 0, IsEveryPayroll = false, IsNeedPayoutPlace = true
});
builder.HasData(new Period {
PeriodID = 17, PaymentModeID = 6, ShortDesc = "February", LongDesc = "February", Order = 0, IsEveryPayroll = false, IsNeedPayoutPlace = true
});
builder.HasData(new Period {
PeriodID = 18, PaymentModeID = 6, ShortDesc = "March", LongDesc = "March", Order = 0, IsEveryPayroll = false, IsNeedPayoutPlace = true
});
builder.HasData(new Period {
PeriodID = 19, PaymentModeID = 6, ShortDesc = "April", LongDesc = "April", Order = 0, IsEveryPayroll = false, IsNeedPayoutPlace = true
});
builder.HasData(new Period {
PeriodID = 20, PaymentModeID = 6, ShortDesc = "May", LongDesc = "May", Order = 0, IsEveryPayroll = false, IsNeedPayoutPlace = true
});
builder.HasData(new Period {
PeriodID = 21, PaymentModeID = 6, ShortDesc = "June", LongDesc = "June", Order = 0, IsEveryPayroll = false, IsNeedPayoutPlace = true
});
builder.HasData(new Period {
PeriodID = 22, PaymentModeID = 6, ShortDesc = "July", LongDesc = "July", Order = 0, IsEveryPayroll = false, IsNeedPayoutPlace = true
});
builder.HasData(new Period {
PeriodID = 23, PaymentModeID = 6, ShortDesc = "August", LongDesc = "August", Order = 0, IsEveryPayroll = false, IsNeedPayoutPlace = true
});
builder.HasData(new Period {
PeriodID = 24, PaymentModeID = 6, ShortDesc = "September", LongDesc = "September", Order = 0, IsEveryPayroll = false, IsNeedPayoutPlace = true
});
builder.HasData(new Period {
PeriodID = 25, PaymentModeID = 6, ShortDesc = "October", LongDesc = "October", Order = 0, IsEveryPayroll = false, IsNeedPayoutPlace = true
});
builder.HasData(new Period {
PeriodID = 26, PaymentModeID = 6, ShortDesc = "November", LongDesc = "November", Order = 0, IsEveryPayroll = false, IsNeedPayoutPlace = true
});
builder.HasData(new Period {
PeriodID = 27, PaymentModeID = 6, ShortDesc = "December", LongDesc = "December", Order = 0, IsEveryPayroll = false, IsNeedPayoutPlace = true
});
}
protected override void SeedData(BaseSeeder <JobParameter> builder)
{
builder.HasData(new JobParameter
{
ClientID = ClientConstant.Default,
JobID = MainConstants.Job.MainCalc,
Name = "PlanYear",
Display = "Plan Year",
DefaultValue = "2021",
DataType = InputDataTypeConstants.SmallInt,
IsRequired = true,
Order = 1
});
builder.HasData(new JobParameter
{
ClientID = ClientConstant.Default,
JobID = MainConstants.Job.MainCalc,
Name = "PayRunID",
Display = "Pay Run ID",
DefaultValue = "1",
DataType = InputDataTypeConstants.SmallInt,
IsRequired = true,
Order = 2
});
builder.HasData(new JobParameter
{
ClientID = ClientConstant.Default,
JobID = MainConstants.Job.MainCalc,
Name = "PersonID",
Display = "Person ID",
DefaultValue = null,
DataType = InputDataTypeConstants.Int,
IsRequired = false,
Order = 3
});
builder.HasData(new JobParameter
{
ClientID = ClientConstant.Default,
JobID = MainConstants.Job.MainCalc,
Name = "SpecialGroupID",
Display = "Special Group ID",
DefaultValue = null,
DataType = InputDataTypeConstants.Int,
Order = 100
});
builder.HasData(new JobParameter
{
ClientID = ClientConstant.Default,
JobID = 404,
Name = "EmployeeID",
Display = "Employee ID",
DataType = InputDataTypeConstants.Int,
IsRequired = true
});
builder.HasData(new JobParameter
{
ClientID = ClientConstant.Default,
JobID = MainConstants.Job.ImportPerson,
Name = "Path",
Display = "File Path",
DataType = InputDataTypeConstants.String,
IsRequired = true,
DefaultValue = @"D:\Git Workspace\Personal\Aerish\Docs\Sample Imports\PERSON_05_03_2021.csv"
});
builder.HasData(new JobParameter
{
ClientID = ClientConstant.Default,
JobID = MainConstants.Job.ImportBasicPay,
Name = "Path",
Display = "File Path",
DataType = InputDataTypeConstants.String,
IsRequired = true,
DefaultValue = @"D:\Git Workspace\Personal\Aerish\Docs\Sample Imports\BASICPAY_05_03_2021.csv"
});
}