public void PopulateData(int invoiceID)
{
rsInvoiceHead = Invoice_CN.GetInvoiceHead(invoiceID);
rsInvoiceDetail = Invoice_CN.GetInvoiceDetail(invoiceID);
PopulateData();
}
public void PopulateData(int invoiceID)
{
rsInvoiceHead = Invoice_CN.GetInvoiceHead(invoiceID);
rsInvoiceDetail = Invoice_CN.GetInvoiceDetail(invoiceID);
lblConfirmation.Visible = false;
btnConfirmInvoice.Visible = false;
btnGeneratePDF.Visible = true;
PopulateData();
}
private void CopyFile(string iInvoiceID)
{
string sFname = "";
string strFname = "";
try
{
sFname = Session["InvoiceDoc_CN"].ToString();
strFname = sFname;
}
catch { }
if (sFname.Trim() != "")
{
FileInfo fi = new FileInfo(Server.MapPath(ConfigurationManager.AppSettings["TempInvoicePath"]) + sFname);
string[] strFileNameArray = sFname.Split('^');
sFname = strFileNameArray[0];
if (fi.Exists)
{
fi.CopyTo(Server.MapPath(ConfigurationManager.AppSettings["InvoiceDocPath"]) + "\\" + iInvoiceID + "_" + sFname, true);
Invoice_CN objInvoice = new Invoice_CN();
objInvoice.UpdateInvoiceDocument(Convert.ToInt32(iInvoiceID.Trim()), iInvoiceID + "_" + sFname);
fi = null;
FileInfo fInfo = new FileInfo(Server.MapPath(ConfigurationManager.AppSettings["TempInvoicePath"]) + strFname.Trim());
if (fInfo.Exists)
{
fInfo.Delete();
fInfo = null;
}
}
}
}
// ==============================================================================================================
#region LoadDataAtLogin
private void LoadDataAtLogin(int iCompanyID, int iPassedToUserID)
{
try
{
Invoice_CN objInvoice = new Invoice_CN();
string strStatus = "";
string strUserName = "";
string strEmail = "";
CreateTable();
sqlConn = new SqlConnection(CBSAppUtils.PrimaryConnectionString);
sqlDA = new SqlDataAdapter("stpGetInvoiceDetailsAtLogin1NL_CN", sqlConn);
sqlDA.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlDA.SelectCommand.Parameters.Add("@CompanyID", DBNull.Value);
sqlDA.SelectCommand.Parameters.Add("@PassedToUserID", iPassedToUserID);
sqlDA.TableMappings.Add("CreditNoteDetail", "InvoiceHeader");
sqlDA.TableMappings.Add("CreditNoteDetail1", "InvoiceLog");
ds = new DataSet();
try
{
sqlDA.Fill(ds, "CreditNoteDetail");
}
catch (Exception ex) { string ss = ex.Message.ToString(); }
finally
{
sqlDA.Dispose();
sqlConn.Close();
}
ds.Relations.Add("InvoiceHeader_InvoiceHistory", ds.Tables["InvoiceHeader"].Columns["CreditNoteID"], ds.Tables["InvoiceLog"].Columns["CreditNoteID"]);
foreach (DataRow drInvoiceHeader in ds.Tables["InvoiceHeader"].Rows)
{
dr = objDataTable.NewRow();
dr["CreditNoteID"] = drInvoiceHeader["CreditNoteID"];
dr["ReferenceNo"] = drInvoiceHeader["ReferenceNo"];
dr["SupplierCode"] = drInvoiceHeader["SupplierCode"];
dr["Supplier"] = drInvoiceHeader["Supplier"];
dr["VendorID"] = drInvoiceHeader["VendorID"];
dr["InvoiceDate"] = drInvoiceHeader["InvoiceDate"];
dr["DeliveryDate"] = drInvoiceHeader["DeliveryDate"];
dr["Net"] = drInvoiceHeader["Net"];
dr["VAT"] = drInvoiceHeader["VAT"];
dr["Total"] = drInvoiceHeader["Total"];
// CURRENT STATUS
objInvoice.GetCurrentStatus(Convert.ToInt32(drInvoiceHeader["StatusID"]), out strStatus);
dr["DocStatus"] = strStatus;
dr["ActionStatus"] = drInvoiceHeader["ActionStatus"];
// USER NAME
objInvoice.GetUserName(Convert.ToInt32(drInvoiceHeader["ModUserID"]), out strUserName, out strEmail);
dr["User"] = strUserName;
dr["Comment"] = strUserName;
dr["ActionDate"] = drInvoiceHeader["ModDate"];
dr["DocAttachments"] = drInvoiceHeader["Document"];
dr["DocType"] = "INV";
dr["ParentRowFlag"] = "1";
if (drInvoiceHeader["BranchCode"] != DBNull.Value)
{
dr["BranchCode"] = drInvoiceHeader["BranchCode"];
}
objDataTable.Rows.Add(dr);
}
ViewState["objDataTable"] = objDataTable;
PopulateGrid();
CheckDuplicateValues();
}
catch { }
}
private void btnConfirmInvoice_Click(object sender, System.EventArgs e)
{
int BuyerID = System.Convert.ToInt32(rsInvoiceHead["BuyerCompanyID"]);
Invoice_CN invoice = new Invoice_CN();
dCreditNoteTotal = (Convert.ToDecimal(Session["NetTotalForCreditNote"]) + Convert.ToDecimal(txtVATAmt.Text.ToString()));
if (!invoice.CompareTotalAmount_CNWithInvoiceTotalAmount(Session["AssociateInvoiceNo"].ToString(), dCreditNoteTotal, BuyerID, Convert.ToInt32(Session["CompanyID"])))
{
lblMessage.Text = "Sorry, credit note amount is greater than the amount for this invoice.";
return;
}
//save the invoice head and detail data in a single transaction context
DataAccess da = new DataAccess(CBSAppUtils.PrimaryConnectionString);
da.BeginTransaction();
int invoicePKID = 0;
//save invoice head data
rsInvoiceHead["SupplierCompanyID"] = (int)Session["CompanyID"];
if (rsInvoiceHead["StatusID"] == DBNull.Value)
{
rsInvoiceHead["StatusID"] = 20;
}
invoicePKID = invoice.InsertInvoiceHeadData(rsInvoiceHead, da);
if (da.SPReturnValue == 2)
{
Session.Add("DuplicateInvoice_CN", "1");
da.RollbackTransaction();
rsInvoiceHead["StatusID"] = null;
Response.Redirect("InvoiceOtherInfo_CN.aspx");
}
if (invoicePKID > 0)
{
invoice.InsertInvoiceDetailData(invoicePKID, rsInvoiceDetail, da);
}
if (da.ErrorCode != DataAccessErrors.Successful)
{
da.RollbackTransaction();
rsInvoiceHead["StatusID"] = null;
Response.Write(da.ErrorMessage);
}
else
{
// CHECKING IF CURRENCY CODE IS NOT GBP.
if (Convert.ToInt32(rsInvoiceHead["CurrencyTypeID"]) != 22)
{
if (txtSterlingEquivalent.Text.Trim() == "")
{
lblMessage.Text = "Please enter the sterling equivalent vat amount because the currency code is not GBP.";
da.RollbackTransaction();
rsInvoiceHead["StatusID"] = null;
return;
}
else
{
if (IsNumericValue(txtSterlingEquivalent.Text.Trim()))
{
Session["StrVATAmt_CN"] = Math.Round(Convert.ToDouble(txtSterlingEquivalent.Text.Trim()), 2);
da.CommitTransaction();
rsInvoiceHead["StatusID"] = null;
}
else
{
lblMessage.Text = "Please enter a numeric value for sterling equivalent vat amount.";
da.RollbackTransaction();
rsInvoiceHead["StatusID"] = null;
return;
}
}
}
else
{
try
{
Session["StrVATAmt_CN"] = null;
da.CommitTransaction();
}
catch { }
}
if (Session["StrVATAmt_CN"] != null)
{
if (Utility.IsNumeric(Session["StrVATAmt_CN"].ToString().Trim()))
{
Session["StrVATAmt_CN"] = Convert.ToString(Math.Round(Convert.ToDouble(Session["StrVATAmt_CN"].ToString().Trim()), 2));
}
}
objInvoice.UpdateSterlingAmoutnIfCurrencyNotGBP(invoicePKID, Convert.ToDecimal(Session["StrVATAmt_CN"]));
if (txtVATAmt.Text.Trim() != null)
{
objInvoice.UpdateVATAmount(invoicePKID, Convert.ToDecimal(txtVATAmt.Text.Trim()));
}
CopyFile(invoicePKID.ToString());
Session["InvoiceID"] = invoicePKID;
objInvoice.UpdateInvoiceNoForCreditNote(invoicePKID, Session["CreditNoteInvoiceNo"].ToString());
hdSaveFlag.Value = "1";
hdHideBack.Value = "1";
}
}
public void PopulateData()
{
try
{
this.grdInvoiceDetails.DataSource = rsInvoiceDetail.ParentTable;
this.grdInvoiceDetails.DataBind();
lblCreditNoteno.Text = rsInvoiceHead["InvoiceNo"].ToString();
if (rsInvoiceHead["Document"] != DBNull.Value)
{
strInvoiceDocument = rsInvoiceHead["Document"].ToString();
}
if (rsInvoiceHead["New_ActivityCode"] != DBNull.Value)
{
lblActivityCode.Text = Convert.ToString(rsInvoiceHead["New_ActivityCode"]);
}
else
{
lblActivityCode.Text = "";
}
if (rsInvoiceHead["New_AccountCategory"] != DBNull.Value)
{
lblAccountCat.Text = Convert.ToString(rsInvoiceHead["New_AccountCategory"]);
}
else
{
lblAccountCat.Text = "";
}
if (rsInvoiceHead["PaymentDueDate"] != DBNull.Value)
{
lblPaymentDueDAte.Text = Convert.ToDateTime(rsInvoiceHead["PaymentDueDate"]).ToString("dd/MM/yyyy");
}
else
{
lblPaymentDueDAte.Text = "";
}
if (rsInvoiceHead["DiscountPercent"] != DBNull.Value)
{
lblTermsDiscount.Text = Convert.ToDouble(rsInvoiceHead["DiscountPercent"]).ToString("#0.00");
}
else
{
lblTermsDiscount.Text = "0";
}
if (rsInvoiceHead["New_SettlementPercent2"] != DBNull.Value)
{
lblSecondSettlementDiscount.Text = Convert.ToDouble(rsInvoiceHead["New_SettlementPercent2"]).ToString("#0.00");
}
else
{
lblSecondSettlementDiscount.Text = "0";
}
if (rsInvoiceHead["CustomerAccNo"] != DBNull.Value)
{
lblCustomerAccNo.Text = rsInvoiceHead["CustomerAccNo"].ToString();
}
if (rsInvoiceHead["New_InvoiceContact"] != DBNull.Value)
{
lblCustomerContactName.Text = rsInvoiceHead["New_InvoiceContact"].ToString();
}
if (rsInvoiceHead["New_SettlementDays1"] != DBNull.Value)
{
lblSettlementDays.Text = rsInvoiceHead["New_SettlementDays1"].ToString();
}
if (rsInvoiceHead["New_SettlementDays2"] != DBNull.Value)
{
lblSecondSettlementDays.Text = rsInvoiceHead["New_SettlementDays2"].ToString();
}
if (rsInvoiceHead["New_InvoiceName"] != DBNull.Value)
{
lblInvoiceName.Text = rsInvoiceHead["New_InvoiceName"].ToString();
}
try
{
JKS.Invoice oInvoice = new JKS.Invoice();
if (rsInvoiceHead["CurrencyTypeID"] != DBNull.Value)
{
lblCurrency.Text = oInvoice.GetCurrencyName(Convert.ToInt32(rsInvoiceHead["CurrencyTypeID"]));
}
}
catch { }
lblVATRegNo.Text = rsInvoiceHead["SellerVATNo"].ToString();
if (rsInvoiceHead["InvoiceDate"] != DBNull.Value)
{
lblInvoiceDate.Text = Convert.ToDateTime(rsInvoiceHead["InvoiceDate"]).ToString("dd/MM/yyyy");
}
else
{
lblInvoiceDate.Text = "";
}
lblPaymentTerms.Text = rsInvoiceHead["PaymentTerm"].ToString();
lblDespatchNoteNo.Text = rsInvoiceHead["DespatchNoteNo"].ToString();
if (rsInvoiceHead["DeliveryDate"] != DBNull.Value)
{
lblDespatchDate.Text = Convert.ToDateTime(rsInvoiceHead["DeliveryDate"]).ToString("dd/MM/yyyy");
}
else
{
lblDespatchDate.Text = "";
}
if (rsInvoiceHead["TaxPointDate"] != DBNull.Value)
{
lblTaxPointDate.Text = Convert.ToDateTime(rsInvoiceHead["TaxPointDate"]).ToString("dd/MM/yyyy");
}
else
{
lblTaxPointDate.Text = "";
}
lblNetTotal.Text = System.Convert.ToDouble(rsInvoiceHead["NetTotal"]).ToString("#0.00");
lblTotal.Text = System.Convert.ToDouble(rsInvoiceHead["TotalAmt"]).ToString("#0.00");
txtVATAmt.Text = System.Convert.ToDouble(rsInvoiceHead["VATAmt"]).ToString("#0.00");
lblVAT.Text = System.Convert.ToDouble(rsInvoiceHead["VATAmt"]).ToString("#0.00");
if (rsInvoiceHead["amountifnotgbpcurrency"] != DBNull.Value)
{
lblGBPEquiAmt.Text = System.Convert.ToDouble(rsInvoiceHead["amountifnotgbpcurrency"]).ToString("#0.00");
lblGBPEquiAmt.Visible = true;
}
string s = GetAddressLine(rsInvoiceHead["DeliveryAddress1"].ToString());
s += GetAddressLine(rsInvoiceHead["DeliveryAddress2"].ToString());
s += GetAddressLine(rsInvoiceHead["DeliveryAddress3"].ToString());
s += GetAddressLine(rsInvoiceHead["DeliveryAddress4"].ToString());
s += GetAddressLine(rsInvoiceHead["DeliveryAddress5"].ToString());
s += GetAddressLine(rsInvoiceHead["DeliveryCountry"].ToString());
s += GetAddressLine(rsInvoiceHead["DeliveryZIP"].ToString());
try
{
s = s.Substring(0, s.Length - 3);
}
catch { }
lblDeliveryAddress.Text = s;
if (rsInvoiceHead["New_OverallDiscountPercent"] != DBNull.Value)
{
lblOverAllDiscount.Text = rsInvoiceHead["New_OverallDiscountPercent"].ToString().Trim();
}
s = GetAddressLine(rsInvoiceHead["InvoiceAddress1"].ToString());
s += GetAddressLine(rsInvoiceHead["InvoiceAddress2"].ToString());
s += GetAddressLine(rsInvoiceHead["InvoiceAddress3"].ToString());
s += GetAddressLine(rsInvoiceHead["InvoiceAddress4"].ToString());
s += GetAddressLine(rsInvoiceHead["InvoiceAddress5"].ToString());
s += GetAddressLine(rsInvoiceHead["InvoiceCountry"].ToString());
s += GetAddressLine(rsInvoiceHead["InvoiceZIP"].ToString());
try
{
s = s.Substring(0, s.Length - 3);
}
catch { }
lblInvoiceAddress.Text = s;
if (rsInvoiceHead["New_PaymentDate"] != DBNull.Value)
{
lblpaymentdate.Text = System.Convert.ToDateTime(rsInvoiceHead["New_PaymentDate"]).ToString();
}
else
{
lblpaymentdate.Text = "";
}
if (rsInvoiceHead["New_DiscountGiven"] != DBNull.Value)
{
lblDiscount.Text = System.Convert.ToString(rsInvoiceHead["New_DiscountGiven"].ToString());
}
else
{
lblDiscount.Text = "";
}
if (rsInvoiceHead["New_PaymentMethod"] != DBNull.Value)
{
lblPaymentMethod.Text = System.Convert.ToString(rsInvoiceHead["New_PaymentMethod"].ToString());
}
else
{
lblPaymentMethod.Text = "";
}
s = GetAddressLine(rsInvoiceHead["SupplierAddress1"].ToString());
s += GetAddressLine(rsInvoiceHead["SupplierAddress2"].ToString());
s += GetAddressLine(rsInvoiceHead["SupplierAddress3"].ToString());
s += GetAddressLine(rsInvoiceHead["SupplierAddress4"].ToString());
s += GetAddressLine(rsInvoiceHead["SupplierAddress5"].ToString());
s += GetAddressLine(rsInvoiceHead["SupplierCountry"].ToString());
s += GetAddressLine(rsInvoiceHead["SupplierZIP"].ToString());
try
{
s = s.Substring(0, s.Length - 3);
}
catch { }
lblSupplierAddress.Text = s;
RecordSet rs = Company.GetCompanyData(System.Convert.ToInt32(rsInvoiceHead["SupplierCompanyID"]));
lblSupplier.Text = rs["CompanyName"].ToString();
rs = Company.GetCompanyData(System.Convert.ToInt32(rsInvoiceHead["BuyerCompanyID"]));
lblBuyer.Text = rs["CompanyName"].ToString();
if (rsInvoiceHead["StatusId"] != DBNull.Value)
{
lblStatus.Text = Invoice_CN.GetStatus((int)rsInvoiceHead["StatusId"]);
}
else
{
lblStatus.Text = "Pending";
}
if (rsInvoiceHead["StatusId"].ToString() == "6" || rsInvoiceHead["StatusId"].ToString() == "26" || rsInvoiceHead["StatusId"].ToString() == "25")
{
btnEdit.Visible = true;
}
else
{
btnEdit.Visible = false;
}
if (Request.QueryString["AllowEdit"] != null)
{
btnEdit.Visible = true;
}
else
{
btnEdit.Visible = false;
}
if (Convert.ToInt32(Session["UserTypeID"]) >= 2)
{
btnEdit.Visible = true;
}
else
{
btnEdit.Visible = false;
}
if (ViewState["INID"] != null)
{
Double dGBPEquivalentAmount = 0;
dGBPEquivalentAmount = objInvoice.GetGBPEquivalentAmount(Convert.ToInt32(ViewState["INID"]));
if (dGBPEquivalentAmount != 0)
{
lblGBPEquiAmt.Visible = true;
hdGBPEquiFlag.Value = "1";
lblGBPEquiAmt.Text = dGBPEquivalentAmount.ToString();
}
txtVATAmt.Visible = false;
lblVAT.Visible = true;
}
if (Session["StrVATAmt_CN"] != null)
{
lblGBPEquiAmt.Visible = true;
hdGBPEquiFlag.Value = "1";
lblGBPEquiAmt.Text = Session["StrVATAmt_CN"].ToString();
}
if (Convert.ToInt32(rsInvoiceHead["CurrencyTypeID"]) != 22 && Session["StrVATAmt_CN"] == null && ViewState["INID"] == null)
{
txtSterlingEquivalent.Visible = true;
trInputSterlingEquiAmt.Visible = true;
}
else
{
trInputSterlingEquiAmt.Visible = false;
}
txtSterlingEquivalent.Visible = false;
}
catch { }
}
// ================================================================================================================
#region LoadData
private void LoadData(int iCompanyID)
{
try
{
Invoice_CN objInvoice = new Invoice_CN();
string strStatus = "";
string strUserName = "";
string strEmail = "";
CreateTable();
sqlConn = new SqlConnection(CBSAppUtils.PrimaryConnectionString);
sqlDA = new SqlDataAdapter("stpGetPurchaseInvoiceHistoryForPassInvoicePageNL_CN", sqlConn);
sqlDA.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlDA.SelectCommand.Parameters.Add("@CompanyID", iCompanyID);
sqlDA.SelectCommand.Parameters.Add("@SupplierCompanyID", ddlSupplier.SelectedValue.Trim());
sqlDA.SelectCommand.Parameters.Add("@ActionStatusID", ddlActionStatus.SelectedValue.Trim());
sqlDA.SelectCommand.Parameters.Add("@DocStatusID", ddlDocStatus.SelectedValue.Trim());
sqlDA.SelectCommand.Parameters.Add("@UserID", ddlUsers.SelectedValue.Trim());
sqlDA.SelectCommand.Parameters.Add("@InvoiceNo", ddlInvoiceNo.SelectedValue.Trim());
sqlDA.SelectCommand.Parameters.Add("@FromDate", strFromDate);
sqlDA.SelectCommand.Parameters.Add("@ToDate", strToDate);
sqlDA.SelectCommand.Parameters.Add("@FromPrice", FromPrice);
sqlDA.SelectCommand.Parameters.Add("@ToPrice", ToPrice);
if (Convert.ToInt32(Session["UserTypeID"]) > 1)
{
sqlDA.SelectCommand.Parameters.Add("@PassedToUserID", DBNull.Value);
sqlDA.SelectCommand.Parameters.Add("@Option", 1);
}
else
{
sqlDA.SelectCommand.Parameters.Add("@PassedToUserID", Session["UserID"].ToString().Trim());
sqlDA.SelectCommand.Parameters.Add("@Option", DBNull.Value);
}
sqlDA.TableMappings.Add("CreditNoteDetails", "CreditNote");
ds = new DataSet();
try
{
sqlDA.Fill(ds, "CreditNoteDetails");
}
catch (Exception ex) { string ss = ex.Message.ToString(); }
finally
{
sqlDA.Dispose();
sqlConn.Close();
}
foreach (DataRow drInvoiceHeader in ds.Tables["CreditNote"].Rows)
{
dr = objDataTable.NewRow();
dr["CreditNoteID"] = drInvoiceHeader["CreditNoteID"];
dr["ReferenceNo"] = drInvoiceHeader["ReferenceNo"];
dr["SupplierCode"] = drInvoiceHeader["SupplierCode"];
dr["Supplier"] = drInvoiceHeader["Supplier"];
dr["VendorID"] = drInvoiceHeader["VendorID"];
dr["InvoiceDate"] = drInvoiceHeader["InvoiceDate"];
dr["DeliveryDate"] = drInvoiceHeader["DeliveryDate"];
dr["Net"] = drInvoiceHeader["Net"];
dr["VAT"] = drInvoiceHeader["VAT"];
dr["Total"] = drInvoiceHeader["Total"];
// CURRENT STATUS
objInvoice.GetCurrentStatus(Convert.ToInt32(drInvoiceHeader["StatusID"]), out strStatus);
dr["DocStatus"] = strStatus;
dr["ActionStatus"] = drInvoiceHeader["ActionStatus"];
// USER NAME
objInvoice.GetUserName(Convert.ToInt32(drInvoiceHeader["ModUserID"]), out strUserName, out strEmail);
dr["User"] = strUserName;
dr["Comment"] = strUserName;
dr["ActionDate"] = drInvoiceHeader["ModDate"];
dr["DocAttachments"] = drInvoiceHeader["Document"];
dr["DocType"] = "CRE";
dr["ParentRowFlag"] = "1";
if (drInvoiceHeader["BranchCode"] != DBNull.Value)
{
dr["BranchCode"] = drInvoiceHeader["BranchCode"];
}
objDataTable.Rows.Add(dr);
}
ViewState["objDataTable"] = objDataTable;
PopulateGrid();
CheckDuplicateValues();
}
catch { }
}
private void rptInvoice_DataInitialize(object sender, System.EventArgs eArgs)
{
RecordSet rsSupplier = Company.GetCompanyData(System.Convert.ToInt32(rsInvoiceHeader["SupplierCompanyID"]));
RecordSet rsBuyer = Company.GetCompanyData(System.Convert.ToInt32(rsInvoiceHeader["BuyerCompanyID"]));
Fields.Add("SupplierComapany");
Fields.Add("BuyerComapany");
Fields.Add("New_InvoiceName");
Fields.Add("CreditNoteID");
Fields.Add("InvoiceNo");
//Fields.Add("BranchID") ;
Fields.Add("PaymentDueDate");
Fields.Add("DiscountPercent");
Fields.Add("CustomerAccNo");
Fields.Add("InvoiceDate");
Fields.Add("PaymentTerm");
Fields.Add("NetTotal");
Fields.Add("H_VATAmt");
Fields.Add("H_TotalAmt");
Fields.Add("InvoiceAddress");
Fields.Add("DeliveryAddress");
Fields.Add("SupplierAddress");
Fields.Add("SellerVATNo");
Fields.Add("New_InvoiceContact");
Fields.Add("New_OverallDiscountPercent");
Fields.Add("New_SettlementDays1");
Fields.Add("New_SettlementDays2");
Fields.Add("New_SettlementPercent2");
//
Fields.Add("New_PaymentDate");
Fields.Add("New_PaymentMethod");
Fields.Add("New_DiscountGiven");
//invoice detail fields
Fields.Add("PurOrderNo");
Fields.Add("PurOrderLineNo");
Fields.Add("PurOrderDate");
Fields.Add("PurInfo");
Fields.Add("Quantity");
Fields.Add("Description");
Fields.Add("UOM");
Fields.Add("VATRate");
Fields.Add("Discount");
Fields.Add("Rate");
Fields.Add("BuyersProdCode");
Fields.Add("SuppliersProdCode");
Fields.Add("New_DespatchNoteNumber");
Fields.Add("New_DespatchDate");
Fields.Add("New_DiscountPercent2");
Fields.Add("New_NettValue");
Fields.Add("VATAmt");
Fields.Add("TotalAmt");
Fields.Add("New_Type");
Fields.Add("New_Definable1");
Fields["CreditNoteID"].Value = rsInvoiceHeader["CreditNoteID"];
Fields["InvoiceNo"].Value = rsInvoiceHeader["InvoiceNo"];
//Fields["BranchID"].Value = rsInvoiceHeader["BranchID"] ;
Fields["PaymentDueDate"].Value = rsInvoiceHeader["PaymentDueDate"];
Fields["DiscountPercent"].Value = rsInvoiceHeader["DiscountPercent"];
Fields["New_SettlementPercent2"].Value = rsInvoiceHeader["New_SettlementPercent2"];
Fields["CustomerAccNo"].Value = rsInvoiceHeader["CustomerAccNo"];
Fields["New_InvoiceContact"].Value = rsInvoiceHeader["New_InvoiceContact"];
Fields["New_OverallDiscountPercent"].Value = rsInvoiceHeader["New_OverallDiscountPercent"];
Fields["New_SettlementDays1"].Value = rsInvoiceHeader["New_SettlementDays1"];
Fields["New_SettlementDays2"].Value = rsInvoiceHeader["New_SettlementDays2"];
Fields["InvoiceDate"].Value = rsInvoiceHeader["InvoiceDate"];
Fields["PaymentTerm"].Value = rsInvoiceHeader["PaymentTerm"];
Fields["NetTotal"].Value = rsInvoiceHeader["NetTotal"];
Fields["H_VATAmt"].Value = rsInvoiceHeader["VATAmt"];
Fields["H_TotalAmt"].Value = rsInvoiceHeader["TotalAmt"];
Fields["SupplierComapany"].Value = rsSupplier["CompanyName"];
Fields["BuyerComapany"].Value = rsBuyer["CompanyName"];
rsSupplier = null;
rsBuyer = null;
Fields["New_InvoiceName"].Value = rsInvoiceHeader["New_InvoiceName"];
JKS.Invoice objInvoice = new JKS.Invoice();
Invoice_CN objInvoice_CN = new Invoice_CN();
if (rsInvoiceHeader["CurrencyTypeID"] != DBNull.Value)
{
TextBox9.Text = objInvoice.GetCurrencyCode(Convert.ToInt32(rsInvoiceHeader["CurrencyTypeID"]));
}
Double dGBPEquivalentAmount = 0;
dGBPEquivalentAmount = objInvoice_CN.GetGBPEquivalentAmount(Convert.ToInt32(rsInvoiceHeader["CreditNoteID"]));
if (dGBPEquivalentAmount > 0)
{
lblGBPEquivalentAmount.Visible = true;
tblGBPEquivalentAmount.Text = dGBPEquivalentAmount.ToString();
}
if (rsInvoiceHeader["CreditNoteID"] != DBNull.Value)
{
txtAssociatedInvoiceNo.Text = objInvoice_CN.GetAssociatedInvoiceNo(Convert.ToInt32(rsInvoiceHeader["CreditNoteID"]));
}
string s = GetAddressLine(rsInvoiceHeader["DeliveryAddress1"].ToString());
s += GetAddressLine(rsInvoiceHeader["DeliveryAddress2"].ToString());
s += GetAddressLine(rsInvoiceHeader["DeliveryAddress3"].ToString());
s += GetAddressLine(rsInvoiceHeader["DeliveryAddress4"].ToString());
s += GetAddressLine(rsInvoiceHeader["DeliveryAddress5"].ToString());
s += GetAddressLine(rsInvoiceHeader["DeliveryCountry"].ToString());
s += GetAddressLine(rsInvoiceHeader["DeliveryZIP"].ToString());
Fields["DeliveryAddress"].Value = s;
s = GetAddressLine(rsInvoiceHeader["InvoiceAddress1"].ToString());
s += GetAddressLine(rsInvoiceHeader["InvoiceAddress2"].ToString());
s += GetAddressLine(rsInvoiceHeader["InvoiceAddress3"].ToString());
s += GetAddressLine(rsInvoiceHeader["InvoiceAddress4"].ToString());
s += GetAddressLine(rsInvoiceHeader["InvoiceAddress5"].ToString());
s += GetAddressLine(rsInvoiceHeader["InvoiceCountry"].ToString());
s += GetAddressLine(rsInvoiceHeader["InvoiceZIP"].ToString());
Fields["InvoiceAddress"].Value = s;
s = GetAddressLine(rsInvoiceHeader["SupplierAddress1"].ToString());
s += GetAddressLine(rsInvoiceHeader["SupplierAddress2"].ToString());
s += GetAddressLine(rsInvoiceHeader["SupplierAddress3"].ToString());
s += GetAddressLine(rsInvoiceHeader["SupplierAddress4"].ToString());
s += GetAddressLine(rsInvoiceHeader["SupplierAddress5"].ToString());
s += GetAddressLine(rsInvoiceHeader["SupplierCountry"].ToString());
s += GetAddressLine(rsInvoiceHeader["SupplierZIP"].ToString());
Fields["SupplierAddress"].Value = s;
Fields["SellerVATNo"].Value = rsInvoiceHeader["SellerVATNo"];
}
