protected override void ConfigureRelationship(BaseRelationshipBuilder <Author> builder)
{
builder.HasOne(a => a.User)
.WithOne(a => a.Author)
.HasForeignKey <Author>("ID")
.OnDelete(Microsoft.EntityFrameworkCore.DeleteBehavior.NoAction);
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <MasterEmployeeEarning> builder)
{
builder.HasOne <MasterEmployee>()
.WithMany(a => a.N_MasterEmployeeEarnings)
.HasForeignKey(a => new
{
a.EmployeeID,
a.ClientID,
a.CalcID,
a.PlanYear,
a.PayRunID
})
.OnDelete(DeleteBehavior.Cascade);
builder.HasOne(a => a.N_PayRun)
.WithMany()
.HasForeignKey(a => new
{
a.ClientID,
a.PayRunID,
a.PlanYear
})
.OnDelete(DeleteBehavior.NoAction);
builder.HasOne(a => a.N_Earning)
.WithMany()
.HasForeignKey(a => a.EarningID);
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <EmployeeEarning> builder)
{
builder.HasOne <PayRun>()
.WithMany()
.HasForeignKey(a => new
{
a.ClientID,
a.PayRunID,
a.PlanYear
})
.OnDelete(DeleteBehavior.NoAction);
builder.HasOne <Earning>()
.WithMany()
.HasForeignKey(a => a.EarningID)
.OnDelete(DeleteBehavior.NoAction);
builder.HasOne <EmployeeEarningRef>()
.WithMany(a => a.N_EmployeeEarnings)
.HasForeignKey(a => new
{
a.ClientID,
a.EmployeeEarningRefID,
a.EmployeeID,
a.EarningID
});
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <Loan> builder)
{
builder.HasOne(a => a.N_LoanType)
.WithMany()
.HasForeignKey(a => a.LoanTypeID);
builder.HasOne(a => a.N_TaskHandlerProvider)
.WithMany()
.HasForeignKey(a => a.TaskHandlerProviderID);
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <PayRun> builder)
{
builder.HasOne(a => a.N_PlanYear)
.WithMany()
.HasForeignKey(a => a.PlanYear);
builder.HasOne <Client>()
.WithMany()
.HasForeignKey(a => a.ClientID);
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <JobParameter> builder)
{
builder.HasOne <Job>()
.WithMany(a => a.N_JobParameters)
.HasForeignKey(a => new
{
a.ClientID,
a.JobID
});
}
public override void ConfigureRelationship(BaseRelationshipBuilder <HeroSkill> builder)
{
builder.HasOne(a => a.Hero)
.WithMany(a => a.Skills)
.HasForeignKey("HeroID");
builder.HasOne(a => a.Skill)
.WithMany()
.HasForeignKey("SkillID");
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <Employee> builder)
{
builder.HasOne(a => a.N_Person)
.WithMany()
.HasForeignKey(a => a.EmployeeID);
builder.HasOne(a => a.N_Client)
.WithMany()
.HasForeignKey(a => a.ClientID);
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <ProcessInstance> builder)
{
builder.HasOne(a => a.N_Job)
.WithMany()
.HasForeignKey(a => new
{
a.ClientID,
a.JobID
});
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <TableRange> builder)
{
builder.HasOne <Table>()
.WithMany(a => a.N_Ranges)
.HasForeignKey(a => new
{
a.TableID,
a.Code
});
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <EmailExtract> builder)
{
builder.HasOne <Email>()
.WithMany(a => a.N_Extracts)
.HasForeignKey(a => a.EmailID);
builder.HasOne <EmailWorker>()
.WithMany()
.HasForeignKey(a => a.EmailWorkerID);
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <BillProvider> builder)
{
builder.HasOne <Bill>()
.WithMany(a => a.N_BillProviders)
.HasForeignKey(a => a.BillID);
builder.HasOne(a => a.N_ProviderType)
.WithMany()
.HasForeignKey(a => a.ProviderTypeID);
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <TrackBillSetting> builder)
{
builder.HasOne <TrackBill>()
.WithMany(a => a.N_TrackBillSettings)
.HasForeignKey(a => new
{
a.TrackBillID,
a.UserID
});
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <UserBill> builder)
{
builder.HasOne(a => a.N_TrackBill)
.WithMany(a => a.N_UserBills)
.HasForeignKey(a => new
{
a.TrackBillID,
a.UserID
});
builder.HasOne(a => a.N_User)
.WithMany()
.HasForeignKey(a => a.UserID)
.OnDelete(DeleteBehavior.NoAction);
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <EmployeeDeductionRef> builder)
{
builder.HasOne(a => a.N_Deduction)
.WithMany()
.HasForeignKey(a => a.DeductionID)
.OnDelete(DeleteBehavior.NoAction);
builder.HasOne(a => a.N_Employee)
.WithMany()
.HasForeignKey(a => new
{
a.EmployeeID,
a.ClientID
});
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <ProviderTypeConfigEmail> builder)
{
builder.HasOne <TrackBill>()
.WithOne(a => a.N_ProviderTypeConfigEmail)
.HasForeignKey <ProviderTypeConfigEmail>(a => new
{
a.ID,
a.UserID
});
builder.HasOne <User>()
.WithMany()
.HasForeignKey(a => a.UserID)
.OnDelete(DeleteBehavior.NoAction);
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <EmployeeOvertime> builder)
{
builder.HasOne(a => a.N_OTRate)
.WithMany()
.HasForeignKey(a => a.OTRateID);
builder.HasOne(a => a.N_PayRun)
.WithMany()
.HasForeignKey(a => new
{
a.ClientID,
a.PayRunID,
a.PlanYear
})
.OnDelete(DeleteBehavior.NoAction);
builder.HasOne(a => a.N_Employee)
.WithMany()
.HasForeignKey(a => new
{
a.EmployeeID,
a.ClientID
});
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <SchedulerEntry> builder)
{
builder.HasOne <ProviderTypeConfigScheduler>()
.WithMany(a => a.N_ScheduleEntries)
.HasForeignKey(a => a.TrackBillSchedulerID);
}
protected virtual void ConfigureRelationship(BaseRelationshipBuilder <T> builder)
{
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <Period> builder)
{
builder.HasOne(a => a.N_PaymentMode)
.WithMany()
.HasForeignKey(a => a.PaymentModeID);
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <UserSession> builder)
{
builder.HasOne(a => a.User)
.WithMany()
.HasForeignKey(a => a.UserID);
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <FirebaseToken> builder)
{
builder.HasOne <User>()
.WithMany()
.HasForeignKey(a => a.UserID);
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <BillSetting> builder)
{
builder.HasOne <Bill>()
.WithMany(a => a.N_BillSettings)
.HasForeignKey(a => a.BillID);
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <EmailWorker> builder)
{
builder.HasOne <BillProvider>()
.WithOne(a => a.N_EmailWorker)
.HasForeignKey <EmailWorker>(a => a.ID);
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <StagingPerson> builder)
{
builder.HasOne(a => a.N_JobInstance)
.WithMany()
.HasForeignKey(a => a.ProcessInstanceID);
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <UserLogin> builder)
{
builder.HasOne(a => a.User)
.WithOne(a => a.UserLogin)
.HasForeignKey <UserLogin>(a => a.ID);
}
public virtual void ConfigureRelationship(BaseRelationshipBuilder <T> builder)
{
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <EmailBody> builder)
{
builder.HasOne(a => a.N_Email)
.WithOne(a => a.N_Body)
.HasForeignKey <EmailBody>(a => a.ID);
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <EmailPart> builder)
{
builder.HasOne <Email>()
.WithMany(a => a.N_Headers)
.HasForeignKey(a => a.EmailID);
}
protected override void ConfigureRelationship(BaseRelationshipBuilder <BillPaymentStepsTemplate> builder)
{
builder.HasOne <Bill>()
.WithMany(a => a.N_PaymentStepsTemplates)
.HasForeignKey(a => a.BillID);
}
