private DM_CentralizedFSManager.FileLink[] GetFileLinks(int ws_pcpo_id)
{
DM_CentralizedFSManager.FileLink[] fileLinks = new DM_CentralizedFSManager.FileLink[] {
new DM_CentralizedFSManager.FileLink("WS_PCPO_Hdr.ws_pcpo_id", ws_pcpo_id, _HMCon.CompanyID, DM_CentralizedFSManager.FileLink.Database.TR, 0, true)
};
return(fileLinks);
}
private DM_CentralizedFSManager.FileLink[] GetFileLinks(int po_id)
{
DM_CentralizedFSManager.FileLink[] fileLinks = new DM_CentralizedFSManager.FileLink[] {
new DM_CentralizedFSManager.FileLink("PO_HEADER.po_id", po_id, Connection.CompanyID, DM_CentralizedFSManager.FileLink.Database.TR, 0, true)
};
return(fileLinks);
}
private void ClearFields()
{
deInvDate.EditValue = null;
deDueDate.EditValue = null;
txtSupp.EditValue = null;
txtInvNo.EditValue = null;
txtName.EditValue = null;
txtGST.EditValue = null;
txtPST.EditValue = null;
txtInvAmt.EditValue = null;
txtPurAmt.EditValue = null;
txtGSTAmt.EditValue = null;
txtPO.EditValue = null;
lueWHSE.EditValue = null;
txtHoldbackAmt.EditValue = null;
deHoldbackDate.EditValue = null;
lueGST.EditValue = null;
txtPOAmt.EditValue = null;
txtReference.EditValue = null;
memoComment.EditValue = null;
txtTerms.EditValue = null;
txtPOSupplyType.EditValue = null;
txtProject.EditValue = null;
txtSubmitted.EditValue = null;
txtApproved.EditValue = null;
txtPaidToDate.EditValue = null;
txtRemaining.EditValue = null;
txtPaymentStatus.EditValue = null;
if (_USE_DM)
{
if (FileMgr != null)
{
FileLinks[0] = new DM_CentralizedFSManager.FileLink("WS_INV_HEADER.WS_INV_ID", -1, Connection.CompanyID, DM_CentralizedFSManager.FileLink.Database.TR, 0, true);
FileMgr.DocumentFileLink = FileLinks;
}
}
else
{
if (CFS_FileMgr != null)
{
CFS_FileMgr.RefreshFileList(RelType, -1, true);
}
}
}
private void LoadHeader(int DetailID)
{
ClearFields();
string sSelect = @"select w.INV_DATE, w.DUE_DATE, w.SUPPLIER, w.SUPP_NAME, w.CON_INV_NO, g.GST_DESC, s.DESCRIPTION, w.INV_AMOUNT,
w.PURCH_AMT, w.GST_AMT, p.PO, w.WHSE_ID, w.REFERENCE, w.COMMENT, isnull(w.pri_id,-1) [PriID], w.GST_CODE,
isnull((select isnull(sum(isnull(pd.EXTENSION,0)),0) from po_detail pd where pd.po_id=w.po_id),0) [PO_AMT],
t.DESCRIPTION [TERMS], st.Description [SUPPLYTYPE],
'('+CAST(ph.pri_code as varchar(15))+') - '+ph.pri_name [Project], isnull(w.Submitted,0) [Submitted],
isnull(w.Approved,0) [Approved], isnull(w.PaidToDate,0) [PaidToDate], isnull(w.Remaining,0) [Remaining]
from WS_INV_HEADER w
left outer join GST_CODES g on w.GST_CODE=g.GST_CODE
left outer join SALES_TAXES s on w.SALES_TAX_ID=s.SALES_TAX_ID
left outer join PO_HEADER p on w.PO_ID=p.PO_ID
left outer join TERMS t on t.TERMS_ID=p.TERMS_ID
left outer join PO_SupplyType st on st.PO_SupplyType_ID=p.PO_SupplyType_ID
left outer join PROJ_HEADER ph on ph.pri_id=w.pri_id
where w.WS_INV_ID = " + DetailID;
DataTable dt = Connection.SQLExecutor.ExecuteDataAdapter(sSelect, Connection.TRConnection);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
if (dr != null)
{
lueGST.EditValue = dr["GST_CODE"];
deInvDate.EditValue = dr["INV_DATE"];
deDueDate.EditValue = dr["DUE_DATE"];
txtSupp.EditValue = dr["SUPPLIER"];
txtName.EditValue = dr["SUPP_NAME"];
txtInvNo.EditValue = dr["CON_INV_NO"];
txtGST.EditValue = dr["GST_DESC"];
txtPST.EditValue = dr["DESCRIPTION"];
txtInvAmt.EditValue = dr["INV_AMOUNT"];
txtPurAmt.EditValue = dr["PURCH_AMT"];
txtGSTAmt.EditValue = dr["GST_AMT"];
txtPO.EditValue = dr["PO"];
lueWHSE.EditValue = dr["WHSE_ID"];
txtReference.EditValue = dr["REFERENCE"];
memoComment.EditValue = dr["COMMENT"];
txtPOAmt.EditValue = dr["PO_AMT"];
object oPriID = dr["PriID"];
sSelect = "select pri_holdback_date from proj_header where pri_id=" + oPriID;
deHoldbackDate.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);
txtTerms.EditValue = dr["TERMS"];
txtPOSupplyType.EditValue = dr["SUPPLYTYPE"];
txtProject.EditValue = dr["Project"];
txtSubmitted.EditValue = Convert.ToDouble(dr["Submitted"]) + Convert.ToDouble(dr["PURCH_AMT"]);
txtApproved.EditValue = dr["Approved"];
txtPaidToDate.EditValue = dr["PaidToDate"];
double dRemaining = Convert.ToDouble(dr["Remaining"]) - Convert.ToDouble(dr["PURCH_AMT"]);
txtRemaining.EditValue = dRemaining;
object oPurchAmt = dr["PURCH_AMT"];
if (oPurchAmt == null || oPurchAmt == DBNull.Value)
{
oPurchAmt = 0;
}
double dPurchAmt = Convert.ToDouble(oPurchAmt);
object oPO_AMT = dr["PO_AMT"];
if (oPO_AMT == null || oPO_AMT == DBNull.Value)
{
oPO_AMT = 0;
}
double dPO_AMT = Convert.ToDouble(oPO_AMT);
if (dRemaining < 0)
{
txtPaymentStatus.EditValue = "OVER PAYMENT";
this.txtPaymentStatus.Properties.Appearance.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Bold);
txtPaymentStatus.ForeColor = Color.Red;
}
else if (dRemaining > 0)
{
txtPaymentStatus.EditValue = "UNDER PAYMENT";
this.txtPaymentStatus.Properties.Appearance.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Regular);
txtPaymentStatus.ForeColor = Color.Black;
}
else
{
txtPaymentStatus.EditValue = "COMPLETE PAYMENT";
this.txtPaymentStatus.Properties.Appearance.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Regular);
txtPaymentStatus.ForeColor = Color.Black;
}
}
}
}
sSelect = "select SUM(ISNULL(hold_amt,0)) from WS_INV_DET where WS_INV_ID=" + DetailID;
txtHoldbackAmt.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);
if (_USE_DM)
{
FileLinks[0] = new DM_CentralizedFSManager.FileLink("WS_INV_HEADER.WS_INV_ID", _DetailID, Connection.CompanyID, DM_CentralizedFSManager.FileLink.Database.TR, 0, true);
FileMgr.DocumentFileLink = FileLinks;
}
else
{
CFS_FileMgr.RefreshFileList(RelType, _DetailID, true);
}
RefreshSubmissionDetails(_DetailID);
RefreshChatThread(_DetailID);
}
