cgvak.ar360.tenentdb.entity 1.0.97

CGVAK.AR360.TenentDB

Tenant Database is used to store tenant related information and thier space.

Version History

Version No: 1.0.97

Date: 3/Sep/2025

Version History

Version No: 1.0.97

Date: 3/Sep/2025

• Added columns in tempCustomers table.
• Migrations has been created.

Version No: 1.0.96

Date: 29/Aug/2025

• Added ValidUpto Column in CadenceNewCustomer.

Version No: 1.0.96

Date: 25/Aug/2025

• Added CadenceNewCustomer for Track new customer from Qb.
• Create Cadence for new Customer once the cadence configuration has been created.

Version No: 1.0.95

Date: 23/Jul/2025

• Migration log modified & database name added to the log.

Version No: 1.0.93

Date: 22/July/2025

• Added VoucherNo Column in TempCustomerInvoice,TempPayment,CustomerInvoice and Payment tables.
• Added Migration 20250722111417_TallyVoucherNoMigration.cs

Version No: 1.0.92

Date: 18/June/2025

• Updated 20250616060530_CadenceMailAlterMigration.cs

Version No: 1.0.91

Date: 16/June/2025

• Migration created

Version No: 1.0.90

Date: 12/June/2025

• Added CallTenantAuthInfo table in PartialEntities.cs

Version No: 1.0.89

Date: 06/June/2025

• Altered columns in CadenceTransactionDetail,CadenceStepConfiguration and CadenceCombinedTransactionDetail tables.

Version No: 1.0.88

Date: 06/May/2025

• Added CallTenantAuthInfo table and added and modified columns in CallRecord and CallTranscribeRecords tables.

Version No: 1.0.87

Date: 25/Apr/2025

• Migration created

Version No: 1.0.87

Date: 23/Apr/2025

• Added columns in Customer and CustomerContactDetails tables.

Version No: 1.0.86

Date: 17/Apr/2025

• Migration added for combined cadence table.

Version No: 1.0.84

Date: 17/April/2025

• Added a column CadenceCombinedTransactionDetail table.

Version No: 1.0.83

Date: 16/April/2025

• Created CadenceCombinedTransactionDetail table.

Version No: 1.0.82

Date: 1/April/2025

• Created Application_Comments Table and added 1 column in CadenceTransactionDetail table.
• Added some columns in MailAuthInfo for Other Mail Info.

Version No: 1.0.81

Date: 28/Mar/2025

• Added 8 Columns in CadenceCustomerConfiguration Table

Version No: 1.0.80

Date: 27/Mar/2025

• Added TemplateName Column in CallTextFollowupTemplate Table

Version No: 1.0.79

Date: 25/Mar/2025

• Alter column Content & Subject in CadenceTransactionDetail.
• Nuget has been created for this version.

Version No: 1.0.78

Date: 10/Mar/2025

• Adjustment Columns has been added to temp_CustomerInvoice & CustomerInvoice Tables.
• Migration has been created.
• Nuget package has been created.

Version No: 1.0.77

Date: 12/Feb/2025

• temp Payment wrongly referencing customer id column.
• Nuget created for this version.

Version No: 1.0.76

Date: 12/Feb/2025

• Removing constraint for Payment table alone.
• Nuget package been created.

Version No: 1.0.75

Date: 12/Feb/2025

• Droping the Unique contraint for addressing the tally issue.
• Created a Unique Contraint for customer invoice combination of domain, qbid.
• Created a Unique Contraint for customer & payment combination of domain, qbid as well.
• Nuget package been created.

Version No: 1.0.74

Date: 6/Feb/2025

• Added IsMoved Column in TempCustomerInvoice,TempCustomerInvoiceLineItem,TempPayment,TempCustomers tables.
• Nuget has been created.

Version No: 1.0.73

Date: 05/Feb/2025

• Nuget package has not been created.
• TallyConfiguration Table has been added.
• Migration has been created.

Version No: 1.0.73

Date: 03/Feb/2025

• Nuget package has not been created.
• Migration added for Tally Temp Migration.
• Migration needs to added for Temp Payment Migration.

Version No: 1.0.73

Date: 31/Jan/2025

• TempCustomerInvoice,TempCustomerInvoiceLineItem,TempPayment,TempCustomers tables added.

Version No: 1.0.72

Date: 08/Jan/2025

• ClientRiskRating Table has been added.

Version No: 1.0.71

Date: 07/Jan/2025

• ClientRiskPoints Table has been added.

Version No: 1.0.71

Date: 02/Jan/2025

• Added SalesdataMontlywise & SalesdataQuaterlywise Tables.
• Nuget package not created for this version.

Version No: 1.0.70

Date: 11/Dec/2024

• Added ReportType and IsMarked Column in AgeingReportSettings Table.
• Nuget has been created

