public UnitOfWork()
{
try
{
// var serviceCollection = new ServiceCollection();
// IServiceProvider serviceProvider = serviceCollection.BuildServiceProvider();
// this._db = serviceProvider.GetRequiredService<ListensoftwaredbContext>();
this._db = new ListensoftwaredbContext();
}
catch (Exception ex) { throw new Exception("UnitOfWork", ex); }
}
public async Task <Udc> GetUdc2(string productCode, string keyCode)
{
try
{
ListensoftwaredbContext _dbListensoftwaredbContext = (ListensoftwaredbContext)_dbContext;
Udc udc = await(from e in _dbListensoftwaredbContext.Udc
where e.ProductCode == productCode &&
e.KeyCode == keyCode
select e).FirstOrDefaultAsync <Udc>();
return(udc);
}
catch (Exception ex) { throw new Exception(GetMyMethodName(), ex); }
}
public async Task TestTableViewParameter()
{
try
{
UnitOfWork unitOfWork = new UnitOfWork();
ListensoftwaredbContext dbContext = unitOfWork.generalLedgerRepository._dbContext;
DataTable dt = new DataTable();
dt.Columns.Add("CustomerName", typeof(string));
dt.Columns.Add("FirstName", typeof(string));
dt.Columns.Add("LastName", typeof(string));
dt.Columns.Add("CompanyName", typeof(string));
dt.Columns.Add("Address_Line1", typeof(string));
dt.Columns.Add("Address_Line2", typeof(string));
dt.Columns.Add("City", typeof(string));
dt.Columns.Add("State", typeof(string));
dt.Columns.Add("Zipcode", typeof(string));
dt.Columns.Add("EmailText", typeof(string));
dt.Columns.Add("LoginEmail", typeof(bool));
dt.Columns.Add("Password", typeof(string));
dt.Rows.Add("customer name", "firstname", "lastname", "companyname"
, "address_line1", "address_line2", "city", "state", "zipcode",
"emailtext", true, "123");
List <SqlParameter> parameters = new List <SqlParameter>();
SqlParameter param1 = new SqlParameter();
param1.ParameterName = "@ParamHashTable";
param1.SqlDbType = SqlDbType.Structured;
param1.TypeName = "dbo.AccountRegistrationTableType";
param1.Value = dt;
parameters.Add(param1);
//DataTable query = await dbContext.Database.SqlQuery<DataTable>("usp_CreateAccount @ParamHashTable", param1).SingleAsync();
IList <DataTable> query = await dbContext.SqlQuery <DataTable>(CommandType.Text, "usp_CreateAccount @ParamHashTable", parameters);
//DataTable query = dbContext.Database.ExecuteSqlCommand("usp_createaccount @ParamHashTable");
//foreach (var item in query)
//{ }
}
catch (Exception ex)
{
throw new Exception("TestTableViewParameter", ex);
}
}
public InvoiceDetailRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public AddressBookRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
applicationViewFactory = new ApplicationViewFactory();
}
public ChartOfAccountRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
applicationViewFactory = new ApplicationViewFactory();
}
public PayRollPaySequenceRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public ContractInvoiceRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public ServiceInformationInvoiceRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public AccountReceivableInterestRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public ItemMasterRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public SupplierLedgerRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public BudgetRangeRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public PackingSlipDetailRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public ScheduleEventRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public TimeAndAttendanceSetupRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public JobCostLedgerRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public JobPhaseRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public PayRollGroupRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public ProjectManagementWorkOrderToEmployeeRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public CompanyRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public POQuoteRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public PurchaseOrderDetailRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public BudgetSnapShotRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public ShipmentDetailRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public TimeAndAttendanceRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
applicationViewFactory = new ApplicationViewFactory();
}
public CarrierRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public CustomerClaimRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public ProjectManagementProjectRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}
public SalesOrderRepository(DbContext db) : base(db)
{
_dbContext = (ListensoftwaredbContext)db;
}