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(); }