public static List <IDeliveryOrderContainer> GetDeliveryOrderContriner(Int64 bookingId, int emptyYardId, int StockOrLease, Int32 LeaseID)
{
string strExecution = "[exp].[uspGetContainerForDO]";
List <IDeliveryOrderContainer> lstCntr = new List <IDeliveryOrderContainer>();
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddBigIntegerParam("@BookingId", bookingId);
oDq.AddIntegerParam("@EmptyYardId", emptyYardId);
oDq.AddIntegerParam("@StockOrLease", StockOrLease);
oDq.AddIntegerParam("@LeaseID", LeaseID);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
IDeliveryOrderContainer container = new DeliveryOrderContainerEntity(reader);
lstCntr.Add(container);
}
reader.Close();
}
return(lstCntr);
}
private void BuildContainerEntity(List <DeliveryOrderContainerEntity> lstContainer)
{
for (int index = 0; index < gvwList.Rows.Count; index++)
{
HiddenField hdnBookingCntrId = (HiddenField)gvwList.Rows[index].Cells[0].FindControl("hdnBookingCntrId");
HiddenField hdnTypeId = (HiddenField)gvwList.Rows[index].Cells[0].FindControl("hdnTypeId");
HiddenField hdnSize = (HiddenField)gvwList.Rows[index].Cells[0].FindControl("hdnSize");
HiddenField hdnAvlUnit = (HiddenField)gvwList.Rows[index].Cells[0].FindControl("hdnAvlUnit");
HiddenField hdnBookingUnit = (HiddenField)gvwList.Rows[index].Cells[0].FindControl("hdnBookingUnit");
CustomTextBox txtReqUnit = (CustomTextBox)gvwList.Rows[index].Cells[4].FindControl("txtReqUnit");
if (!ReferenceEquals(hdnTypeId, null) && !ReferenceEquals(hdnSize, null) && !ReferenceEquals(txtReqUnit, null))
{
Int64 bookingCntrId = 0;
int containerTypeId = 0;
int availableUnit = 0;
int requiredUnit = 0;
int bookingUnit = 0;
Int64.TryParse(hdnBookingCntrId.Value.Trim(), out bookingCntrId);
int.TryParse(hdnTypeId.Value.Trim(), out containerTypeId);
int.TryParse(hdnAvlUnit.Value.Trim(), out availableUnit);
int.TryParse(hdnBookingUnit.Value.Trim(), out bookingUnit);
int.TryParse(txtReqUnit.Text.Trim(), out requiredUnit);
DeliveryOrderContainerEntity container = new DeliveryOrderContainerEntity();
container.BookingContainerId = bookingCntrId;
container.ContainerTypeId = containerTypeId;
container.ContainerSize = hdnSize.Value.Trim();
container.AvailableUnit = availableUnit;
container.BookingUnit = bookingUnit;
container.RequiredUnit = requiredUnit;
lstContainer.Add(container);
}
}
}
