public static List <IJobBL> GetExportBLForListing(SearchCriteria searchCriteria)
{
string strExecution = "[fwd].[usp_GetFwdBLForListing]";
List <IJobBL> lstBL = new List <IJobBL>();
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddVarcharParam("@JobNumber", 100, searchCriteria.JobNo);
oDq.AddVarcharParam("@BLNo", 100, searchCriteria.EdgeBLNumber);
oDq.AddVarcharParam("@POL", 100, searchCriteria.POL);
oDq.AddVarcharParam("@Line", 100, searchCriteria.LineName);
oDq.AddVarcharParam("@Location", 100, searchCriteria.Location);
oDq.AddIntegerParam("@Status", searchCriteria.IntegerOption1);
oDq.AddVarcharParam("@SortExpression", 100, searchCriteria.SortExpression);
oDq.AddVarcharParam("@SortDirection", 100, searchCriteria.SortDirection);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
IJobBL bl = new JobBLEntity(reader);
lstBL.Add(bl);
}
reader.Close();
}
return(lstBL);
}
public static IJobBL GetExportBLHeaderInfoForEdit(string BLNo)
{
string strExecution = "[fwd].[usp_GetJobBLForEdit]";
IJobBL objHeader = new JobBLEntity();
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddVarcharParam("@BLNumber", 50, BLNo);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
objHeader = new JobBLEntity(reader);
}
reader.Close();
}
return(objHeader);
}