Version No: 1.0.69

Date: 05/Dec/2024

• Nuget has been created
• MIgration has added.

Version No: 1.0.69

Date: 18/Nov/2024

• Added ReportStoreFile table.
• Migration not created
• Nuget not created

Version No: 1.0.68

Date: 15/Nov/2024

• Added Migration.
• Nuget has been created for this version.

Version No: 1.0.67

Date: 15/Nov/2024

• Nuget created for this version

Version No: 1.0.66

Date: 30/Oct/2024

• Added Migration to truncate the customer_invoice_wise_aging_report table.

Version No: 1.0.65

Date: 25/Oct/2024

• Added a table to store Customer Invoice wise Aging report.
• Create Migration '20241025120002_AgingReportMigration1'.

Version No: 1.0.64

Date: 24/Oct/2024

• Nuget has been created for this version.
• Migration Added '20241024061231_AgingReportMigration'.
• Scaffolded to access AgeingReport related tables.

Version No: 1.0.63

Date: 23/Oct/2024

• Added CustomerId Column in CallRecord Table.
• Nuget has been created for this version.
• Added OverallAgingReport & CustomerWiseAgingReportTable table.
• Nuget not created for this version.

Version No: 1.0.62

Date: 18/Oct/2024

• Added 4 columns in MailScheduleSend Table.

Version No: 1.0.61

Date: 17/Oct/2024

• Changes in package registration

Version No: 1.0.60

Date: 16/Oct/2024

• Made a TenantDbContext as Common Method and Added LifeTime Parameter to control the context lifetime.

Version No: 1.0.59

Date: 16/Oct/2024

• Changes in the registration method, wrong if condition corrected.
• AuditLogInterceptor Getting by GetRequiredService, earlier it was GetService.

Version No: 1.0.58

Date: 16/Oct/2024

• Registeration Changes TenantContextFactory from Scope to Singleton.
• add additional check points to treat the instance.

Version No: 1.0.57

Date: 14/Oct/2024

• Added Empty constructor to run migration.
• Added few objects in partial entities that was missed previously.
• package dbbase has updated from 1.0.5 to 1.0.6

Version No: 1.0.56

Date: 11/Oct/2024

• Models has been recreated.
• Nuget has been created for this version.

Version No: 1.0.55

Date: 11/Oct/2024

• Created Migration '20241011084826_CadenceRestructureMigration'
• Nuget has been created for this version.

Version No: 1.0.53

Date: 07/Oct/2024

• Package dbbase has been updated from 1.0.4 to 1.0.5.

Version No: 1.0.52

Date: 04/Oct/2024

• Reference has been removed and relevant packages are updated.
• Added AuditLogInterceptor in scoped.
• Movied AuditLogInterceptor implementation to dbbase package.

Version No: 1.0.51-temp

Date: 03/Oct/2024

• Overrided Saved Changes & Saving Changes to store the data while saving in audit trail logs.

Version No: 1.0.51-temp

Date: 01/Oct/2024

• Made some changes in the AuditLogInterceptor.

Version No: 1.0.51-temp

Date: 30/Sep/2024

• Added Auditable log functionality.
• Nuget not created for this version.

Version No: 1.0.51

Date: 30/Sep/2024

• Removed some code from TenantDBContextConfiguration.

Version No: 1.0.49

Date: 30/Sep/2024

• Migration Created '20240930074103_ScheduleMailSendMigration2';
• Added TenantDbContextConfiguration to create Migration Locally, not depending other projects.

Version No: 1.0.48

Date: 26/Sep/2024

• Added ImportanceLevel in MailScheduleSend Table.

Version No: 1.0.47

Date: 25/Sep/2024

• Added MailScheduleSend and MailScheduleSendAttachments Table.

Version No: 1.0.46

Date: 12/Sep/2024

• Common interceptors and other common codes are moved to cgvak.common.dbbase.
• Added cgvak.common.dbbase new package.
• Removed the TenantStore since it is showing some issues.

Version No: 1.0.45

Date: 05/Sep/2024

• Cadence InvoiceValue column issue while applying the migration has been fixed.
• Nuget has been created for this version.

Version No: 1.0.44

Date: 04/Sep/2024

• Added Migration '20240904143923_CadenceMigration'.
• Cadence related modification has been scaffolded.

Version No: 1.0.43

Date: 04/Sep/2024

• Added Migration 'QbSyncMigration'

Version No: 1.0.42

Date: 30/Aug/2024

• Added Interceptor for updating default columns.
• Added package.json for run npm commands to scaffold.

Version No: 1.0.41

Date: 30/Aug/2024

• Added QbSyncStatus table to log qb running time.

Version No: 1.0.40

Date: 14/Aug/2024

• Delete all previous migrations and added new migration 'Initial'

Version No: 1.0.39

Date: 13/Aug/2024

