public virtual CloudAccountDA.TaxMasterDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; CloudAccountDA.TaxMasterDataTable dataTable = new CloudAccountDA.TaxMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
private void ViewRecord(string iD) { this.objItemMasterDT = this.objItemMasterBll.GetDataByItemID(int.Parse(iD)); if (this.objItemMasterDT.Rows.Count <= 0) { return; } this.hfItemID.Value = this.objItemMasterDT.Rows[0]["ItemID"].ToString(); this.hfCompanyID.Value = this.objItemMasterDT.Rows[0]["CompanyID"].ToString(); this.lblItemName.Text = this.objItemMasterDT.Rows[0]["ItemName"].ToString(); this.lblItemDesc.Text = this.objItemMasterDT.Rows[0]["Description"].ToString(); this.lblUnitCost.Text = this.objItemMasterDT.Rows[0]["UnitCost"].ToString(); this.lblCurrentStock.Text = this.objItemMasterDT.Rows[0]["CurrentStock"].ToString(); this.lblQuantity.Text = this.objItemMasterDT.Rows[0]["Quantity"].ToString(); this.lblInventory.Text = this.objItemMasterDT.Rows[0]["TrackInventory"].ToString(); string s1 = this.objItemMasterDT.Rows[0]["TaxID1"].ToString(); string s2 = this.objItemMasterDT.Rows[0]["TaxID2"].ToString(); if (!string.IsNullOrEmpty(s1)) { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxID(int.Parse(s1)); this.lblTax.Text = this.objTaxMasterDT.Rows[0]["TaxName"].ToString(); } if (string.IsNullOrEmpty(s2)) { return; } this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxID(int.Parse(s2)); this.lblTax2.Text = this.objTaxMasterDT.Rows[0]["TaxName"].ToString(); }
public virtual int Fill(CloudAccountDA.TaxMasterDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (this.ClearBeforeFill) { dataTable.Clear(); } return(this.Adapter.Fill(dataTable)); }
private void SetRecord(string iD) { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxID(int.Parse(iD)); if (this.objTaxMasterDT.Rows.Count <= 0) { return; } this.hfTaxID.Value = this.objTaxMasterDT.Rows[0]["TaxID"].ToString(); this.hfCompanyID.Value = this.objTaxMasterDT.Rows[0]["CompanyID"].ToString(); this.txtTaxName.Text = this.objTaxMasterDT.Rows[0]["TaxName"].ToString(); this.txtTaxNumber.Text = this.objTaxMasterDT.Rows[0]["TaxNumber"].ToString(); this.txtTaxRate.Text = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString(); }
public virtual CloudAccountDA.TaxMasterDataTable DeleteByCompanyID(int?CompanyID) { this.Adapter.SelectCommand = this.CommandCollection[1]; if (CompanyID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = CompanyID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } CloudAccountDA.TaxMasterDataTable dataTable = new CloudAccountDA.TaxMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
protected void gvTaskView_OnRowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType != DataControlRowType.DataRow) { return; } string text1 = e.Row.Cells[0].Text; string text2 = e.Row.Cells[4].Text; string text3 = e.Row.Cells[5].Text; this.objTaskMasterDT = this.objTaskMasterBll.GetDataByTaskID(int.Parse(text1)); if (this.objTaskMasterDT.Rows.Count > 0) { e.Row.Cells[0].Text = this.objTaskMasterDT.Rows[0]["TaskName"].ToString(); } try { if (!string.IsNullOrEmpty(text2) && !text2.Contains("&")) { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxID(int.Parse(text2)); if (this.objTaxMasterDT.Rows.Count > 0) { e.Row.Cells[4].Text = this.objTaxMasterDT.Rows[0]["TaxName"].ToString(); } } if (string.IsNullOrEmpty(text3) || text3.Contains("&")) { return; } this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxID(int.Parse(text3)); if (this.objTaxMasterDT.Rows.Count <= 0) { return; } e.Row.Cells[5].Text = this.objTaxMasterDT.Rows[0]["TaxName"].ToString(); } catch (Exception ex) { e.Row.Cells[4].Text = ""; e.Row.Cells[5].Text = ""; } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (!this.Page.IsValid) { return; } if (this.txtTaxName.Text.Trim().Length > 0) { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), this.txtTaxName.Text.Trim()); if (this.objTaxMasterDT.Rows.Count > 0) { this.checkInDB = true; this.DisplayAlert("Tax Already Exists..!"); } if (this.checkInDB) { return; } Decimal?dTaxRate = new Decimal?(); if (this.txtTaxRate.Text.Trim().Length > 0) { dTaxRate = new Decimal?(Decimal.Parse(this.txtTaxRate.Text.Trim())); } int num = this.objTaxMasterBll.AddTax(int.Parse(this.hfCompanyID.Value), this.txtTaxName.Text.Trim(), dTaxRate, this.txtTaxNumber.Text.Trim()); if (num != 0) { this.Session["saveTax"] = (object)1; this.DisplayAlert("Details Added Successfully."); this.Response.Redirect("~/BillTransact/TaxMaster.aspx?cmd=add&ID=" + (object)num); } else { this.DisplayAlert("Fail to Add New Details."); this.Clear(); } } else { this.DisplayAlert("Please Fill All Details...!"); } }
public virtual CloudAccountDA.TaxMasterDataTable GetDataByTaxName(int?CompanyID, string TaxName) { this.Adapter.SelectCommand = this.CommandCollection[4]; if (CompanyID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = CompanyID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } if (TaxName == null) { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = TaxName; } CloudAccountDA.TaxMasterDataTable dataTable = new CloudAccountDA.TaxMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
private void ViewRecord(string id) { this.objEstimateMasterDT = this.objEstimateMasterBll.GetDataByEstimateID(int.Parse(id)); if (this.objEstimateMasterDT.Rows.Count <= 0) { return; } this.hfCompanyID.Value = this.objEstimateMasterDT.Rows[0]["CompanyID"].ToString(); this.hfEstimateID.Value = this.objEstimateMasterDT.Rows[0]["EstimateID"].ToString(); this.lblEstimateNum.Text = this.objEstimateMasterDT.Rows[0]["EstimateNumber"].ToString(); this.lblEstimateNumHead.Text = "Estimate: " + this.objEstimateMasterDT.Rows[0]["EstimateNumber"]; this.lblEstimateDate.Text = DateTime.Parse(this.objEstimateMasterDT.Rows[0]["EstimateDate"].ToString()).ToString("MMMM dd, yyyy"); this.lblPONumber.Text = this.objEstimateMasterDT.Rows[0]["PONumber"].ToString(); this.lblTerms.Text = this.objEstimateMasterDT.Rows[0]["Terms"].ToString(); this.lblNotes.Text = this.objEstimateMasterDT.Rows[0]["Notes"].ToString(); string s1 = this.objEstimateMasterDT.Rows[0]["Discount"].ToString(); this.lblDiscout.Text = s1.Length > 0 ? s1 : "0.00"; this.lblEstimateTotalView.Text = Decimal.Round(Decimal.Parse(this.objEstimateMasterDT.Rows[0]["EstimateTotal"].ToString()), 2).ToString(); this.lblPaidToDateView.Text = Decimal.Round(Decimal.Parse(this.objEstimateMasterDT.Rows[0]["PaidToDate"].ToString()), 2).ToString(); Label label1 = this.lblEstimateAmount; Label label2 = this.lblAmountDue; Decimal num1 = Decimal.Parse(this.lblEstimateTotalView.Text) - Decimal.Parse(this.lblPaidToDateView.Text); string str1; string str2 = str1 = num1.ToString(); label2.Text = str1; string str3 = str2; label1.Text = str3; Label label3 = this.lblEstimateAmount; Label label4 = this.lblAmountDue; Decimal num2 = Decimal.Round(Decimal.Parse(this.lblAmountDue.Text), 2); string str4; string str5 = str4 = num2.ToString(); label4.Text = str4; string str6 = str5; label3.Text = str6; this.divTaxValueView.Controls.Clear(); this.divTaxView.Controls.Clear(); Hashtable hashtable = new Hashtable(); if (this.gvTaskView.Rows.Count > 0) { for (int index = 0; index < this.gvTaskView.Rows.Count; ++index) { string text1 = this.gvTaskView.Rows[index].Cells[2].Text; string text2 = this.gvTaskView.Rows[index].Cells[3].Text; string text3 = this.gvTaskView.Rows[index].Cells[4].Text; string text4 = this.gvTaskView.Rows[index].Cells[5].Text; try { if (!string.IsNullOrEmpty(text3) && !text3.Contains("&")) { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text3); if (this.objTaxMasterDT.Rows.Count > 0) { string s2 = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString(); Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s2) / new Decimal(100); Label label5 = new Label() { Text = this.gvTaskView.Rows[index].Cells[4].Text + "(" + s2 + ")" }; Label label6 = new Label() { Text = string.Concat((object)Decimal.Round(d, 2)) }; if (hashtable.ContainsKey((object)label5.Text)) { object obj = hashtable[(object)label5.Text]; Decimal num3 = d + Decimal.Parse(obj.ToString()); hashtable.Remove((object)label5.Text); hashtable.Add((object)label5.Text, (object)num3.ToString()); } else { hashtable.Add((object)label5.Text, (object)label6.Text); } } } if (!string.IsNullOrEmpty(text4)) { if (!text4.Contains("&")) { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text4); if (this.objTaxMasterDT.Rows.Count > 0) { string s2 = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString(); Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s2) / new Decimal(100); Label label5 = new Label() { Text = this.gvTaskView.Rows[index].Cells[5].Text + "(" + s2 + ")" }; Label label6 = new Label() { Text = string.Concat((object)Decimal.Round(d, 2)) }; if (hashtable.ContainsKey((object)label5.Text)) { object obj = hashtable[(object)label5.Text]; Decimal num3 = d + Decimal.Parse(obj.ToString()); hashtable.Remove((object)label5.Text); hashtable.Add((object)label5.Text, (object)num3.ToString()); } else { hashtable.Add((object)label5.Text, (object)label6.Text); } } } } } catch (Exception ex) { this.gvTaskView.Rows[index].Cells[4].Text = ""; this.gvTaskView.Rows[index].Cells[5].Text = ""; } } } if (this.gvItemView.Rows.Count > 0) { for (int index = 0; index < this.gvItemView.Rows.Count; ++index) { string text1 = this.gvItemView.Rows[index].Cells[2].Text; string text2 = this.gvItemView.Rows[index].Cells[3].Text; string text3 = this.gvItemView.Rows[index].Cells[4].Text; string text4 = this.gvItemView.Rows[index].Cells[5].Text; try { if (!string.IsNullOrEmpty(text3) && !text3.Contains("&")) { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text3); if (this.objTaxMasterDT.Rows.Count > 0) { string s2 = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString(); Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s2) / new Decimal(100); Label label5 = new Label() { Text = this.gvItemView.Rows[index].Cells[4].Text + "(" + s2 + ")" }; Label label6 = new Label() { Text = string.Concat((object)Decimal.Round(d, 2)) }; if (hashtable.ContainsKey((object)label5.Text)) { object obj = hashtable[(object)label5.Text]; Decimal num3 = d + Decimal.Parse(obj.ToString()); hashtable.Remove((object)label5.Text); hashtable.Add((object)label5.Text, (object)num3.ToString()); } else { hashtable.Add((object)label5.Text, (object)label6.Text); } } } if (!string.IsNullOrEmpty(text4)) { if (!text4.Contains("&")) { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text4); if (this.objTaxMasterDT.Rows.Count > 0) { string s2 = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString(); Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s2) / new Decimal(100); Label label5 = new Label() { Text = this.gvItemView.Rows[index].Cells[5].Text + "(" + s2 + ")" }; Label label6 = new Label() { Text = string.Concat((object)Decimal.Round(d, 2)) }; if (hashtable.ContainsKey((object)label5.Text)) { object obj = hashtable[(object)label5.Text]; Decimal num3 = d + Decimal.Parse(obj.ToString()); hashtable.Remove((object)label5.Text); hashtable.Add((object)label5.Text, (object)num3.ToString()); } else { hashtable.Add((object)label5.Text, (object)label6.Text); } } } } } catch (Exception ex) { this.gvItemView.Rows[index].Cells[4].Text = ""; this.gvItemView.Rows[index].Cells[5].Text = ""; } } } if (hashtable.Count > 0) { foreach (string str7 in (IEnumerable)hashtable.Keys) { this.divTaxView.Controls.Add((Control) new Label() { Text = str7 }); this.divTaxView.Controls.Add((Control) new LiteralControl("<br />")); } foreach (object obj in (IEnumerable)hashtable.Values) { this.divTaxValueView.Controls.Add((Control) new Label() { Text = ("+" + (object)Decimal.Round(Decimal.Parse(obj.ToString()), 2)) }); this.divTaxValueView.Controls.Add((Control) new LiteralControl("<br />")); } } Decimal d1 = new Decimal(0); if (this.gvItemView.Rows.Count > 0) { for (int index = 0; index < this.gvItemView.Rows.Count; ++index) { string text = this.gvItemView.Rows[index].Cells[6].Text; d1 += Decimal.Parse(text); } } if (this.gvTaskView.Rows.Count > 0) { for (int index = 0; index < this.gvTaskView.Rows.Count; ++index) { string text = this.gvTaskView.Rows[index].Cells[6].Text; d1 += Decimal.Parse(text); } } Label label7 = this.lblSubTotalView; Decimal num4 = Decimal.Round(d1, 2); string str8 = num4.ToString(); label7.Text = str8; Label label8 = this.lblDiscountAmt; num4 = Decimal.Parse(this.lblSubTotalView.Text) * Decimal.Parse(s1) / new Decimal(100); string str9 = num4.ToString(); label8.Text = str9; Label label9 = this.lblDiscountAmt; num4 = Decimal.Round(Decimal.Parse(this.lblDiscountAmt.Text), 2); string str10 = num4.ToString(); label9.Text = str10; this.lblAddedTaxesView.Text = Decimal.Round(Decimal.Parse(this.lblEstimateAmount.Text) - Decimal.Parse(this.lblSubTotalView.Text) + Decimal.Parse(this.lblDiscountAmt.Text), 2).ToString(); this.objCompanyMasterDT = this.objCompanyMasterBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value)); this.imgLogo.ImageUrl = "../Handler/CompanyLogoFile.ashx?id=" + this.objCompanyMasterDT.Rows[0]["CompanyID"]; this.lblCompanyName.Text = this.objCompanyMasterDT.Rows[0]["CompanyName"].ToString(); string str11 = string.Empty; if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet1"].ToString())) { str11 = str11 + this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet1"] + ",<br />"; } if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet2"].ToString())) { str11 = str11 + this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet2"] + ",<br />"; } if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyCityID"].ToString())) { this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(this.objCompanyMasterDT.Rows[0]["CompanyCityID"].ToString())); if (this.objCityMasterDT.Rows.Count > 0) { str11 = str11 + this.objCityMasterDT.Rows[0]["CityName"] + " - "; } } if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyZipCode"].ToString())) { str11 = str11 + this.objCompanyMasterDT.Rows[0]["CompanyZipCode"] + ",<br />"; } if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyStateID"].ToString())) { this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(this.objCompanyMasterDT.Rows[0]["CompanyStateID"].ToString())); if (this.objStateMasterDT.Rows.Count > 0) { str11 = str11 + this.objStateMasterDT.Rows[0]["StateName"] + ",<br />"; } } if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyCountryID"].ToString())) { this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(this.objCompanyMasterDT.Rows[0]["CompanyCountryID"].ToString())); if (this.objCountryMasterDT.Rows.Count > 0) { str11 = str11 + this.objCountryMasterDT.Rows[0]["CountryName"] + ".<br />"; } } this.lblCompanyAddress.Text = str11; Label label10 = this.lblCompanyAddress; string str12 = label10.Text + (object)"Email: <a href=\"mailto:" + (string)this.objCompanyMasterDT.Rows[0]["CompanyEmail"] + "\">" + (string)this.objCompanyMasterDT.Rows[0]["CompanyEmail"] + "</a><br />"; label10.Text = str12; Label label11 = this.lblCompanyAddress; string str13 = label11.Text + (object)"Phone: " + (string)this.objCompanyMasterDT.Rows[0]["CompanyPhone"]; label11.Text = str13; this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(int.Parse(this.objEstimateMasterDT.Rows[0]["ClientId"].ToString())); this.lblClientOrganizationName.Text = this.objCompanyClientMasterDT.Rows[0]["OrganizationName"].ToString(); this.lblClientFullName.Text = (string)this.objCompanyClientMasterDT.Rows[0]["FirstName"] + (object)" " + (string)this.objCompanyClientMasterDT.Rows[0]["LastName"]; string str14 = string.Empty + this.objCompanyClientMasterDT.Rows[0]["Address1"] + ",<br />" + this.objCompanyClientMasterDT.Rows[0]["Address2"] + ",<br />"; if (!string.IsNullOrEmpty(this.objCompanyClientMasterDT.Rows[0]["CityID"].ToString())) { this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(this.objCompanyClientMasterDT.Rows[0]["CityID"].ToString())); if (this.objCityMasterDT.Rows.Count > 0) { str14 = str14 + this.objCityMasterDT.Rows[0]["CityName"] + " "; } } if (!string.IsNullOrEmpty(this.objCompanyClientMasterDT.Rows[0]["StateID"].ToString())) { this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(this.objCompanyClientMasterDT.Rows[0]["StateID"].ToString())); if (this.objStateMasterDT.Rows.Count > 0) { str14 = str14 + this.objStateMasterDT.Rows[0]["StateName"] + " "; } } string str15 = string.Concat(new object[4] { (object)str14, (object)" - ", this.objCompanyClientMasterDT.Rows[0]["ZipCode"], (object)",<br />" }); if (!string.IsNullOrEmpty(this.objCompanyClientMasterDT.Rows[0]["CountryID"].ToString())) { this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(this.objCompanyClientMasterDT.Rows[0]["CountryID"].ToString())); str15 += this.objCountryMasterDT.Rows[0]["CountryName"].ToString(); } this.lblClientAddress.Text = str15; switch (this.objEstimateMasterDT.Rows[0]["EstimateStatus"].ToString()) { case "draft": this.divStatus.Attributes.Add("class", "status-draft"); break; case "draft-partial": this.divStatus.Attributes.Add("class", "status-draft-partial"); break; case "created": this.divStatus.Attributes.Add("class", "status-created"); break; case "sent": this.divStatus.Attributes.Add("class", "status-received"); break; case "viewed": this.divStatus.Attributes.Add("class", "status-received"); break; case "disputed": this.divStatus.Attributes.Add("class", "status-disputed"); break; case "paid": this.divStatus.Attributes.Add("class", "status-paid"); break; case "partial": this.divStatus.Attributes.Add("class", "status-partial"); break; case "pending": this.divStatus.Attributes.Add("class", "status-pending"); break; case "declined": this.divStatus.Attributes.Add("class", "status-declined"); break; case "auto-paid": this.divStatus.Attributes.Add("class", "status-auto-paid"); break; case "retry": this.divStatus.Attributes.Add("class", "status-retry"); break; case "failed": this.divStatus.Attributes.Add("class", "status-failed"); break; case "replied": this.divStatus.Attributes.Add("class", "status-replied"); break; case "commented": this.divStatus.Attributes.Add("class", "status-commented"); break; case "resolved": this.divStatus.Attributes.Add("class", "status-resolved"); break; case "invoiced": this.divStatus.Attributes.Add("class", "status-invoiced"); break; case "accepted": this.divStatus.Attributes.Add("class", "status-accepted"); break; case "Estimated": this.divStatus.Attributes.Add("class", "status-Estimated"); break; case "outstanding": this.divStatus.Attributes.Add("class", "status-outstanding"); break; case "open": this.divStatus.Attributes.Add("class", "status-open"); break; default: this.divStatus.Attributes.Add("class", "status-created"); break; } string s3 = this.objEstimateMasterDT.Rows[0]["CurrencyID"].ToString(); if (string.IsNullOrEmpty(s3)) { return; } this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(s3)); if (this.objCurrencyMasterDT.Rows.Count <= 0) { return; } this.lblCurCodeView1.Text = this.lblCurCodeView2.Text = this.objCurrencyMasterDT.Rows[0]["CurrencyCode"].ToString(); this.lblCurSymbolView1.Text = this.lblCurSymbolView2.Text = this.objCurrencyMasterDT.Rows[0]["CurrencySymbol"].ToString(); }
public virtual int Update(CloudAccountDA.TaxMasterDataTable dataTable) { return(this.Adapter.Update(dataTable)); }
private void ViewRecord(string id) { bool flag = false; this.objCreditMasterDT = this.objCreditMasterBll.GetDataByCreditID(int.Parse(id)); if (this.objCreditMasterDT.Rows.Count > 0) { flag = this.objCreditMasterDT.Rows[0]["ClientID"].ToString() == this.hfClientID.Value; } if (this.objCreditMasterDT.Rows.Count > 0 && flag) { this.hfCompanyID.Value = this.objCreditMasterDT.Rows[0]["CompanyID"].ToString(); this.objTemplateSettingsDT = this.objTemplateSettingsBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value)); if (this.objTemplateSettingsDT.Rows.Count > 0) { this.lblCreditTitle.Text = (string)this.objTemplateSettingsDT.Rows[0]["CreditTitle"] + (object)" #"; this.lblCreditTitleDate.Text = (string)this.objTemplateSettingsDT.Rows[0]["CreditTitle"] + (object)" Date"; } this.hfCreditID.Value = this.objCreditMasterDT.Rows[0]["CreditID"].ToString(); this.lblCreditNum.Text = this.objCreditMasterDT.Rows[0]["CreditNumber"].ToString(); this.lblTerms.Text = this.objCreditMasterDT.Rows[0]["Terms"].ToString(); this.lblNotes.Text = this.objCreditMasterDT.Rows[0]["Notes"].ToString(); this.lblCreditNumHead.Text = "Credit: " + this.objCreditMasterDT.Rows[0]["CreditNumber"]; this.lblCreditDate.Text = DateTime.Parse(this.objCreditMasterDT.Rows[0]["CreditDate"].ToString()).ToString("MMMM dd, yyyy"); this.lblCreditTotalView.Text = Decimal.Round(Decimal.Parse(this.objCreditMasterDT.Rows[0]["CreditTotal"].ToString()), 2).ToString(); if (this.objCreditMasterDT.Rows[0]["CreditStatus"].ToString().ToLower() == "sent") { this.objCreditMasterBll.UpdateCreditStatus(int.Parse(this.hfCreditID.Value), "viewed"); } this.lblCreditAmount.Text = Decimal.Parse(this.lblCreditTotalView.Text).ToString(); this.lblCreditAmount.Text = Decimal.Round(Decimal.Parse(this.lblCreditAmount.Text), 2).ToString(); this.divTaxValueView.Controls.Clear(); this.divTaxView.Controls.Clear(); Hashtable hashtable = new Hashtable(); if (this.gvTaskView.Rows.Count > 0) { for (int index = 0; index < this.gvTaskView.Rows.Count; ++index) { string text1 = this.gvTaskView.Rows[index].Cells[2].Text; string text2 = this.gvTaskView.Rows[index].Cells[3].Text; string text3 = this.gvTaskView.Rows[index].Cells[4].Text; string text4 = this.gvTaskView.Rows[index].Cells[5].Text; try { if (!string.IsNullOrEmpty(text3) && !text3.Contains("&")) { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text3); if (this.objTaxMasterDT.Rows.Count > 0) { string s = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString(); Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s) / new Decimal(100); Label label1 = new Label() { Text = this.gvTaskView.Rows[index].Cells[4].Text + "(" + s + ")" }; Label label2 = new Label() { Text = string.Concat((object)Decimal.Round(d, 2)) }; if (hashtable.ContainsKey((object)label1.Text)) { object obj = hashtable[(object)label1.Text]; Decimal num = d + Decimal.Parse(obj.ToString()); hashtable.Remove((object)label1.Text); hashtable.Add((object)label1.Text, (object)num.ToString()); } else { hashtable.Add((object)label1.Text, (object)label2.Text); } } } if (!string.IsNullOrEmpty(text4)) { if (!text4.Contains("&")) { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text4); if (this.objTaxMasterDT.Rows.Count > 0) { string s = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString(); Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s) / new Decimal(100); Label label1 = new Label() { Text = this.gvTaskView.Rows[index].Cells[5].Text + "(" + s + ")" }; Label label2 = new Label() { Text = string.Concat((object)Decimal.Round(d, 2)) }; if (hashtable.ContainsKey((object)label1.Text)) { object obj = hashtable[(object)label1.Text]; Decimal num = d + Decimal.Parse(obj.ToString()); hashtable.Remove((object)label1.Text); hashtable.Add((object)label1.Text, (object)num.ToString()); } else { hashtable.Add((object)label1.Text, (object)label2.Text); } } } } } catch (Exception ex) { this.gvTaskView.Rows[index].Cells[4].Text = ""; this.gvTaskView.Rows[index].Cells[5].Text = ""; } } } if (this.gvItemView.Rows.Count > 0) { for (int index = 0; index < this.gvItemView.Rows.Count; ++index) { string text1 = this.gvItemView.Rows[index].Cells[2].Text; string text2 = this.gvItemView.Rows[index].Cells[3].Text; string text3 = this.gvItemView.Rows[index].Cells[4].Text; string text4 = this.gvItemView.Rows[index].Cells[5].Text; try { if (!string.IsNullOrEmpty(text3) && !text3.Contains("&")) { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text3); if (this.objTaxMasterDT.Rows.Count > 0) { string s = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString(); Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s) / new Decimal(100); Label label1 = new Label() { Text = this.gvItemView.Rows[index].Cells[4].Text + "(" + s + ")" }; Label label2 = new Label() { Text = string.Concat((object)Decimal.Round(d, 2)) }; if (hashtable.ContainsKey((object)label1.Text)) { object obj = hashtable[(object)label1.Text]; Decimal num = d + Decimal.Parse(obj.ToString()); hashtable.Remove((object)label1.Text); hashtable.Add((object)label1.Text, (object)num.ToString()); } else { hashtable.Add((object)label1.Text, (object)label2.Text); } } } if (!string.IsNullOrEmpty(text4)) { if (!text4.Contains("&")) { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text4); if (this.objTaxMasterDT.Rows.Count > 0) { string s = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString(); Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s) / new Decimal(100); Label label1 = new Label() { Text = this.gvItemView.Rows[index].Cells[5].Text + "(" + s + ")" }; Label label2 = new Label() { Text = string.Concat((object)Decimal.Round(d, 2)) }; if (hashtable.ContainsKey((object)label1.Text)) { object obj = hashtable[(object)label1.Text]; Decimal num = d + Decimal.Parse(obj.ToString()); hashtable.Remove((object)label1.Text); hashtable.Add((object)label1.Text, (object)num.ToString()); } else { hashtable.Add((object)label1.Text, (object)label2.Text); } } } } } catch (Exception ex) { this.gvItemView.Rows[index].Cells[4].Text = ""; this.gvItemView.Rows[index].Cells[5].Text = ""; } } } if (hashtable.Count > 0) { foreach (string str in (IEnumerable)hashtable.Keys) { this.divTaxView.Controls.Add((Control) new Label() { Text = str }); this.divTaxView.Controls.Add((Control) new LiteralControl("<br />")); } foreach (object obj in (IEnumerable)hashtable.Values) { this.divTaxValueView.Controls.Add((Control) new Label() { Text = ("+" + (object)Decimal.Round(Decimal.Parse(obj.ToString()), 2)) }); this.divTaxValueView.Controls.Add((Control) new LiteralControl("<br />")); } } Decimal d1 = new Decimal(0); if (this.gvItemView.Rows.Count > 0) { for (int index = 0; index < this.gvItemView.Rows.Count; ++index) { string text = this.gvItemView.Rows[index].Cells[6].Text; if (!string.IsNullOrEmpty(text)) { d1 += Decimal.Parse(text); } } } if (this.gvTaskView.Rows.Count > 0) { for (int index = 0; index < this.gvTaskView.Rows.Count; ++index) { string text = this.gvTaskView.Rows[index].Cells[6].Text; if (!string.IsNullOrEmpty(text)) { d1 += Decimal.Parse(text); } } } if (this.gvTaskView.Rows.Count <= 0 && this.gvItemView.Rows.Count <= 0) { d1 += Decimal.Parse(this.lblCreditAmount.Text); } this.lblSubTotalView.Text = Decimal.Round(d1, 2).ToString(); this.lblAddedTaxesView.Text = Decimal.Round(Decimal.Parse(this.lblCreditAmount.Text) - Decimal.Parse(this.lblSubTotalView.Text), 2).ToString(); this.objCompanyMasterDT = this.objCompanyMasterBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value)); this.imgLogo.ImageUrl = "../Handler/CompanyLogoFile.ashx?id=" + this.objCompanyMasterDT.Rows[0]["CompanyID"]; this.lblCompanyName.Text = this.objCompanyMasterDT.Rows[0]["CompanyName"].ToString(); string str1 = string.Empty; if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet1"].ToString())) { str1 = str1 + this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet1"] + ",<br />"; } if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet2"].ToString())) { str1 = str1 + this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet2"] + ",<br />"; } if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyCityID"].ToString())) { this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(this.objCompanyMasterDT.Rows[0]["CompanyCityID"].ToString())); if (this.objCityMasterDT.Rows.Count > 0) { str1 = str1 + this.objCityMasterDT.Rows[0]["CityName"] + " - "; } } if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyZipCode"].ToString())) { str1 = str1 + this.objCompanyMasterDT.Rows[0]["CompanyZipCode"] + ",<br />"; } if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyStateID"].ToString())) { this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(this.objCompanyMasterDT.Rows[0]["CompanyStateID"].ToString())); if (this.objStateMasterDT.Rows.Count > 0) { str1 = str1 + this.objStateMasterDT.Rows[0]["StateName"] + ",<br />"; } } if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyCountryID"].ToString())) { this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(this.objCompanyMasterDT.Rows[0]["CompanyCountryID"].ToString())); if (this.objCountryMasterDT.Rows.Count > 0) { str1 = str1 + this.objCountryMasterDT.Rows[0]["CountryName"] + ".<br />"; } } this.lblCompanyAddress.Text = str1; Label label3 = this.lblCompanyAddress; string str2 = label3.Text + (object)"Email: <a href=\"mailto:" + (string)this.objCompanyMasterDT.Rows[0]["CompanyEmail"] + "\">" + (string)this.objCompanyMasterDT.Rows[0]["CompanyEmail"] + "</a><br />"; label3.Text = str2; Label label4 = this.lblCompanyAddress; string str3 = label4.Text + (object)"Phone: " + (string)this.objCompanyMasterDT.Rows[0]["CompanyPhone"]; label4.Text = str3; this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(int.Parse(this.objCreditMasterDT.Rows[0]["ClientId"].ToString())); this.lblClientOrganizationName.Text = this.objCompanyClientMasterDT.Rows[0]["OrganizationName"].ToString(); this.lblClientFullName.Text = (string)this.objCompanyClientMasterDT.Rows[0]["FirstName"] + (object)" " + (string)this.objCompanyClientMasterDT.Rows[0]["LastName"]; string str4 = string.Empty + this.objCompanyClientMasterDT.Rows[0]["Address1"] + ",<br />" + this.objCompanyClientMasterDT.Rows[0]["Address2"] + ",<br />"; if (!string.IsNullOrEmpty(this.objCompanyClientMasterDT.Rows[0]["CityID"].ToString())) { this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(this.objCompanyClientMasterDT.Rows[0]["CityID"].ToString())); if (this.objCityMasterDT.Rows.Count > 0) { str4 = str4 + this.objCityMasterDT.Rows[0]["CityName"] + " "; } } if (!string.IsNullOrEmpty(this.objCompanyClientMasterDT.Rows[0]["StateID"].ToString())) { this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(this.objCompanyClientMasterDT.Rows[0]["StateID"].ToString())); if (this.objStateMasterDT.Rows.Count > 0) { str4 = str4 + this.objStateMasterDT.Rows[0]["StateName"] + " "; } } string str5 = string.Concat(new object[4] { (object)str4, (object)" - ", this.objCompanyClientMasterDT.Rows[0]["ZipCode"], (object)",<br />" }); if (!string.IsNullOrEmpty(this.objCompanyClientMasterDT.Rows[0]["CountryID"].ToString())) { this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(this.objCompanyClientMasterDT.Rows[0]["CountryID"].ToString())); str5 += this.objCountryMasterDT.Rows[0]["CountryName"].ToString(); } this.lblClientAddress.Text = str5; switch (this.objCreditMasterDT.Rows[0]["CreditStatus"].ToString()) { case "draft": this.divStatus.Attributes.Add("class", "status-draft"); break; case "draft-partial": this.divStatus.Attributes.Add("class", "status-draft-partial"); break; case "created": this.divStatus.Attributes.Add("class", "status-created"); break; case "sent": case "viewed": this.divStatus.Attributes.Add("class", "status-received"); break; case "disputed": this.divStatus.Attributes.Add("class", "status-disputed"); break; case "paid": this.divStatus.Attributes.Add("class", "status-paid"); break; case "partial": this.divStatus.Attributes.Add("class", "status-partial"); break; case "pending": this.divStatus.Attributes.Add("class", "status-pending"); break; case "declined": this.divStatus.Attributes.Add("class", "status-declined"); break; case "auto-paid": this.divStatus.Attributes.Add("class", "status-auto-paid"); break; case "retry": this.divStatus.Attributes.Add("class", "status-retry"); break; case "failed": this.divStatus.Attributes.Add("class", "status-failed"); break; case "replied": this.divStatus.Attributes.Add("class", "status-replied"); break; case "commented": this.divStatus.Attributes.Add("class", "status-commented"); break; case "resolved": this.divStatus.Attributes.Add("class", "status-resolved"); break; case "accepted": this.divStatus.Attributes.Add("class", "status-accepted"); break; case "Creditd": this.divStatus.Attributes.Add("class", "status-Creditd"); break; case "outstanding": this.divStatus.Attributes.Add("class", "status-outstanding"); break; case "open": this.divStatus.Attributes.Add("class", "status-open"); break; default: this.divStatus.Attributes.Add("class", "status-created"); break; } string s1 = this.objCreditMasterDT.Rows[0]["CurrencyID"].ToString(); if (string.IsNullOrEmpty(s1)) { return; } this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(s1)); if (this.objCurrencyMasterDT.Rows.Count <= 0) { return; } this.lblCurCodeView1.Text = this.lblCurCodeView2.Text = this.objCurrencyMasterDT.Rows[0]["CurrencyCode"].ToString(); this.lblCurSymbolView1.Text = this.lblCurSymbolView2.Text = this.objCurrencyMasterDT.Rows[0]["CurrencySymbol"].ToString(); } else { this.pnlViewAll.Visible = true; this.pnlView.Visible = false; this.BindGrid(); } }
protected void gv_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType != DataControlRowType.DataRow) { return; } string[] strArray = e.Row.Cells[2].Text.Split(' '); e.Row.Cells[2].Text = strArray[0]; string s1 = e.Row.Cells[5].Text.Replace(" ", ""); if (!string.IsNullOrEmpty(s1)) { e.Row.Cells[5].Text = Decimal.Round(Decimal.Parse(s1), 2).ToString(); } string s2 = e.Row.Cells[6].Text.Replace(" ", ""); if (!string.IsNullOrEmpty(s2)) { e.Row.Cells[6].Text = Decimal.Round(Decimal.Parse(s2), 2).ToString(); } string s3 = e.Row.Cells[9].Text.Replace(" ", ""); if (!string.IsNullOrEmpty(s3)) { e.Row.Cells[9].Text = Decimal.Round(Decimal.Parse(s3), 2).ToString(); } if (!string.IsNullOrEmpty(e.Row.Cells[7].Text.Replace(" ", ""))) { try { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxID(int.Parse(e.Row.Cells[7].Text)); if (this.objTaxMasterDT.Rows.Count > 0) { string s4 = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString(); string text = e.Row.Cells[9].Text; if (string.IsNullOrEmpty(text)) { if (string.IsNullOrEmpty(s4)) { goto label_15; } } Decimal d = Decimal.Parse(s4) * Decimal.Parse(text) / new Decimal(100); e.Row.Cells[7].Text = Decimal.Round(d, 2).ToString(); } else { e.Row.Cells[7].Text = "0.00"; } } catch (Exception ex) { e.Row.Cells[7].Text = "0.00"; } } else { e.Row.Cells[7].Text = "0.00"; } label_15: if (!string.IsNullOrEmpty(e.Row.Cells[8].Text.Replace(" ", ""))) { try { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxID(int.Parse(e.Row.Cells[8].Text)); if (this.objTaxMasterDT.Rows.Count > 0) { string s4 = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString(); string text = e.Row.Cells[9].Text; if (string.IsNullOrEmpty(text) && string.IsNullOrEmpty(s4)) { return; } Decimal d = Decimal.Parse(s4) * Decimal.Parse(text) / new Decimal(100); e.Row.Cells[8].Text = Decimal.Round(d, 2).ToString(); } else { e.Row.Cells[8].Text = "0.00"; } } catch (Exception ex) { e.Row.Cells[8].Text = "0.00"; } } else { e.Row.Cells[8].Text = "0.00"; } }