//**************************************************************************
/// <Description>
/// Get the list of Delivery Schedule
/// Set the the Line field to automatically increased
/// </Description>
/// <Inputs>
///
/// </Inputs>
/// <Outputs>
/// DataSet
/// </Outputs>
/// <Returns>
/// DataSet
/// </Returns>
/// <Authors>
/// THIENHD
/// </Authors>
/// <History>
/// March, 9 2005
/// </History>
/// <Notes>
/// </Notes>
//**************************************************************************
public DataSet GetDeliverySchedule(int pintPurchaseOrderLineID)
{
PO_DeliveryScheduleDS objPO_DeliveryScheduleDS = new PO_DeliveryScheduleDS();
DataSet dsData = objPO_DeliveryScheduleDS.GetDeliverySchedule(pintPurchaseOrderLineID);
return(dsData);
}
public DataSet SearchDeliverySchedule(DateTime pdtmFromDate, DateTime pdtmToDate, int pintPOMasterID,
int pintCategoryID, string pstrProductID)
{
PO_DeliveryScheduleDS dsSchedule = new PO_DeliveryScheduleDS();
return(dsSchedule.SearchDeliverySchedule(pdtmFromDate, pdtmToDate, pintPOMasterID, pintCategoryID, pstrProductID));;
}
/// <summary>
/// Add new for case : Convert CPO to new PO
/// </summary>
/// <param name="pobjMasterVO"></param>
/// <param name="pdstDetail"></param>
/// <param name="pdstDelivery"></param>
///<author>TuanDM</author>
public void UpdatePOAndDelScheduleImmediate(object pobjMasterVO, System.Data.DataSet pdstDetail, DataSet pdstDelivery, ArrayList parlCPOIDs)
{
//Add Master and Get returning ID
PO_PurchaseOrderMasterDS dsPOMaster = new PO_PurchaseOrderMasterDS();
dsPOMaster.Update(pobjMasterVO);
var voMaster = (PO_PurchaseOrderMasterVO)pobjMasterVO;
//Update detail
DataSet dstPODetail = pdstDetail.Copy();
PO_PurchaseOrderDetailDS dsPODetail = new PO_PurchaseOrderDetailDS();
foreach (DataRow drowDetail in pdstDetail.Tables[0].Rows)
{
if (drowDetail.RowState == DataRowState.Added)
{
drowDetail[PO_PurchaseOrderDetailTable.PURCHASEORDERMASTERID_FLD] = ((PO_PurchaseOrderMasterVO)pobjMasterVO).PurchaseOrderMasterID;
}
}
dsPODetail.UpdateDataSet(pdstDetail);
//Get PODetail DataSet which includes PURCHASEORDERDETAILID_FLD
pdstDetail = dsPODetail.ListToGetID(((PO_PurchaseOrderMasterVO)pobjMasterVO).PurchaseOrderMasterID);
//Create DeliverySchedule -- and add DeliverySchedule
int intPOLineID = 0;
PO_DeliveryScheduleDS dsDelivery = new PO_DeliveryScheduleDS();
for (int i = 0; i < dstPODetail.Tables[0].Rows.Count; i++)
{
DataRow[] drowSameDelivery = pdstDelivery.Tables[0].Select(ITM_ProductTable.PRODUCTID_FLD + "='" + dstPODetail.Tables[0].Rows[i][ITM_ProductTable.PRODUCTID_FLD].ToString() + "'");
intPOLineID = (int)pdstDetail.Tables[0].Select(PO_PurchaseOrderDetailTable.LINE_FLD + "='" + dstPODetail.Tables[0].Rows[i][PO_PurchaseOrderDetailTable.LINE_FLD].ToString() + "'")[0][PO_PurchaseOrderDetailTable.PURCHASEORDERDETAILID_FLD];
DataSet dstNewDelPO = dsDelivery.GetDeliverySchedule(intPOLineID);
int intbaseCount = dstNewDelPO.Tables[0].Rows.Count;
for (int j = 0; j < drowSameDelivery.Length; j++)
{
int k = GetIndexForDeliveryLine(dstNewDelPO, (DateTime)drowSameDelivery[j][PO_DeliveryScheduleTable.SCHEDULEDATE_FLD]);
if (k > -1)
{
dstNewDelPO.Tables[0].Rows[k][PO_DeliveryScheduleTable.DELIVERYQUANTITY_FLD] = (decimal)dstNewDelPO.Tables[0].Rows[k][PO_DeliveryScheduleTable.DELIVERYQUANTITY_FLD] + (decimal)drowSameDelivery[j][PO_DeliveryScheduleTable.DELIVERYQUANTITY_FLD];
}
else
{
drowSameDelivery[j][PO_DeliveryScheduleTable.PURCHASEORDERDETAILID_FLD] = intPOLineID;
drowSameDelivery[j][PO_DeliveryScheduleTable.DELIVERYLINE_FLD] = j + 1 + intbaseCount;
dstNewDelPO.Tables[0].ImportRow(drowSameDelivery[j]);
}
}
dsDelivery.UpdateDataSet(dstNewDelPO);
}
//Update CPODetail
MTR_CPODS dsCPO = new MTR_CPODS();
dsCPO.SetPOMasterID(parlCPOIDs, ((PO_PurchaseOrderMasterVO)pobjMasterVO).PurchaseOrderMasterID);
}
/// <summary>
/// Delete purchase order of estimate month
/// </summary>
/// <param name="pdtmFromDate">From Date</param>
/// <param name="pdtmToDate">To Date</param>
/// <param name="pintPOType">Purchase Type</param>
/// <param name="pstrVendorID">Vendor List</param>
/// <param name="pstrItemID">Item list</param>
public void DeleteEstimatePO(DateTime pdtmFromDate, DateTime pdtmToDate, int pintPOType, string pstrVendorID, string pstrItemID)
{
PO_PurchaseOrderMasterDS dsMaster = new PO_PurchaseOrderMasterDS();
// get list of purchase order master ID to be delete
DataTable dtbMaster = dsMaster.ListMasterToDelete(pdtmFromDate, pdtmToDate, pintPOType, pstrItemID, pstrItemID).Tables[0];
string strMasterId = dtbMaster.Rows.Cast <DataRow>().Aggregate("0", (current, drowMaster) => current + ("," + drowMaster[PO_PurchaseOrderMasterTable.PURCHASEORDERMASTERID_FLD]));
// delete delivery schedule first
PO_DeliveryScheduleDS dsSchedule = new PO_DeliveryScheduleDS();
dsSchedule.DeleteByPOMaster(strMasterId);
// delete purchase order detail
PO_PurchaseOrderDetailDS dsDetail = new PO_PurchaseOrderDetailDS();
dsDetail.DeleteByMaster(strMasterId);
// delete purchase order master
dsMaster.Delete(strMasterId);
}
public void UpdateDelivery(string pstrCancelList, string pstrApprovedList)
{
PO_DeliveryScheduleDS dsSchedule = new PO_DeliveryScheduleDS();
dsSchedule.UpdateDelivery(pstrCancelList, pstrApprovedList);
}
public void UpdateDataSet(System.Data.DataSet dstData)
{
PO_DeliveryScheduleDS dsSchedule = new PO_DeliveryScheduleDS();
dsSchedule.UpdateCancelDelivery(dstData);
}
/// <summary>
/// Gets total schedule delivery quantity of a po line
/// </summary>
/// <param name="pintPODetailID">PurchaseOrderDetail ID</param>
/// <returns>Total Schedule Delivery Quantity</returns>
public decimal GetTotalDeliveryQuantityOfLine(int pintPODetailID)
{
PO_DeliveryScheduleDS dsSchedule = new PO_DeliveryScheduleDS();
return(dsSchedule.GetTotalDeliveryQuantityOfLine(pintPODetailID));
}
//**************************************************************************
/// <Description>
/// Update Delivery Schedule - DataSet
/// </Description>
/// <Inputs>
///
/// </Inputs>
/// <Outputs>
/// DataSet
/// </Outputs>
/// <Returns>
/// DataSet
/// </Returns>
/// <Authors>
/// THIENHD
/// </Authors>
/// <History>
/// March, 9 2005
/// </History>
/// <Notes>
/// </Notes>
//**************************************************************************
public void UpdateDeliveryDataSet(DataSet pdstDeliverySchedule, int pintPurchaseOrderDetailID)
{
PO_DeliveryScheduleDS objPO_DeliveryScheduleDS = new PO_DeliveryScheduleDS();
objPO_DeliveryScheduleDS.UpdateDataSet(pdstDeliverySchedule);
}
//**************************************************************************
/// <Description>
/// Delete all delivery schedule
/// </Description>
/// <Inputs>
///
/// </Inputs>
/// <Outputs>
/// DataSet
/// </Outputs>
/// <Returns>
/// DataSet
/// </Returns>
/// <Authors>
/// THIENHD
/// </Authors>
/// <History>
/// March, 9 2005
/// </History>
/// <Notes>
/// </Notes>
//**************************************************************************
public void DeleteDeliveryDetail(int pintPurchaseOrderLineID)
{
PO_DeliveryScheduleDS objPO_DeliveryScheduleDS = new PO_DeliveryScheduleDS();
objPO_DeliveryScheduleDS.DeleteDeliveryDetail(pintPurchaseOrderLineID);
}
public void UpdateInsertedRowInDataSet(DataSet pdstDelSchData, int pintMasterID)
{
PO_DeliveryScheduleDS dsSchedule = new PO_DeliveryScheduleDS();
dsSchedule.UpdateInsertedRowInDataSet(pdstDelSchData, pintMasterID);
}
public void UpdateDeletedRowInDataSet(DataSet pdstDelSchData, int pintPOMasterID)
{
PO_DeliveryScheduleDS dsDelSch = new PO_DeliveryScheduleDS();
dsDelSch.UpdateDeletedRowInDataSet(pdstDelSchData, pintPOMasterID);
}
public void UpdateScheduleForImport(DataSet pdstData)
{
PO_DeliveryScheduleDS dsDelivery = new PO_DeliveryScheduleDS();
dsDelivery.UpdateDataSet(pdstData);
}
public DataSet ListScheduleForImport(int pintMasterID)
{
PO_DeliveryScheduleDS dsDelivery = new PO_DeliveryScheduleDS();
return(dsDelivery.ListForImport(pintMasterID));
}
/// <summary>
/// Add new for case : Convert CPO to new PO
/// </summary>
/// <param name="pobjMasterVO"></param>
/// <param name="pdstDetail"></param>
/// <param name="pdstDelivery"></param>
///<author>TuanDM</author>
public int AddPOAndDelScheduleImmediate(object pobjMasterVO, System.Data.DataSet pdstDetail, DataSet pdstDelivery, ArrayList parlCPOIDs)
{
//Add Master and Get returning ID
PO_PurchaseOrderMasterDS dsPOMaster = new PO_PurchaseOrderMasterDS();
int intMasterID = dsPOMaster.AddAndReturnID(pobjMasterVO);
//Add detail
foreach (DataRow drowDetail in pdstDetail.Tables[0].Rows)
{
drowDetail[PO_PurchaseOrderDetailTable.PURCHASEORDERMASTERID_FLD] = intMasterID;
}
PO_PurchaseOrderDetailDS dsPODetail = new PO_PurchaseOrderDetailDS();
dsPODetail.UpdateDataSet(pdstDetail);
//Get PODetail DataSet which includes PURCHASEORDERDETAILID_FLD
pdstDetail = dsPODetail.ListToGetID(intMasterID);
//Create DeliverySchedule -- and add DeliverySchedule
int intPOLineID = 0;
int i = 0;
PO_DeliveryScheduleDS dsDelivery = new PO_DeliveryScheduleDS();
while (i++ < pdstDetail.Tables[0].Rows.Count)
{
DataSet dstNewDelPO = pdstDelivery.Clone();
DataRow[] drowSameDelivery = pdstDelivery.Tables[0].Select(ITM_ProductTable.PRODUCTID_FLD + "='" + pdstDetail.Tables[0].Rows[i - 1][ITM_ProductTable.PRODUCTID_FLD].ToString() + "'");
intPOLineID = (int)pdstDetail.Tables[0].Rows[i - 1][PO_DeliveryScheduleTable.PURCHASEORDERDETAILID_FLD];
foreach (DataRow t in drowSameDelivery)
{
int k = GetIndexForDeliveryLine(dstNewDelPO, (DateTime)t[PO_DeliveryScheduleTable.SCHEDULEDATE_FLD]);
if (k > -1)
{
dstNewDelPO.Tables[0].Rows[k][PO_DeliveryScheduleTable.DELIVERYQUANTITY_FLD] = (decimal)dstNewDelPO.Tables[0].Rows[k][PO_DeliveryScheduleTable.DELIVERYQUANTITY_FLD] + (decimal)t[PO_DeliveryScheduleTable.DELIVERYQUANTITY_FLD];
t[PO_DeliveryScheduleTable.PURCHASEORDERDETAILID_FLD] = intPOLineID;
}
else
{
t[PO_DeliveryScheduleTable.PURCHASEORDERDETAILID_FLD] = intPOLineID;
t[PO_DeliveryScheduleTable.DELIVERYLINE_FLD] = dstNewDelPO.Tables[0].Rows.Count + 1;
dstNewDelPO.Tables[0].ImportRow(t);
}
}
dsDelivery.UpdateDataSet(dstNewDelPO);
}
//Update CPODetail
MTR_CPODS dsCPO = new MTR_CPODS();
if (parlCPOIDs.Count > 0)
{
if (Convert.ToInt32(parlCPOIDs[0]) > 0)
{
dsCPO.SetPOMasterID(parlCPOIDs, intMasterID);
}
else
{
dsCPO.SetPOMasterIDForDCPDetail(parlCPOIDs, intMasterID);
}
}
return(intMasterID);
}
