public string Update()
{
CommissionAmount = (CommissionRate * Amount) / 100;
CommissionAmount = Math.Round((decimal)CommissionAmount);
VatOnAmount = Amount + CommissionAmount;
VatAmount = (CommissionAmount + Amount) * VatRate / 100;
VatAmount = Math.Round((decimal)VatAmount);
InvoiceAmount = Amount + CommissionAmount + VatAmount;
XDocument doc = XDocument.Load(@"Transactions.xml");
var record = from r in doc.Descendants("Transaction")
where (int)r.Element("Invoice").Attribute("Id") == InvoiceId
select r;
foreach (XElement r in record)
{
r.Element("Invoice").Element("InvoiceNo").Value = InvoiceNo;
r.Element("Invoice").Element("InvoiceDate").Value = XmlConvert.ToString(InvoiceDate, XmlDateTimeSerializationMode.RoundtripKind);
r.Element("Invoice").Element("CommissionRate").Value = CommissionRate.ToString();
r.Element("Invoice").Element("CommissionAmount").Value = CommissionAmount.ToString();
r.Element("Invoice").Element("VatRate").Value = VatRate.ToString();
r.Element("Invoice").Element("VatAmount").Value = VatAmount.ToString();
r.Element("Invoice").Element("InvoiceAmount").Value = InvoiceAmount.ToString();
r.Element("Invoice").Element("Source").Value = Source;
r.Element("Invoice").Element("Destination").Value = Destination;
r.Element("Invoice").Element("TruckNo").Value = TruckNo;
}
doc.Save(@"Transactions.xml");
return("Record Updated");
}
private void LoadData()
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = clsUtils.GetConnString(1);
conn.Open();
DataSet SettingData = new DataSet();
SqlDataAdapter SettingsDataAdapter = new SqlDataAdapter("SELECT * from tblCompanyDetails", conn);
SettingsDataAdapter.Fill(SettingData, "tblCompanyDetails");
txtCompanyName.Text = SettingData.Tables["tblCompanyDetails"].Rows[0]["CompanyName"].ToString();
txtAdd1.Text = SettingData.Tables["tblCompanyDetails"].Rows[0]["Street"].ToString();
txtAdd2.Text = SettingData.Tables["tblCompanyDetails"].Rows[0]["Area"].ToString();
txtAdd3.Text = SettingData.Tables["tblCompanyDetails"].Rows[0]["Town"].ToString();
txtAdd4.Text = SettingData.Tables["tblCompanyDetails"].Rows[0]["County"].ToString();
txtPostCode.Text = SettingData.Tables["tblCompanyDetails"].Rows[0]["PostCode"].ToString();
txtTelephone.Text = SettingData.Tables["tblCompanyDetails"].Rows[0]["Telephone"].ToString();
txtFax.Text = SettingData.Tables["tblCompanyDetails"].Rows[0]["Fax"].ToString();
txtVATReg.Text = SettingData.Tables["tblCompanyDetails"].Rows[0]["VATRegistrationNo"].ToString();
txtEmail.Text = SettingData.Tables["tblCompanyDetails"].Rows[0]["Email"].ToString();
txtWWW.Text = SettingData.Tables["tblCompanyDetails"].Rows[0]["Website"].ToString();
double VatRate;
VatRate = Convert.ToDouble(SettingData.Tables["tblCompanyDetails"].Rows[0]["VatRate"]);
txtVATRate.Text = VatRate.ToString("P2", CultureInfo.InvariantCulture);
// txtVATRate.Text = FormatPercent(txtVATRate.Text)
}
}
private void txtVATRate_Leave(object sender, EventArgs e)
{
double VatRate;
VatRate = Convert.ToDouble(txtVATRate.Text.TrimEnd());
txtVATRate.Text = VatRate.ToString("P2", CultureInfo.InvariantCulture);
}
public override void FillCongressVotingArguments(CongressVoting voting)
{
voting.Argument1 = ((int)ProductType).ToString();
voting.Argument2 = VatRate.ToString();
}
