public override EntityDtos <CityVillageDto> FindByQueryCommand(IRepositoryLocator locator, Query query)
{
Criterion criteriaBaseCVIdNotNull = new Criterion(Constants.BASECVID, null, CriteriaOperator.IsNotNullOrZero);
Criterion criteriaCAId = new Criterion(Constants.CAID, query.CAId, CriteriaOperator.Equal);
Query query1 = new Query();
query1.Add(criteriaCAId);
query1.Add(criteriaBaseCVIdNotNull);
IQueryable <CityVillage> caCVListWithBaseCVId = locator.GetRepository <CityVillage>().FindBy(query1);
IQueryable <CityVillage> CityVillageList = locator.GetRepository <CityVillage>().FindBy(query);
//CityVillageList = CityVillageList.Except(caCVListWithBaseCVId);
var itemIds = caCVListWithBaseCVId.Select(x => x.BaseCityVillageId).ToArray();
CityVillageList = CityVillageList.Where(x => !itemIds.Contains(x.CityVillageId));
IList <CityVillageDto> allDto = new List <CityVillageDto>();
foreach (CityVillage entity in CityVillageList)
{
allDto.Add(EntityToEntityDto(entity));
}
var result = new EntityDtos <CityVillageDto> {
Entities = allDto
};
result.TotalRecords = locator.GetRepository <CityVillage>().GetCount(query);
if (result.TotalRecords == 0)
{
Container.RequestContext.Notifier.AddWarning(BusinessWarningEnum.Default, "No records were found");
}
return(result);
}
public ActionResult StateListGridView()
{
statesMasterService = new StateServiceClient();
EntityDtos <StateDto> stateDto = statesMasterService.FindAll();
ViewData["StateList"] = stateDto.Entities;
return(PartialView("StateListGridView", ViewData["StateList"]));
}
private IList <ClientDto> GetClientList()
{
ClientServiceClient client = new ClientServiceClient();
Query query = new Query();
Criterion crActive = new Criterion("IsActive", true, CriteriaOperator.Equal);
query.Add(crActive);
EntityDtos <ClientDto> clientDtos = client.FindByQuery(query, false);
client.Close();
return(clientDtos.Entities);
}
private EntityDtos <TEntityDto> FindAllCommand(IRepositoryLocator locator)
{
IQueryable <TEntity> all = locator.GetRepository <TEntity>().FindAll();
var result = new EntityDtos <TEntityDto> {
Entities = Mapper.Map <IQueryable <TEntity>, List <TEntityDto> >(all)
};
if (result.Entities.Count() == 0)
{
Container.RequestContext.Notifier.AddWarning(BusinessWarningEnum.Default, "No Users were found");
}
return(result);
}
public virtual void GetBankId()
{
Query query = new Query();
Criterion bankname = new Criterion(Constants.BANKNAME, "Kotak Mahindra Bank", CriteriaOperator.Equal);
CurrentUserInstance.UserOfClient.CAId = 1;
Criterion caid = new Criterion(Constants.CAID, CurrentUserInstance.UserOfClient.CAId, CriteriaOperator.Equal);
query.Add(bankname);
query.Add(caid);
query.QueryOperator = QueryOperator.And;
EntityDtos <BankDto> bankdetails = BankService.FindByQuery(query);
int bankid = bankdetails.Entities[0].BankId;
}
private List <ZoneDto> GetZoneList()
{
ZonesMasterClient = new ZoneServiceClient();
UserDto currentUserDto = (UserDto)Session[Constants.SKCURRENTUSER];
Query query = new Query();
Criterion criteriaCAId = new Criterion(Constants.CAID, Helper.GetCAIdOfUser(currentUserDto), CriteriaOperator.Equal);
query.Add(criteriaCAId);
query.QueryOperator = QueryOperator.And;
EntityDtos <ZoneDto> zonedtos = ZonesMasterClient.FindByQuery(query);
ZonesMasterClient.Close();
return(zonedtos.Entities.ToList());
}
private EntityDtos <TEntityDto> FindByCommand(IRepositoryLocator locator, Query query, int pageIndex, int recordsPerPage)
{
IQueryable <TEntity> all = locator.GetRepository <TEntity>().FindBy(query, pageIndex, recordsPerPage);
IList <TEntityDto> allDto = new List <TEntityDto>();
foreach (TEntity entity in all)
{
allDto.Add(EntityToEntityDto(entity));
}
var result = new EntityDtos <TEntityDto> {
Entities = allDto
};
result.TotalRecords = locator.GetRepository <TEntity>().GetCount(query);
if (result.TotalRecords == 0)
{
Container.RequestContext.Notifier.AddWarning(BusinessWarningEnum.Default, "No records were found");
}
return(result);
}
private EntityDtos <TEntityDto> FindAllCommand(IRepositoryLocator locator)
{
IQueryable <TEntity> all = locator.GetRepository <TEntity>().FindAll();
IList <TEntityDto> allDto = new List <TEntityDto>();
PopulateChildObjects = false;
foreach (TEntity entity in all)
{
allDto.Add(EntityToEntityDto(entity));
}
var result = new EntityDtos <TEntityDto> {
Entities = allDto
};
result.TotalRecords = result.Entities.Count();
if (result.TotalRecords == 0)
{
Container.RequestContext.Notifier.AddWarning(BusinessWarningEnum.Default, "No Records were found");
}
return(result);
}
public ActionResult StateList()
{
try
{
statesMasterService = new StateServiceClient();
EntityDtos <StateDto> stateDto = statesMasterService.FindAll();
ViewData["StateList"] = stateDto.Entities;
}
catch (Exception ex)
{
return(View("ErrorPage"));
}
finally
{
if (statesMasterService != null)
{
statesMasterService.Close();
}
}
return(View("StateList", ViewData["StateList"]));
}
public List <ClientDto> GetCAList()
{
ClientServiceClient client = new ClientServiceClient();
//UserDto CurrentUser = (UserDto)Session[Constants.SKCURRENTUSER];
Query query = new Query();
Criterion crActive = new Criterion("IsActive", true, CriteriaOperator.Equal);
query.Add(crActive);
EntityDtos <ClientDto> clientDtos = client.FindByQuery(query, false);
//var caDtos = client.FindAll();
List <ClientDto> caList = clientDtos.Entities.ToList();
caList.Insert(0, new ClientDto
{
CAId = 0,
CompanyName = "[Select]",
DisplayClientId = ""
});
client.Close();
return(caList);
}