protected void odsCRMAgreement_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression("CRMAgreement." + CRMAgreementEntity.FLD_NAME_CreatedByEmployeeID, CurrentemployeeID.ToString(), SQLMatchType.Equal);
if (chbxFilter.Checked)
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("BDProject.ProjectName", txtSearchText.Text.ToString(), SQLMatchType.LikeWithBothMath);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression("BDProjectFloorUnit.ProjectFloorUnitName", txtSearchText.Text.ToString(), SQLMatchType.LikeWithBothMath);
String fe4 = SqlExpressionBuilder.PrepareFilterExpression("CRMMDAgreementType.Name", txtSearchText.Text.ToString(), SQLMatchType.LikeWithBothMath);
String fe3 = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.OR, fe2);
String fe5 = SqlExpressionBuilder.PrepareFilterExpression(fe3, SQLJoinType.OR, fe4);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe5);
}
e.InputParameters["filterExpression"] = fe;
}
protected void odsCRMCommunication_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression(CRMCommunicationEntity.FLD_NAME_CommunicateByEmployeeID, CurrentemployeeID.ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression(CRMCommunicationEntity.FLD_NAME_CreatedByEmployeeID, CurrentemployeeID.ToString(), SQLMatchType.Equal);
String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.OR, fe2);
if (chbxFilter.Checked)
{
String fe9 = "CommunicateToContactFullName like '%" + txtSearchText.Text + "%'";
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe9);
}
e.InputParameters["filterExpression"] = fe;
}
protected void odsCRMBuyerBasicInfo_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("CRMBuyerBasicInfo." + CRMBuyerBasicInfoEntity.FLD_NAME_CreatedByEmployeeID, CurrentemployeeID.ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression("CRMBuyerBasicInfo." + CRMBuyerBasicInfoEntity.FLD_NAME_LeadGeneratedByEmployeeID, CurrentemployeeID.ToString(), SQLMatchType.Equal);
String fe3 = SqlExpressionBuilder.PrepareFilterExpression("CRMBuyerBasicInfo." + CRMBuyerBasicInfoEntity.FLD_NAME_LeadManagedByOneEmployeeID, CurrentemployeeID.ToString(), SQLMatchType.Equal);
String fe4 = SqlExpressionBuilder.PrepareFilterExpression("CRMBuyerBasicInfo." + CRMBuyerBasicInfoEntity.FLD_NAME_LeadManagedByTwoEmployeeID, CurrentemployeeID.ToString(), SQLMatchType.Equal);
String fe5 = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.OR, fe2);
String fe6 = SqlExpressionBuilder.PrepareFilterExpression(fe3, SQLJoinType.OR, fe4);
String fe = SqlExpressionBuilder.PrepareFilterExpression(fe5, SQLJoinType.OR, fe6);
if (PageAPType == MasterDataConstants.CRMMDBuyerType.EXISTING_BUYER)
{
String fe7 = SqlExpressionBuilder.PrepareFilterExpression("CRMBuyerBasicInfo." + CRMBuyerBasicInfoEntity.FLD_NAME_BuyerTypeID, MasterDataConstants.CRMMDBuyerType.EXISTING_BUYER.ToString(), SQLMatchType.Equal);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe7);
}
if (chbxFilter.Checked)
{
fe = "((((CRMBuyerBasicInfo.CreatedByEmployeeID = " + CurrentemployeeID + " OR CRMBuyerBasicInfo.LeadGeneratedByEmployeeID = " + CurrentemployeeID + ") and CRMBuyerBasicInfo.CompanyName like '%" + txtSearchText.Text.ToString() + "%') OR ((CRMBuyerBasicInfo.LeadManagedByOneEmployeeID = " + CurrentemployeeID + " OR CRMBuyerBasicInfo.LeadManagedByTwoEmployeeID = " + CurrentemployeeID + ")) and CRMBuyerBasicInfo.ContactFullName like '%" + txtSearchText.Text + "%') )";
//fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe9);
}
e.InputParameters["filterExpression"] = fe;
}
protected void odsCRMLandBasicInfo_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("CRMLandBasicInfo." + CRMLandBasicInfoEntity.FLD_NAME_CreatedByEmployeeID, CurrentemployeeID.ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression("CRMLandBasicInfo." + CRMLandBasicInfoEntity.FLD_NAME_LeadGeneratedByEmployeeID, CurrentemployeeID.ToString(), SQLMatchType.Equal);
String fe3 = SqlExpressionBuilder.PrepareFilterExpression("CRMLandBasicInfo." + CRMLandBasicInfoEntity.FLD_NAME_LeadManagedByOneEmployeeID, CurrentemployeeID.ToString(), SQLMatchType.Equal);
String fe4 = SqlExpressionBuilder.PrepareFilterExpression("CRMLandBasicInfo." + CRMLandBasicInfoEntity.FLD_NAME_LeadManagedByTwoEmployeeID, CurrentemployeeID.ToString(), SQLMatchType.Equal);
String fe7 = SqlExpressionBuilder.PrepareFilterExpression("CRMLandBasicInfo." + CRMLandBasicInfoEntity.FLD_NAME_ReferredByEmployeeID, CurrentemployeeID.ToString(), SQLMatchType.Equal);
String fe5 = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.OR, fe2);
String fe6 = SqlExpressionBuilder.PrepareFilterExpression(fe3, SQLJoinType.OR, fe4);
String fe = SqlExpressionBuilder.PrepareFilterExpression(fe5, SQLJoinType.OR, fe6);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.OR, fe7);
e.InputParameters["filterExpression"] = fe;
}