• Pallavi changes.

Version No: 1.0.38

Date: 05/Aug/2024

• Added 'Migration14'.

Version No: 1.0.37

Date: 02/Aug/2024

• Removed IsActive Column in CadenceTransactionDetail.

Version No: 1.0.37

Date: 01/Aug/2024

• Changes in CadenceTransactionDetail table.
• Nuget package not created for this version.

Version No: 1.0.36

Date: 29/Jul/2024

• Added Status in Payment Table.
• Moved QbTenantAuthInfo to TenantDb from AppDb

Version No: 1.0.35

Date: 26/Jul/2024

• Added CadenceInvoiceConfiguration table.
• Nuget package not created for this version.

Version No: 1.0.34

Date: 11/Jul/2024

• Pallavi Changes & Added Migration12.

Version No: 1.0.32

Date: 28/Jun/2024

• Added Migration11.

Version No: 1.0.31

Date: 25/Jun/2024

• Added CadenceHeader, CadenceStep, CadenceStepConfiguration for Pallavi & Arun.
• Nuget package not created for this version.

Version No: 1.0.30

Date: 25/Jun/2024

• Added Migration10. (Christy changes)
• Added IsDefaut in MailFollowupTemplate (Chirsty Changes)

Version No: 1.0.29

Date: 24/Jun/2024

• Added CallTextFollowup
• Renames MailTextTemplate to MailFollowupTemplate
• Added Migration9.

Version No: 1.0.27

Date: 18/Jun/2024

• Added CustomerKycDetails Table
• Added CustomerFinancialInfo Table

Version No: 1.0.26

Date: 07/Jun/2024

• Added AttachmentRecord Table.
• Added ThumbnailAttachmentUID in InvoiceTemplateConfiguration.
• Added New Migration 'Migration7'.

Version No: 1.0.25

Date: 31/May/2024

• Factory changes.

Version No: 1.0.24

Date: 23/May/2024

• Added State Column in Address Table.
• Added New Migration 'Migration6'.

Version No: 1.0.23

Date: 14/May/2024

• Added Thumbnail in InvoiceTemplateConfiguration.
• Added New Migration 'Migration5'.

Version No: 1.0.22

Date: 10/May/2024

• Added PredefinedId in InvoiceTemplateConfiguration Table to identify the predefined invoice template.
• Added New Migration 'Migration4'.

Version No: 1.0.21

Date: 09/May/2024

• Added Models to PartialEntities
• Added New Migration 'Migration3'.
• Added New Table 'CustomerUserMapping' for Pinning Client to User.

Version No: 1.0.20

Date: 08/May/2024

• New Migrations created.

Version No: 1.0.19

Date: 07/May/2024

• Added MailTextTemplate Table
• Added EMail and CCMail Columns in CustomerContactDetails Table.
• Added IsPinned Column in CustomerInvoice Table.

Version No: 1.0.18

Date: 25/Apr/2024

• Added UserPreferences Table.

Version No: 1.0.17

Date: 22/Apr/2024

• Added configuration code in TenantDBConfiguration

Version No: 1.0.16

Date: 19/Apr/2024

• Migrations added

Version No: 1.0.15

Date: 04/Apr/2024

• Payments table added.

Version No: 1.0.14

Date: 27/Mar/2024

• Combined Predefined and Customer Invoice Template into a Single Table.
• Added Invoice Configuration to store Pattern details.

Version No: 1.0.13

Date: 22/Mar/2024

• Added Status Column in CustomerInvoice Table for keep active or void status.

Version No: 1.0.12

Date: 21/Mar/2024

• Added Query Field in Address field to implement query search in address.

Version No: 1.0.11

Date: 20/Mar/2024

• Added CustomerInvoiceTemplate Table.

Version No: 1.0.10

Date: 15/Mar/2024

• Converted TenantContextFactory Each Instance as a singleton.

Version No: 1.0.9

Date: 13/Mar/2024

• Added Customer Invoice and Customer Invoice LineItem Details Tables.

Version No: 1.0.8

Date: 12/Mar/2024

• Modified TenantContextFactory constructor to accept only connectionstring as a parameter.

Version No: 1.0.7

Date: 07/Mar/2024

• Added Term Table
• Added Customer Table
• Added Customer Contact Details Table
• Added Customer Invoice Table
• Added Windows Service Log Table

Version No: 1.0.5

Date: 05/Mar/2024

• Added EntityBase Interface for exclude the solft deleted records globally.
• Partial Entities to inherit the base type of Entity Base.
• Added Windows Service Log for Tenant QB Data Pulling Activities.
• Modified the tables based on the Address and Company Tables.

Version No: 1.0.4

Date: 21/Feb/2024

• Some tables were removed from here and scaffolded.

Version No: 1.0.3.5

Date: 20/Feb/2024

• Initial Files Updated.