public IEnumerable <string> GetCustomerGroupIDs()
{
using (CDQMContext entityContext = new CDQMContext())
{
return(entityContext.CDQMCustomerDuplicateSet.Select(c => c.COD_GROUP_ID).ToFullyLoaded());
}
}
public CDQMCustomerDuplicate GetCustomerDuplicate(string customerId)
{
using (CDQMContext entityContext = new CDQMContext())
{
return(entityContext.CDQMCustomerDuplicateSet.Where(c => c.COD_CUST_ID == customerId).FirstOrDefault());
}
}
public IEnumerable <CDQMCustomerDuplicate> GetCustomerDuplicates(string groupId)
{
using (CDQMContext entityContext = new CDQMContext())
{
return(entityContext.CDQMCustomerDuplicateSet.Where(c => c.COD_GROUP_ID == groupId).ToFullyLoaded());
}
}
protected override CDQMCustomerMIS GetEntity(CDQMContext entityContext, int id)
{
var query = (from e in entityContext.Set <CDQMCustomerMIS>()
where e.CustomerMISId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override CDQMETLConfiguration GetEntity(CDQMContext entityContext, int id)
{
var query = (from e in entityContext.Set <CDQMETLConfiguration>()
where e.ETLConfigurationId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override CDQMGenderGroup GetEntity(CDQMContext entityContext, int id)
{
var query = (from e in entityContext.Set <CDQMGenderGroup>()
where e.GenderGroupId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override CDQMCustomerPersistent GetEntity(CDQMContext entityContext, int id)
{
var query = (from e in entityContext.Set <CDQMCustomerPersistent>()
where e.CUSTOMER_PERSISTENT_ID == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override CDQMCustomerDuplicate GetEntity(CDQMContext entityContext, int id)
{
var query = (from e in entityContext.Set <CDQMCustomerDuplicate>()
where e.CUST_DUPLICATES_ID == id
select e);
var results = query.FirstOrDefault();
return(results);
}
public IEnumerable <CDQMCustomerPersistent> GetCustomerPersistents(string groupId)
{
using (CDQMContext entityContext = new CDQMContext())
{
var query = from a in entityContext.CDQMCustomerPersistentSet
where a.COD_GROUP_ID == groupId
select a;
return(query.ToFullyLoaded());
}
}
protected override CDQMCustomerMIS AddEntity(CDQMContext entityContext, CDQMCustomerMIS entity)
{
return(entityContext.Set <CDQMCustomerMIS>().Add(entity));
}
protected override IEnumerable <CDQMGenderGroup> GetEntities(CDQMContext entityContext)
{
return(from e in entityContext.Set <CDQMGenderGroup>()
select e);
}
protected override CDQMGenderGroup UpdateEntity(CDQMContext entityContext, CDQMGenderGroup entity)
{
return((from e in entityContext.Set <CDQMGenderGroup>()
where e.GenderGroupId == entity.GenderGroupId
select e).FirstOrDefault());
}
protected override CDQMGenderGroup AddEntity(CDQMContext entityContext, CDQMGenderGroup entity)
{
return(entityContext.Set <CDQMGenderGroup>().Add(entity));
}
protected override CDQMTitle UpdateEntity(CDQMContext entityContext, CDQMTitle entity)
{
return((from e in entityContext.Set <CDQMTitle>()
where e.TitleId == entity.TitleId
select e).FirstOrDefault());
}
protected override CDQMTitle AddEntity(CDQMContext entityContext, CDQMTitle entity)
{
return(entityContext.Set <CDQMTitle>().Add(entity));
}
protected override IEnumerable <CDQMETLConfiguration> GetEntities(CDQMContext entityContext)
{
return(from e in entityContext.Set <CDQMETLConfiguration>()
select e);
}
protected override CDQMAddress AddEntity(CDQMContext entityContext, CDQMAddress entity)
{
return(entityContext.Set <CDQMAddress>().Add(entity));
}
protected override CDQMProduct AddEntity(CDQMContext entityContext, CDQMProduct entity)
{
return(entityContext.Set <CDQMProduct>().Add(entity));
}
protected override CDQMETLConfiguration AddEntity(CDQMContext entityContext, CDQMETLConfiguration entity)
{
return(entityContext.Set <CDQMETLConfiguration>().Add(entity));
}
protected override CDQMCustomerDuplicate UpdateEntity(CDQMContext entityContext, CDQMCustomerDuplicate entity)
{
return((from e in entityContext.Set <CDQMCustomerDuplicate>()
where e.CUST_DUPLICATES_ID == entity.CUST_DUPLICATES_ID
select e).FirstOrDefault());
}
protected override CDQMCustomerDuplicate AddEntity(CDQMContext entityContext, CDQMCustomerDuplicate entity)
{
return(entityContext.Set <CDQMCustomerDuplicate>().Add(entity));
}
protected override CDQMMerchant AddEntity(CDQMContext entityContext, CDQMMerchant entity)
{
return(entityContext.Set <CDQMMerchant>().Add(entity));
}
protected override CDQMProduct UpdateEntity(CDQMContext entityContext, CDQMProduct entity)
{
return((from e in entityContext.Set <CDQMProduct>()
where e.ProductId == entity.ProductId
select e).FirstOrDefault());
}
protected override IEnumerable <CDQMCustomerMIS> GetEntities(CDQMContext entityContext)
{
return(from e in entityContext.Set <CDQMCustomerMIS>()
select e);
}
protected override CDQMAddress UpdateEntity(CDQMContext entityContext, CDQMAddress entity)
{
return((from e in entityContext.Set <CDQMAddress>()
where e.AddressId == entity.AddressId
select e).FirstOrDefault());
}
protected override CDQMETLConfiguration UpdateEntity(CDQMContext entityContext, CDQMETLConfiguration entity)
{
return((from e in entityContext.Set <CDQMETLConfiguration>()
where e.ETLConfigurationId == entity.ETLConfigurationId
select e).FirstOrDefault());
}
protected override CDQMCustomerMIS UpdateEntity(CDQMContext entityContext, CDQMCustomerMIS entity)
{
return((from e in entityContext.Set <CDQMCustomerMIS>()
where e.CustomerMISId == entity.CustomerMISId
select e).FirstOrDefault());
}
protected override CDQMCountry AddEntity(CDQMContext entityContext, CDQMCountry entity)
{
return(entityContext.Set <CDQMCountry>().Add(entity));
}
protected override CDQMCountry UpdateEntity(CDQMContext entityContext, CDQMCountry entity)
{
return((from e in entityContext.Set <CDQMCountry>()
where e.CountryId == entity.CountryId
select e).FirstOrDefault());
}
protected override CDQMCustomerPersistent UpdateEntity(CDQMContext entityContext, CDQMCustomerPersistent entity)
{
return((from e in entityContext.Set <CDQMCustomerPersistent>()
where e.CUSTOMER_PERSISTENT_ID == entity.CUSTOMER_PERSISTENT_ID
select e).FirstOrDefault());
}