public byte[] FileSearch(string where, string whereContact, string whereCaseStatus, bool includeXrefs)
{
DataSet ds = this.ExecuteDataset("FileSearchXref", where, whereContact, whereCaseStatus, includeXrefs);
ds.RemotingFormat = SerializationFormat.Binary;
ds.Tables[0].RemotingFormat = SerializationFormat.Binary;
appDB.EFileSearchDataTable dt = new appDB.EFileSearchDataTable();
dt.Merge(ds.Tables[0]);
dt.RemotingFormat = this.RemotingFormat;
return(CompressData(dt));
}
public byte[] FileSearch(string userName, DateTime dateStart, DateTime dateEnd)
{
DataSet ds = this.ExecuteDataset("FileSearchRecentFiles", userName, dateStart, dateEnd);
ds.RemotingFormat = SerializationFormat.Binary;
ds.Tables[0].RemotingFormat = SerializationFormat.Binary;
appDB.EFileSearchDataTable dt = new appDB.EFileSearchDataTable();
dt.Merge(ds.Tables[0]);
dt.RemotingFormat = this.RemotingFormat;
return(CompressData(dt));
}
public byte[] FileSearch(string search, string keyword, int officeId)
{
string spName;
switch (search)
{
case "ICASE":
spName = "FileSearchByICASENumber";
break;
case "ParentFile":
spName = "FileSearchFindParentFile";
break;
case "FileId":
spName = "FileSearchByFileId";
break;
case "ParentFileId":
spName = "FileSearchByParentFileId";
break;
case "SIN":
spName = "FileSearchBySIN";
break;
case "OfficeFileNum":
spName = "FileSearchByOfficeFileNum";
break;
case "LastName":
spName = "FileSearchByLastName";
break;
case "LastNameExact":
spName = "FileSearchByLastNameExact";
break;
case "FileNumber":
spName = "FileSearchByFileNumber";
break;
case "FullFileNumber":
spName = "FileSearchByFullFileNumber";
break;
case "FullFileName":
spName = "FileSearchByFullFileName";
break;
default:
spName = "FileSearchByKeyword";
break;
}
// DataSet ds=this.ExecuteDataset( spName, new SqlParameter("@keyword", keyword), new SqlParameter("@officeid",officeId));
DataSet ds = this.ExecuteDataset(spName, keyword, officeId);
ds.RemotingFormat = SerializationFormat.Binary;
ds.Tables[0].RemotingFormat = SerializationFormat.Binary;
// if(base.myTrans==null)
// ds=SqlHelper.ExecuteDataset(this.SqlCon, CommandType.StoredProcedure, spName, new SqlParameter("@keyword", keyword), new SqlParameter("@officeid",officeId));
// else
// ds=SqlHelper.ExecuteDataset(this.myTrans, CommandType.StoredProcedure, spName, new SqlParameter("@keyword", keyword), new SqlParameter("@officeid",officeId));
appDB.EFileSearchDataTable dt = new appDB.EFileSearchDataTable();
dt.Constraints.Clear();
dt.Merge(ds.Tables[0]);
dt.RemotingFormat = this.RemotingFormat;
return(CompressData(dt));
}
