public static List <IAdvAdj> GetAdvAdj(SearchCriteria searchCriteria)
{
string strExecution = "[fwd].[uspGetAdvAdj]";
List <IAdvAdj> lstAdvAdj = new List <IAdvAdj>();
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddIntegerParam("@AdvAdjId", searchCriteria.AdvAdjID);
oDq.AddVarcharParam("@SchAdvanceNo", 100, searchCriteria.AdvanceNo);
oDq.AddVarcharParam("@SchPartyName", 100, searchCriteria.PartyName);
oDq.AddVarcharParam("@SchPartyName", 100, searchCriteria.PartyType);
oDq.AddVarcharParam("@SortExpression", 50, searchCriteria.SortExpression);
oDq.AddVarcharParam("@SortDirection", 4, searchCriteria.SortDirection);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
IAdvAdj oLine = new AdvAdjEntity(reader);
lstAdvAdj.Add(oLine);
}
reader.Close();
}
return(lstAdvAdj);
}
public static IAdvAdj GetAdvAdj(int ID)
{
string strExecution = "[fwd].[uspGetLine]";
IAdvAdj oIH = null;
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddIntegerParam("@AdvAdjId", ID);
oDq.AddVarcharParam("@SortExpression", 30, "");
oDq.AddVarcharParam("@SortDirection", 4, "");
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
oIH = new AdvAdjEntity(reader);
}
reader.Close();
}
return(oIH);
}
