public static List <ATTInvDeliveryOrderDetail> SrchDeliveryOrder(ATTInvSrchDeliveryOrder objSrchDo)
{
try
{
List <ATTInvDeliveryOrderDetail> lst = new List <ATTInvDeliveryOrderDetail>();
foreach (DataRow row in DLLInvSrchDeliveryOrder.SrchDeliveryOrder(objSrchDo).Rows)
{
ATTInvDeliveryOrderDetail obj = new ATTInvDeliveryOrderDetail();
obj.OrgID = int.Parse(row["ORG_ID"].ToString());
obj.OrderNo = row["ORDER_NO"].ToString();
obj.ItemsCategoryID = int.Parse(row["ITEMS_CATEGORY_ID"].ToString());
obj.ItemsCategoryName = row["ITEMS_CATEGORY_NAME"].ToString();
obj.ItemsSubCategoryID = int.Parse(row["ITEMS_SUB_CATEGORY_ID"].ToString());
obj.ItemsSubCategoryName = row["ITEMS_SUB_CATEGORY_NAME"].ToString();
obj.ItemsID = int.Parse(row["ITEMS_ID"].ToString());
obj.ItemsName = row["ITEMS_NAME"].ToString();
obj.RequiredQty = int.Parse(row["TOTAL_QUANTITY"].ToString());
obj.DeliveredQty = row["TOTAL_DELIVERED"].ToString() == "" ? 0 : int.Parse(row["TOTAL_DELIVERED"].ToString());
obj.ApproveDate = row["app_date"].ToString();
obj.SeqNo = int.Parse(row["SEQ_NO"].ToString());
lst.Add(obj);
}
return(lst);
}
catch (Exception ex)
{
throw (ex);
}
}
public static List <ATTInvDeliveryOrderDetail> DeliveredOrderDetail(ATTInvDeliveryOrder objDo)
{
try
{
List <ATTInvDeliveryOrderDetail> lst = new List <ATTInvDeliveryOrderDetail>();
DataTable tbl = new DataTable();
tbl = DLLInvSrchDeliveryOrder.DeliveredOrderDetail(objDo);
foreach (DataRow row in tbl.Rows)
{
ATTInvDeliveryOrderDetail obj = new ATTInvDeliveryOrderDetail();
obj.OrgID = int.Parse(row["ORG_ID"].ToString());
//obj.UnitID = int.Parse(row["UNIT_ID"].ToString());
obj.OrderNo = row["ORDER_NO"].ToString();
obj.DeliverySeq = int.Parse(row["DELIVERY_SEQ"].ToString());
obj.ItemsCategoryID = int.Parse(row["ITEMS_CATEGORY_ID"].ToString());
obj.ItemsCategoryName = row["ITEMS_CATEGORY_NAME"].ToString();
obj.ItemsSubCategoryID = int.Parse(row["ITEMS_SUB_CATEGORY_ID"].ToString());
obj.ItemsSubCategoryName = row["ITEMS_SUB_CATEGORY_NAME"].ToString();
obj.ItemsID = int.Parse(row["ITEMS_ID"].ToString());
obj.ItemsName = row["ITEMS_NAME"].ToString();
obj.DeliveredQty = row["total_delivered"].ToString() == "" ? 0 : int.Parse(row["total_delivered"].ToString());
obj.ReturnedQty = row["total_returned"].ToString() == "" ? 0 : int.Parse(row["total_returned"].ToString());
obj.SeqNo = int.Parse(row["SEQ_NO"].ToString());
lst.Add(obj);
}
return(lst);
}
catch (Exception ex)
{
throw (ex);
}
}
public static List <ATTInvDeliveryOrder> SrchDeliveredOrder(ATTInvSrchDeliveryOrder objSrchDo)
{
try
{
List <ATTInvDeliveryOrder> lst = new List <ATTInvDeliveryOrder>();
DataTable tbl = new DataTable();
tbl = DLLInvSrchDeliveryOrder.SrchDeliveredOrder(objSrchDo);
foreach (DataRow row in tbl.Rows)
{
ATTInvDeliveryOrder obj = new ATTInvDeliveryOrder();
obj.OrgID = int.Parse(row["ORG_ID"].ToString());
obj.OrderNo = row["ORDER_NO"].ToString();
obj.DeliverySeq = int.Parse(row["DELIVERY_SEQ"].ToString());
obj.DeliveryPerson = row["DELIVERY_PERSON"].ToString();
obj.DeliveryDate = row["DELIVERY_DATE"].ToString();
obj.ReceiverID = int.Parse(row["RCVD_BY"].ToString());
obj.ReceiverName = row["FIRST_NAME"].ToString() +
(row["MID_NAME"].ToString() == "" ? "" : " " + row["MID_NAME"].ToString()) +
(row["SUR_NAME"].ToString() == "" ? "" : " " + row["SUR_NAME"].ToString());
obj.ReceivedDate = row["RCVD_DATE"].ToString();
obj.InvoiceNo = row["INVOICE_NO"].ToString();
lst.Add(obj);
}
return(lst);
}
catch (Exception ex)
{
throw(ex);
}
}
