private bool IsAPMCPresent(APMC apmcMaster, bool IsEdit)
{
bool checkapmcPresence = false;
Query query = new Query();
Criterion criteriaName = new Criterion("Name", apmcMaster.Name, CriteriaOperator.Equal);
Criterion criteriaType = new Criterion("cv.Name", apmcMaster.Address.CityVillage.Name, CriteriaOperator.Equal);
if (IsEdit)
{
Criterion criteriaId = new Criterion(Constants.APMCID, apmcMaster.APMCId, CriteriaOperator.NotEqual);
query.Add(criteriaId);
}
query.Add(criteriaName);
query.Add(criteriaType);
query.AddAlias(new Alias("ad", "Address"));
query.AddAlias(new Alias("cv", "ad.CityVillage"));
query.QueryOperator = QueryOperator.And;
var apmcMasterList = ExecuteCommand(locator => locator.GetRepository <APMC>().FindBy(query));
if (apmcMasterList.Count() != 0)
{
checkapmcPresence = true;
}
return(checkapmcPresence);
}
private bool IsSWIFTCodePresent1(BankBranch bankbranch)
{
bool checkSWIFTCodePresence = false;
Query query = new Query();
Criterion criteriaName = new Criterion(Constants.SWIFTCODE, bankbranch.SWIFTCode, CriteriaOperator.Equal);
Criterion criteriaCAId;
if (bankbranch.CAId != null)
{
criteriaCAId = new Criterion(Constants.CAID, bankbranch.CAId, CriteriaOperator.Equal);
}
else
{
criteriaCAId = new Criterion(Constants.CAID, null, CriteriaOperator.IsNullOrZero);
}
Criterion criteriaBankId = new Criterion("bank.BankId", bankbranch.BranchOfBank.BankId, CriteriaOperator.NotEqual);
query.Add(criteriaName);
query.Add(criteriaCAId);
query.Add(criteriaBankId);
query.AddAlias(new Alias("bank", "BranchOfBank"));
query.QueryOperator = QueryOperator.And;
var SWIFTCodeList = ExecuteCommand(locator => locator.GetRepository <BankBranch>().FindBy(query));
if (SWIFTCodeList.Count() != 0)
{
checkSWIFTCodePresence = true;
}
return(checkSWIFTCodePresence);
}
//private bool IsCityVillagePresent1(CityVillage cityvillage)
//{
// bool checkCityVillagePresence = false;
// Query query = new Query();
// Criterion criteriaName = new Criterion(Constants.CITYVILLAGENAME, cityvillage.Name, CriteriaOperator.Equal);
// Criterion criteriaType = new Criterion(Constants.CITYORVILLAGE, cityvillage.CityOrVillage, CriteriaOperator.Equal);
// Criterion criteriaDistrictId = new Criterion("Dt.DistrictId", cityvillage.DistrictOfCityVillage.DistrictId, CriteriaOperator.Equal);
// query.Add(criteriaName);
// query.Add(criteriaType);
// query.Add(criteriaDistrictId);
// query.AddAlias(new Alias("Dt", "DistrictOfCityVillage"));
// query.QueryOperator = QueryOperator.And;
// var cityvillageList = ExecuteCommand(locator => locator.GetRepository<CityVillage>().FindBy(query));
// if (cityvillageList.Count() != 0)
// {
// checkCityVillagePresence = true;
// }
// return checkCityVillagePresence;
//}
#endregion
private bool IsCityVillagePresent(CityVillage cityvillage)
{
bool checkCityVillagePresence = false;
Query query = new Query();
Criterion criteriaName = new Criterion(Constants.CITYVILLAGENAME, cityvillage.Name, CriteriaOperator.Equal);
Criterion criteriaType = new Criterion(Constants.CITYORVILLAGE, cityvillage.CityOrVillage, CriteriaOperator.Equal);
Criterion criteriaDistrictId = new Criterion("Dt.DistrictId", cityvillage.DistrictOfCityVillage.DistrictId, CriteriaOperator.Equal);
Criterion criteriaCAId = new Criterion(Constants.CAID, cityvillage.CAId, CriteriaOperator.Equal);
Criterion criteriaCAIdNull = new Criterion(Constants.CAID, null, CriteriaOperator.IsNullOrZero);
query.AddAlias(new Alias("Dt", "DistrictOfCityVillage"));
if (cityvillage.CAId == null)
{
query.Add(criteriaName);
query.Add(criteriaCAIdNull);
query.Add(criteriaDistrictId);
query.Add(criteriaType);
query.QueryOperator = QueryOperator.And;
var cvlist = FindByQuery(query);
checkCityVillagePresence = (cvlist.TotalRecords != 0) ? true : false;
//For Update Scenario
if (checkCityVillagePresence && cvlist.TotalRecords == 1 && cvlist.Entities.ToList().FirstOrDefault().CityVillageId == cityvillage.CityVillageId)
{
checkCityVillagePresence = false;
}
}
else
{
query.Add(criteriaName);
query.Add(criteriaDistrictId);
query.Add(criteriaType);
Query subquery = new Query();
subquery.Add(criteriaCAId);
subquery.Add(criteriaCAIdNull);
subquery.QueryOperator = QueryOperator.Or;
query.AddSubQuery(subquery);
query.QueryOperator = QueryOperator.And;
query.CAId = (int)cityvillage.CAId;
var cvlist = FindByQuery(query);
IEnumerable <CityVillageDto> cvDtoList = cvlist.Entities.AsEnumerable();
checkCityVillagePresence = (cvDtoList.Count() != 0) ? true : false;
//For Update Scenario
if (cvDtoList.Count() == 1 && cvDtoList.FirstOrDefault().CityVillageId == cityvillage.CityVillageId)
{
checkCityVillagePresence = false;
}
if (cvDtoList.Count() == 1 && cvDtoList.FirstOrDefault().CityVillageId == cityvillage.BaseCityVillageId)
{
checkCityVillagePresence = false;
}
}
return(checkCityVillagePresence);
}
public CommodityDto GetCommodityByClassId(CommodityDto CommoditymasterDto)
{
CommodityClient = new CommodityServiceClient();
Query query = new Query();
Criterion criteriaClassID = new Criterion("commodityclass.CommodityClassId", CommoditymasterDto.CommoditiesInCommodityClass.CommodityClassId, CriteriaOperator.Equal);
query.Add(criteriaClassID);
query.AddAlias(new Alias("commodityclass", "CommoditiesInCommodityClass"));
var commoditydtos = CommodityClient.FindByQuery(query);
CommodityClient.Close();
return(commoditydtos.Entities.FirstOrDefault());
}
public virtual void FindDistricts()
{
int stateId = 1;
Query query = new Query();
Criterion criteriaState = new Criterion("st.StateId", stateId, CriteriaOperator.Equal);
query.Add(criteriaState);
query.AddAlias(new Alias("st", "StateOfDistrict"));
var result = this.DistrictService.FindByQuery(query);
Assert.IsTrue(result.Entities.Count > 0, "Districts found");
}
private bool IsBankBranchPresent1(BankBranch bankbranch)
{
bool checkBankBranchPresence = false;
Query query = new Query();
Criterion criteriaName = new Criterion(Constants.BANKBRANCHNAME, bankbranch.Name, CriteriaOperator.Equal);
Criterion criteriaCAId;
if (bankbranch.CAId != null)
{
criteriaCAId = new Criterion(Constants.CAID, bankbranch.CAId, CriteriaOperator.Equal);
}
else
{
criteriaCAId = new Criterion(Constants.CAID, null, CriteriaOperator.IsNullOrZero);
}
if (bankbranch.BranchOfBank.BankId != 0)
{
Criterion criteriaBankId = new Criterion("bank.BankId", bankbranch.BranchOfBank.BankId, CriteriaOperator.Equal);
query.Add(criteriaBankId);
query.AddAlias(new Alias("bank", "BranchOfBank"));
}
Criterion criteriaCV = new Criterion("cv.CityVillageId", bankbranch.BranchAddress.CityVillage.CityVillageId, CriteriaOperator.Equal);
query.Add(criteriaName);
query.Add(criteriaCAId);
query.Add(criteriaCV);
query.AddAlias(new Alias("ba", "BranchAddress"));
query.AddAlias(new Alias("cv", "ba.CityVillage"));
query.QueryOperator = QueryOperator.And;
var bankbranchList = ExecuteCommand(locator => locator.GetRepository <BankBranch>().FindBy(query));
if (bankbranchList.Count() != 0)
{
checkBankBranchPresence = true;
}
return(checkBankBranchPresence);
}
public GetAlbumsByGenreResponse GetAlbumsByGenre(GetAlbumsByGenreRequest request)
{
var response = new GetAlbumsByGenreResponse();
var albumQuery = new Query();
albumQuery.AddAlias(QueryAlias.CreateAlias <Album>(g => g.Genre));
albumQuery.Add(Criterion.Create <Album, Genre>(a => a.Genre, g => g.Name, request.Genre, CriteriaOperator.Equal));
var albums = _albumRepository.FindAll(albumQuery);
response.Albums = albums.ConvertToAlbumViews();
return(response);
}
public static List <DistrictDto> GetDistricts(int state)
{
Query query = new Query();
Criterion criteriaState = new Criterion("st.StateId", state, CriteriaOperator.Equal);
query.Add(criteriaState);
query.AddAlias(new Alias("st", "StateOfDistrict"));
DistrictServiceReference.IDistrictService client = new DistrictServiceClient();
var districts = client.FindByQuery(query);
List <DistrictDto> districtList = new List <DistrictDto>();
districtList = districts.Entities.ToList();
districtList.Insert(0, new DistrictDto
{
DistrictId = 0,
DistrictName = "[Select]"
});
return(districtList);
}
private bool CheckIfPlaceBelongsToTheGivenDistrict(int DistrictId, int CityVillageId)
{
bool isPresent = false;
Query query = new Query();
Criterion criteriaDistrict = new Criterion("st.DistrictId", DistrictId, CriteriaOperator.Equal);
Criterion criteriaPlace = new Criterion("CityVillageId", CityVillageId, CriteriaOperator.Equal);
query.Add(criteriaDistrict);
query.Add(criteriaPlace);
query.AddAlias(new Alias("st", "DistrictOfCityVillage"));
CityVillageServiceReference.ICityVillageService client = new CityVillageServiceClient();
var cityVillage = client.FindByQuery(query);
if (cityVillage.TotalRecords > 0)
{
isPresent = true;
}
return(isPresent);
}
private bool CheckIfDistrictBelongsToTheGivenState(int StateId, int DistrictId)
{
bool isPresent = false;
Query query = new Query();
Criterion criteriaState = new Criterion("st.StateId", StateId, CriteriaOperator.Equal);
Criterion criteriaDistrict = new Criterion("DistrictId", DistrictId, CriteriaOperator.Equal);
query.Add(criteriaState);
query.Add(criteriaDistrict);
query.AddAlias(new Alias("st", "StateOfDistrict"));
DistrictServiceReference.IDistrictService client = new DistrictServiceClient();
var districts = client.FindByQuery(query);
if (districts.TotalRecords > 0)
{
isPresent = true;
}
return(isPresent);
}
public static List <CityVillageDto> GetPlaces(int district)
{
Query query = new Query();
Criterion criteriaState = new Criterion("st.DistrictId", district, CriteriaOperator.Equal);
query.Add(criteriaState);
query.AddAlias(new Alias("st", "DistrictOfCityVillage"));
CityVillageServiceReference.ICityVillageService client = new CityVillageServiceClient();
var cityVillage = client.FindByQuery(query);
List <CityVillageDto> cityVillageList = new List <CityVillageDto>();
cityVillageList = cityVillage.Entities.ToList();
cityVillageList.Insert(0, new CityVillageDto
{
CityVillageId = 0,
CityOrVillage = CityVillageType.City,
Name = "[Select]"
});
return(cityVillageList);
}
public List <BankBranchDto> GetBankBranchList(int BankId)
{
UserDto currentUserDto = (UserDto)Session[Constants.SKCURRENTUSER];
Query subquery1 = new Query();
if (Helper.IsCAIdNotNull(currentUserDto))
{
Criterion criteriaCAId = new Criterion(Constants.CAID, Helper.GetCAIdOfUser(currentUserDto), CriteriaOperator.Equal);
subquery1.Add(criteriaCAId);
Criterion criteriaCAIdNULL = new Criterion(Constants.CAID, null, CriteriaOperator.IsNullOrZero);
subquery1.Add(criteriaCAIdNULL);
subquery1.QueryOperator = QueryOperator.Or;
}
else
{
Criterion criteriaCAIdNULL = new Criterion(Constants.CAID, null, CriteriaOperator.IsNullOrZero);
subquery1.Add(criteriaCAIdNULL);
}
Query query = new Query();
if (Helper.IsCAIdNotNull(currentUserDto))
{
query.CAId = Convert.ToInt32(Helper.GetCAIdOfUser(currentUserDto));
}
Criterion criteriaBankId = new Criterion("banks.BankId", BankId, CriteriaOperator.Equal);
query.Add(criteriaBankId);
query.AddAlias(new Alias("banks", "BranchOfBank"));
query.QueryOperator = QueryOperator.And;
query.AddSubQuery(subquery1);
Branchclient = new BankBranchServiceClient();
var BankBranches = Branchclient.FindByQuery(query);
Branchclient.Close();
return(BankBranches.Entities.ToList());
}
public virtual void FindBranchesOfCA()
{
UserDto currentUserDto = UserService.GetById(42);
Query subquery1 = new Query();
if (currentUserDto.UserOfClient.CAId > 0)
{
Criterion criteriaCAId = new Criterion(Constants.CAID, currentUserDto.UserOfClient.CAId, CriteriaOperator.Equal);
subquery1.Add(criteriaCAId);
Criterion criteriaCAIdNULL = new Criterion(Constants.CAID, null, CriteriaOperator.IsNullOrZero);
subquery1.Add(criteriaCAIdNULL);
subquery1.QueryOperator = QueryOperator.Or;
}
else
{
Criterion criteriaCAIdNULL = new Criterion(Constants.CAID, null, CriteriaOperator.IsNullOrZero);
subquery1.Add(criteriaCAIdNULL);
}
Query query = new Query();
if (currentUserDto.UserOfClient.CAId > 0)
{
query.CAId = Convert.ToInt32(currentUserDto.UserOfClient.CAId);
}
Criterion criteriaBankId = new Criterion("banks.BankId", 1, CriteriaOperator.Equal);
query.Add(criteriaBankId);
query.AddAlias(new Alias("banks", "BranchOfBank"));
query.QueryOperator = QueryOperator.And;
query.AddSubQuery(subquery1);
var BankBranches = BankBranchService.FindByQuery(query);
Assert.IsTrue(BankBranches.Entities.ToList().Count > 0, "found bank branch");
}
private bool IsCommodityPresent(Commodity commodity, bool IsEdit)
{
bool checkCommodityPresence = false;
Query query = new Query();
Criterion criteriaName = new Criterion(Constants.COMMODITYNAME, commodity.Name, CriteriaOperator.Equal);
Criterion criteriaClassID = new Criterion("commodityclass.CommodityClassId", commodity.CommoditiesInCommodityClass.CommodityClassId, CriteriaOperator.Equal);
query.Add(criteriaName);
query.Add(criteriaClassID);
if (IsEdit)
{
Criterion criteriaId = new Criterion(Constants.COMMODITYID, commodity.CommodityId, CriteriaOperator.NotEqual);
query.Add(criteriaId);
}
query.AddAlias(new Alias("commodityclass", "CommoditiesInCommodityClass"));
query.QueryOperator = QueryOperator.And;
var commodityList = ExecuteCommand(locator => locator.GetRepository <Commodity>().FindBy(query));
if (commodityList.Count() != 0)
{
checkCommodityPresence = true;
}
return(checkCommodityPresence);
}
private bool IsBankBranchPresent(BankBranch bankbranch)
{
bool isPresent = false;
Query query = new Query();
Criterion criteriaName = new Criterion(Constants.BANKBRANCHNAME, bankbranch.Name, CriteriaOperator.Equal);
Criterion criteriaCAId = new Criterion(Constants.CAID, bankbranch.CAId, CriteriaOperator.Equal);
Criterion criteriaCAIdNull = new Criterion(Constants.CAID, null, CriteriaOperator.IsNullOrZero);
Criterion criteriaBankId = new Criterion("bank.BankId", bankbranch.BranchOfBank.BankId, CriteriaOperator.Equal);
query.AddAlias(new Alias("bank", "BranchOfBank"));
Criterion criteriaCV = new Criterion("cv.CityVillageId", bankbranch.BranchAddress.CityVillage.CityVillageId, CriteriaOperator.Equal);
query.AddAlias(new Alias("ba", "BranchAddress"));
query.AddAlias(new Alias("cv", "ba.CityVillage"));
if (bankbranch.CAId == null)
{
query.Add(criteriaName);
query.Add(criteriaCAIdNull);
query.Add(criteriaBankId);
query.Add(criteriaCV);
query.QueryOperator = QueryOperator.And;
var branchlist = FindByQuery(query);
isPresent = (branchlist.TotalRecords != 0) ? true : false;
//For Update Scenario
if (isPresent && branchlist.TotalRecords == 1 && branchlist.Entities.ToList().FirstOrDefault().BranchId == bankbranch.BranchId)
{
isPresent = false;
}
}
else
{
query.Add(criteriaName);
query.Add(criteriaBankId);
query.Add(criteriaCV);
Query subquery = new Query();
subquery.Add(criteriaCAId);
subquery.Add(criteriaCAIdNull);
subquery.QueryOperator = QueryOperator.Or;
query.AddSubQuery(subquery);
query.QueryOperator = QueryOperator.And;
query.CAId = (int)bankbranch.CAId;
var branchlist = FindByQuery(query);
IEnumerable <BankBranchDto> bankbranchDtoList = branchlist.Entities.AsEnumerable();
isPresent = (bankbranchDtoList.Count() != 0) ? true : false;
//For Update Scenario
if (bankbranchDtoList.Count() == 1 && bankbranchDtoList.FirstOrDefault().BranchId == bankbranch.BranchId)
{
isPresent = false;
}
if (bankbranchDtoList.Count() == 1 && bankbranchDtoList.FirstOrDefault().BranchId == bankbranch.BaseBranchId)
{
isPresent = false;
}
}
return(isPresent);
}
////function to check wheather chequeDate is greater than 6 months from current date
//public bool CheckChequeDate(string chequeDate)
//{
// DateTime chequeDDTransactionDate;
// double totalDays;
// bool isChequeDateGreaterThanSixMonths=false;
// if(!string.IsNullOrEmpty(chequeDate))
// {
// DateTimeFormatInfo dateTimeFormatInfo = new DateTimeFormatInfo();
// dateTimeFormatInfo.ShortDatePattern = "dd-MM-yyyy";
// dateTimeFormatInfo.DateSeparator = "-";
// chequeDDTransactionDate = Convert.ToDateTime(chequeDate, dateTimeFormatInfo);
// totalDays = chequeDDTransactionDate.Subtract(DateTime.Now).TotalDays;
// if(totalDays >90)
// {
// isChequeDateGreaterThanSixMonths = true;
// }
// }
// return isChequeDateGreaterThanSixMonths;
//}
#endregion
#region SearchBankandBranch
public ActionResult SearchBankandBranch()
{
bool flag = false;
string bankName = Request.Params["bankName"];
string bankBranch = Request.Params["bankBranch"];
string place = Request.Params["place"];
string IFSCCode = Request.Params["IFSCCode"];
string MICRCode = Request.Params["MICRCode"];
string SWIFTCode = Request.Params["SWIFTCode"];
BankBranchServiceReference.BankBranchServiceClient bankBranchServiceClient = new BankBranchServiceClient();
IList <BankBranchDto> bankBranchDtoList = null;
Query query = new Query();
if (!string.IsNullOrEmpty(bankName))
{
flag = true;
Criterion criterionBankName = new Criterion("BranchBank.BankName", bankName, CriteriaOperator.Equal);
query.AddAlias(new Alias("BranchBank", "BranchOfBank"));
query.Add(criterionBankName);
}
if (!string.IsNullOrEmpty(bankBranch))
{
flag = true;
Criterion criterionBranchName = new Criterion("Name", bankBranch, CriteriaOperator.Equal);
query.Add(criterionBranchName);
}
if (!string.IsNullOrEmpty(place))
{
flag = true;
Criterion criterionplace = new Criterion("cv.Name", place, CriteriaOperator.Equal);
query.AddAlias(new Alias("ba", "BranchAddress"));
query.AddAlias(new Alias("cv", "ba.CityVillage"));
query.Add(criterionplace);
}
if (!string.IsNullOrEmpty(IFSCCode))
{
flag = true;
Criterion criterionIFSCCode = new Criterion("IFSCCode", IFSCCode, CriteriaOperator.Equal);
query.Add(criterionIFSCCode);
}
if (!string.IsNullOrEmpty(MICRCode))
{
flag = true;
Criterion criterionMICRCode = new Criterion("MICRCode", MICRCode, CriteriaOperator.Equal);
query.Add(criterionMICRCode);
}
if (!string.IsNullOrEmpty(SWIFTCode))
{
flag = true;
Criterion criterionSWIFTCode = new Criterion("SWIFTCode", SWIFTCode, CriteriaOperator.Equal);
query.Add(criterionSWIFTCode);
}
if (flag)
{
query.QueryOperator = QueryOperator.And;
bankBranchDtoList = bankBranchServiceClient.FindByQuery(query).Entities;
bankBranchServiceClient.Close();
ViewData["SearchBank"] = bankBranchDtoList;
}
else
{
ViewData["SearchBank"] = null;
}
return(PartialView("CBPPopupSearchBankBranchGrid", ViewData["SearchBank"]));
}
private Query BuildQueryForUserList(string UserGroupIdList, string UserType, int?CAId)
{
//Default Criteria
Query query = new Query();
try
{
UserDto CurrentUser = (UserDto)Session[Constants.SKCURRENTUSER];
Criterion criteriaCAId;
string[] ugIdList = UserGroupIdList.Split(';');
//query.AddAlias(new Alias("UserOfClient", "UserOfClient"));
//Is SuperAdmin and Ack User
if (UserType == "AckUser" && !Helper.IsCAIdNotNull(CurrentUser))
{
//query.AddAlias(new Alias("UserOfClient", "UserOfClient",JoinType.LeftOuterJoin));
//criteriaCAId = new Criterion("UserOfClient.CAId", null, CriteriaOperator.IsNullOrZero);
criteriaCAId = new Criterion("CAId", null, CriteriaOperator.IsNullOrZero);
query.Add(criteriaCAId);
//IList<Criterion> criList = new List<Criterion>();
//criList.Add(criteriaCAId);
//query.AddJoinParamteres(new JoinParameters("UserOfClient", "UserOfClient", JoinType.LeftOuterJoin,criList));
}
else if (UserType == "CAUser" && (CAId != null || CAId != 0))
{
//query.AddAlias(new Alias("UserOfClient", "UserOfClient"));
//criteriaCAId = new Criterion("UserOfClient.CAId", CAId, CriteriaOperator.Equal);
criteriaCAId = new Criterion("CAId", CAId, CriteriaOperator.Equal);
query.Add(criteriaCAId);
}
else
{
//query.AddAlias(new Alias("UserOfClient", "UserOfClient"));
//criteriaCAId = new Criterion("UserOfClient.CAId", Helper.GetCAIdOfUser(CurrentUser), CriteriaOperator.Equal);
criteriaCAId = new Criterion("CAId", Helper.GetCAIdOfUser(CurrentUser), CriteriaOperator.Equal);
query.Add(criteriaCAId);
}
Query subquery = null;;
query.AddAlias(new Alias("ug", "UserWithUserGroups"));
//Add Filter criteria on selected UserGroups
Criterion criteriaUserGroup = null;
foreach (string ugId in ugIdList)
{
int userGroupId = Convert.ToInt32(ugId);
if (userGroupId == 0)
{
//query.AddAlias(new Alias("ug", "UserWithUserGroups"));
break;
}
else
{
if (userGroupId != -1)
{
//if (query.Alias.ToList().Count == 0)
// query.AddAlias(new Alias("ug", "UserWithUserGroups"));
criteriaUserGroup = new Criterion(Constants.USERGROUPID, userGroupId, CriteriaOperator.Equal);
if (subquery == null)
{
subquery = new Query();
}
subquery.Add(criteriaUserGroup);
subquery.QueryOperator = QueryOperator.Or;
}
}
}
if (subquery != null)
{
query.AddSubQuery(subquery);
query.QueryOperator = QueryOperator.And;
}
}
catch (Exception ex)
{
}
return(query);
}
