protected void GridInword_RowDataBound(object sender, GridViewRowEventArgs e) { try { if (e.Row.RowType == DataControlRowType.DataRow && !string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(e.Row.DataItem, "InwardNo")))) { //Taxamt += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "DiscAmnt")); SubTotal += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "SubTotal")); Discount += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Discount")); Vat += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Vat")); DekhrekhAmt += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "DekhrekhAmt")); HamaliAmt += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "HamaliAmt")); CESSAmt += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "CESSAmt")); FreightAmt += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "FreightAmt")); PackingAmt += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "PackingAmt")); PostageAmt += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "PostageAmt")); OtherCharges += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "OtherCharges")); GrandTotal += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "GrandTotal")); } if (e.Row.RowType == DataControlRowType.Footer) { e.Row.Cells[6].Text = "Total"; e.Row.Cells[7].Text = SubTotal.ToString("0.00"); e.Row.Cells[8].Text = Discount.ToString("0.00"); e.Row.Cells[9].Text = Vat.ToString("0.00"); e.Row.Cells[10].Text = DekhrekhAmt.ToString("0.00"); e.Row.Cells[11].Text = HamaliAmt.ToString("0.00"); e.Row.Cells[12].Text = CESSAmt.ToString("0.00"); e.Row.Cells[13].Text = FreightAmt.ToString("0.00"); e.Row.Cells[14].Text = PackingAmt.ToString("0.00"); e.Row.Cells[15].Text = PostageAmt.ToString("0.00"); e.Row.Cells[16].Text = OtherCharges.ToString("0.00"); e.Row.Cells[17].Text = GrandTotal.ToString("0.00"); } } catch (Exception ex) { throw new Exception(ex.Message); } }
private void CalTotalLine() { decimal Vat; decimal Amount, FCR = 0; Vat = 0; Amount = 0; foreach (DataGridViewRow item in dgvAccList.Rows) { decimal Vat1 = 0, Amount1 = 0, FCR1 = 0; bool resp = decimal.TryParse(item.Cells["dgvAccList_Amount"].Value.ToString(), out Amount1); resp = decimal.TryParse(item.Cells["dgvAccList_Vat"].Value.ToString(), out Vat1); resp = decimal.TryParse(item.Cells["dgvAccList_Fcur"].Value.ToString(), out FCR1); FCR = FCR + FCR1; Vat = Vat + Vat1; Amount = Amount + Amount1; } txtTotalvat.Text = Vat.ToString("0.00"); txtToalAmountLKR.Text = Amount.ToString("0.00"); txtToalAmountFCR.Text = FCR.ToString("0.00"); }
/// <summary> /// Output all properties /// </summary> /// <returns>A string</returns> public override string ToString() { var toString = new StringBuilder(); toString.Append("ID: ").AppendLine(Id); toString.Append("Name: ").AppendLine(Name); toString.Append("ShortDescription: ").AppendLine(ShortDescription); toString.Append("Followers: ").AppendLine(NumberOfFollowers.ToString(CultureInfo.InvariantCulture)); toString.Append("Currency: ").AppendLine(Currency); toString.Append("Vat: ").AppendLine(Vat.ToString()); toString.Append("Language: ").AppendLine(Language); toString.Append("Country: ").AppendLine(Country); if (Logotypes != null && Logotypes.Count > 0) { foreach (var logotype in Logotypes) { toString.Append("Logotype: ").AppendLine(logotype.ToString()); } } // TODO:Wallpapers toString.Append("Description: ").AppendLine(Description); toString.Append("Url: ").AppendLine(Url); toString.Append("Subdomain: ").AppendLine(Subdomain); if (CreatedAt.HasValue) { toString.Append("CreatedAt: ").AppendLine(CreatedAt.Value.ToString()); } if (ModifiedAt.HasValue) { toString.Append("ModifiedAt: ").AppendLine(ModifiedAt.Value.ToString()); } toString.Append("ContactEmail: ").AppendLine(ContactEmail); toString.Append("StorekeeperEmail: ").AppendLine(StorekeeperEmail); toString.Append("Sandbox: ").AppendLine(Sandbox.ToString()); toString.Append("DashboardUrl: ").AppendLine(DashboardUrl); toString.Append("AppstoreCurrency: ").AppendLine(AppstoreCurrency); return(toString.ToString()); }
/// <summary> /// Output all properties /// </summary> /// <returns>A string</returns> public override string ToString() { var toString = new StringBuilder(); toString.Append("ID: ").AppendLine(Id); toString.Append("Completed: ").AppendLine(Completed); toString.Append("Number: ").AppendLine(Number.ToString(CultureInfo.InvariantCulture)); toString.Append("Price: ").AppendLine(Price.ToString(CultureInfo.InvariantCulture)); toString.Append("Currency: ").AppendLine(Currency); toString.Append("InvoiceFee: ").AppendLine(InvoiceFee.ToString(CultureInfo.InvariantCulture)); toString.Append("Note: ").AppendLine(Note); toString.Append("PricesIncludeVat: ").AppendLine(PricesIncludeVat.ToString()); toString.Append("Transaction: ").AppendLine(Transaction.ToString()); toString.Append("Fullfilment: ").AppendLine(Fullfillment.ToString()); toString.Append("Customer: ").AppendLine(Customer.ToString()); toString.Append("Vat: ").AppendLine(Vat.ToString()); toString.Append("items: ").AppendLine(Items.Count.ToString(CultureInfo.InvariantCulture)); foreach (var item in Items) { toString.AppendLine(item.ToString()); } toString.Append("discounts: ").AppendLine(Discounts.Count.ToString(CultureInfo.InvariantCulture)); foreach (var discount in Discounts) { toString.AppendLine(discount.ToString()); } toString.Append("ShippingAlternative: ").AppendLine(ShippingAlternative.ToString()); toString.Append("CreatedAt: ").AppendLine(CreatedAt.ToString(CultureInfo.InvariantCulture)); if (ModifiedAt.HasValue) { toString.Append("ModifiedAt: ").AppendLine(ModifiedAt.Value.ToString(CultureInfo.InvariantCulture)).AppendLine(); } return(toString.ToString()); }
protected void GrdReport_RowDataBound(object sender, GridViewRowEventArgs e) { try { if (e.Row.RowType == DataControlRowType.DataRow) { SubTotal += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "SubTotal")); GrandTotal += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "GrandTotal")); Discount += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Discount")); Vat += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Vat")); } if (e.Row.RowType == DataControlRowType.Footer) { e.Row.Cells[4].Text = "Total : "; e.Row.Cells[5].Text = SubTotal.ToString(); e.Row.Cells[6].Text = Discount.ToString(); e.Row.Cells[7].Text = Vat.ToString(); e.Row.Cells[8].Text = GrandTotal.ToString(); } } catch (Exception ex) { } }