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)
{
}
}
