public static List <IDeliveryOrder> GetDeliveryOrder(SearchCriteria searchCriteria, int userId)
{
string strExecution = "[exp].[uspGetDOList]";
List <IDeliveryOrder> lstDO = new List <IDeliveryOrder>();
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddIntegerParam("@UserId", userId);
oDq.AddVarcharParam("@SchBookingNo", 50, searchCriteria.BookingNo);
oDq.AddVarcharParam("@SchDONo", 50, searchCriteria.DONumber);
oDq.AddVarcharParam("@SchLocation", 50, searchCriteria.Location);
oDq.AddVarcharParam("@SchLine", 50, searchCriteria.LineName);
oDq.AddVarcharParam("@SchBookingRef", 50, searchCriteria.BookingRef);
oDq.AddVarcharParam("@SortExpression", 50, searchCriteria.SortExpression);
oDq.AddVarcharParam("@SortDirection", 4, searchCriteria.SortDirection);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
IDeliveryOrder deliveryOrder = new DeliveryOrderEntity(reader);
lstDO.Add(deliveryOrder);
}
reader.Close();
}
return(lstDO);
}
protected void btnPrint_Click(object sender, EventArgs e)
{
if (ValidateData())
{
List <DeliveryOrderContainerEntity> lstContainer = new List <DeliveryOrderContainerEntity>();
IDeliveryOrder deliveryOrder = new DeliveryOrderEntity();
BuildDeliveryOrderEntity(deliveryOrder);
BuildContainerEntity(lstContainer);
DoSave(deliveryOrder, lstContainer);
LoadContainerList();
_isEditable = false;
LockControls(true);
GenerateReport(deliveryOrder.DeliveryOrderId);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (ValidateData())
{
List <DeliveryOrderContainerEntity> lstContainer = new List <DeliveryOrderContainerEntity>();
IDeliveryOrder deliveryOrder = new DeliveryOrderEntity();
BuildDeliveryOrderEntity(deliveryOrder);
BuildContainerEntity(lstContainer);
DoSave(deliveryOrder, lstContainer);
LoadContainerList();
_isEditable = false;
LockControls(true);
Response.Redirect("~/Export/DOList.aspx");
}
}
