public virtual CloudAccountDA.CurrencyMasterDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; CloudAccountDA.CurrencyMasterDataTable dataTable = new CloudAccountDA.CurrencyMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
private void ViewRecord(string i) { this.objCloudPackageMasterDT = this.objCloudPackageMasterBll.GetDataByCloudPackageID(int.Parse(i)); if (this.objCloudPackageMasterDT.Rows.Count <= 0) { return; } this.hfPackage.Value = this.objCloudPackageMasterDT.Rows[0]["CloudPackageID"].ToString(); this.lblName.Text = this.objCloudPackageMasterDT.Rows[0]["CloudPackageName"].ToString(); this.lblPricePerMonth.Text = this.objCloudPackageMasterDT.Rows[0]["CloudPackagePriceMonthly"].ToString(); this.lblPricePerYear.Text = this.objCloudPackageMasterDT.Rows[0]["CloudPackagePriceYearly"].ToString(); this.lblDescription.Text = this.objCloudPackageMasterDT.Rows[0]["CloudPackageDescription"].ToString(); this.lblStatus.Text = this.objCloudPackageMasterDT.Rows[0]["CloudPackageStatus"].ToString() == "True" ? "True" : "False"; this.lblMonthCurrency.Text = this.objCloudPackageMasterDT.Rows[0]["CloudPackageCurrency"].ToString(); this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(this.lblMonthCurrency.Text)); this.lblMonthCurrency.Text = this.objCurrencyMasterDT.Rows[0]["CurrencyName"].ToString(); if (Convert.ToString(this.objCurrencyMasterDT.Rows[0]["CurrencySymbol"]) == "") { if (this.lblPricePerMonth.Text == "") { this.lblPricePerMonth.Text = "0.0"; } this.lblPricePerMonth.Text = "0" + (object)" " + (string)(object)Decimal.Round(Decimal.Parse(this.lblPricePerMonth.Text), 2); } else { if (this.lblPricePerMonth.Text == "") { this.lblPricePerMonth.Text = "0.0"; } this.lblPricePerMonth.Text = (string)this.objCurrencyMasterDT.Rows[0]["CurrencySymbol"] + (object)" " + Convert.ToString(Decimal.Round(Decimal.Parse(this.lblPricePerMonth.Text), 2)); } }
private void ViewRecord(string i) { this.objPackageMasterDT = this.objPackageMasterBll.GetDataByPackageID(int.Parse(i)); if (this.objPackageMasterDT.Rows.Count <= 0) { return; } this.hfPackage.Value = this.objPackageMasterDT.Rows[0]["PackageID"].ToString(); this.lblName.Text = this.objPackageMasterDT.Rows[0]["PackageName"].ToString(); this.lblAdminUsersMin.Text = this.objPackageMasterDT.Rows[0]["NoOfAdminUsersMin"].ToString(); this.lblAdminUsersMax.Text = this.objPackageMasterDT.Rows[0]["NoOfAdminUsersMax"].ToString(); this.lblStaffUsersMin.Text = this.objPackageMasterDT.Rows[0]["NoOfStaffUsersMin"].ToString(); this.lblStaffUsersMax.Text = this.objPackageMasterDT.Rows[0]["NoOfStaffUsersMax"].ToString(); this.lblPricePerMonth.Text = this.objPackageMasterDT.Rows[0]["PricePerMonth"].ToString(); this.lblPricePerYear.Text = this.objPackageMasterDT.Rows[0]["PricePerYear"].ToString(); this.lblDescription.Text = this.objPackageMasterDT.Rows[0]["Description"].ToString(); this.lblNoTrialDays.Text = this.objPackageMasterDT.Rows[0]["NoOfTrialDays"].ToString(); this.lblTrial.Text = this.objPackageMasterDT.Rows[0]["FreeTrialPackage"].ToString() == "True" ? "True" : "False"; this.lblStatus.Text = this.objPackageMasterDT.Rows[0]["Status"].ToString() == "True" ? "True" : "False"; this.NoOfTrialDaysView.Visible = bool.Parse(this.lblTrial.Text); this.lblMonthCurrency.Text = this.objPackageMasterDT.Rows[0]["MonthlyPriceCurrencyID"].ToString(); this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(this.lblMonthCurrency.Text)); this.lblMonthCurrency.Text = this.objCurrencyMasterDT.Rows[0]["CurrencyName"].ToString(); this.lblYearlyCurrency.Text = this.objPackageMasterDT.Rows[0]["YearlyPriceCurrencyID"].ToString(); this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(this.lblYearlyCurrency.Text)); this.lblYearlyCurrency.Text = this.objCurrencyMasterDT.Rows[0]["CurrencyName"].ToString(); }
protected string GetCurrency(string cID) { this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(cID)); if (this.objCurrencyMasterDT.Rows.Count > 0) { return(this.objCurrencyMasterDT.Rows[0]["CurrencySymbol"].ToString()); } return(""); }
public virtual int Fill(CloudAccountDA.CurrencyMasterDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (this.ClearBeforeFill) { dataTable.Clear(); } return(this.Adapter.Fill(dataTable)); }
protected string GetCurrency(string curId) { this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(curId)); if (this.objCurrencyMasterDT.Rows.Count > 0) { return("(" + this.objCurrencyMasterDT.Rows[0]["CurrencySymbol"] + ")"); } return(""); }
protected string GetCurrency(string invId) { this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByInvoiceID(int.Parse(invId)); this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(this.objInvoiceMasterDT.Rows[0]["CurrencyID"].ToString())); if (this.objCurrencyMasterDT.Rows.Count > 0) { return("(" + this.objCurrencyMasterDT.Rows[0]["CurrencySymbol"] + ")"); } return(""); }
private void SetRecord(string iD) { this.objPackageMasterDT = this.objPackageMasterBll.GetDataByPackageID(int.Parse(iD)); if (this.objPackageMasterDT.Rows.Count <= 0) { return; } this.hfPackage.Value = this.objPackageMasterDT.Rows[0]["PackageID"].ToString(); this.chkTrial.Checked = this.objPackageMasterDT.Rows[0]["FreeTrialPackage"].ToString() == "True"; this.chkTrial_CheckedChanged((object)null, (EventArgs)null); this.txtName.Text = this.objPackageMasterDT.Rows[0]["PackageName"].ToString(); this.txtAdminUsersMin.Text = this.objPackageMasterDT.Rows[0]["NoOfAdminUsersMin"].ToString(); this.txtAdminUsersMax.Text = this.objPackageMasterDT.Rows[0]["NoOfAdminUsersMax"].ToString(); this.txtStaffUsersMin.Text = this.objPackageMasterDT.Rows[0]["NoOfStaffUsersMin"].ToString(); this.txtStaffUsersMax.Text = this.objPackageMasterDT.Rows[0]["NoOfStaffUsersMax"].ToString(); this.txtPricePerMonth.Text = this.objPackageMasterDT.Rows[0]["PricePerMonth"].ToString(); this.txtPricePerYear.Text = this.objPackageMasterDT.Rows[0]["PricePerYear"].ToString(); this.txtDescription.Text = this.objPackageMasterDT.Rows[0]["Description"].ToString(); this.txtNoTrialDays.Text = this.objPackageMasterDT.Rows[0]["NoOfTrialDays"].ToString(); this.chkStatus.Checked = this.objPackageMasterDT.Rows[0]["Status"].ToString() == "True"; this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(this.objPackageMasterDT.Rows[0]["MonthlyPriceCurrencyID"].ToString())); if (this.objCurrencyMasterDT.Rows.Count > 0) { this.ddlMonthCurrency.Items.Add(this.objCurrencyMasterDT.Rows[0]["CurrencyID"].ToString()); this.ddlMonthCurrency.SelectedValue = this.objCurrencyMasterDT.Rows[0]["CurrencyID"].ToString(); } this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(this.objPackageMasterDT.Rows[0]["YearlyPriceCurrencyID"].ToString())); if (this.objCurrencyMasterDT.Rows.Count > 0) { this.ddlYearlyCurrency.Items.Add(this.objCurrencyMasterDT.Rows[0]["CurrencyID"].ToString()); this.ddlYearlyCurrency.SelectedValue = this.objCurrencyMasterDT.Rows[0]["CurrencyID"].ToString(); } this.objPackageDetailsDT = this.objPackageDetailsBll.GetDataByPackageID(int.Parse(this.hfPackage.Value)); for (int index = 0; index < this.objPackageDetailsDT.Rows.Count; ++index) { Label label1 = (Label)this.gvPackageDetails.Rows[index].FindControl("lnkModuleID"); Label label2 = (Label)this.gvPackageDetails.Rows[index].FindControl("lnkModuleName"); CheckBox checkBox = (CheckBox)this.gvPackageDetails.Rows[index].FindControl("chkModuleStatus"); string str1 = this.objPackageDetailsDT.Rows[index]["ModuleID"].ToString(); string str2 = this.objPackageDetailsDT.Rows[index]["ModuleName"].ToString(); bool flag = Convert.ToBoolean(this.objPackageDetailsDT.Rows[index]["ModuleStatus"].ToString()); label1.Text = str1; label2.Text = str2; if (flag) { checkBox.Checked = true; } } }
public virtual CloudAccountDA.CurrencyMasterDataTable GetDataByCurrencyName(string CurrencyName) { this.Adapter.SelectCommand = this.CommandCollection[4]; if (CurrencyName == null) { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = CurrencyName; } CloudAccountDA.CurrencyMasterDataTable dataTable = new CloudAccountDA.CurrencyMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual CloudAccountDA.CurrencyMasterDataTable GetDataByCountryID(int?CountryID) { this.Adapter.SelectCommand = this.CommandCollection[1]; if (CountryID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = CountryID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } CloudAccountDA.CurrencyMasterDataTable dataTable = new CloudAccountDA.CurrencyMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
private void ViewRecord(string i) { this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(i)); if (this.objCurrencyMasterDT.Rows.Count <= 0) { return; } this.hfCurrency.Value = this.objCurrencyMasterDT.Rows[0]["CurrencyID"].ToString(); this.lblCode.Text = this.objCurrencyMasterDT.Rows[0]["CurrencyCode"].ToString(); this.lblName.Text = this.objCurrencyMasterDT.Rows[0]["CurrencyName"].ToString(); this.lblSymbol.Text = this.objCurrencyMasterDT.Rows[0]["CurrencySymbol"].ToString(); this.lblDesc.Text = this.objCurrencyMasterDT.Rows[0]["CurrencyDesc"].ToString(); this.lblStatus.Text = this.objCurrencyMasterDT.Rows[0]["CurrencyStatus"].ToString(); this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(this.objCurrencyMasterDT.Rows[0]["CountryID"].ToString())); this.lblCountry.Text = this.objCountryMasterDT.Rows[0]["CountryName"].ToString(); }
private void SetInvoiceRecord(string sId) { this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByInvoiceID(int.Parse(sId)); if (this.objInvoiceMasterDT.Rows.Count <= 0) { return; } this.hfInvoiceID.Value = this.objInvoiceMasterDT.Rows[0]["InvoiceID"].ToString(); this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(this.objInvoiceMasterDT.Rows[0]["CurrencyID"].ToString())); if (this.objCurrencyMasterDT.Rows.Count > 0) { this.lblCurrencyCode.Text = this.objCurrencyMasterDT.Rows[0]["CurrencyCode"].ToString(); } this.lblInvoiceAmt.Text = this.objInvoiceMasterDT.Rows[0]["InvoiceTotal"].ToString(); Label label1 = this.lblBalance; Label label2 = this.lblInvoiceAmt; Decimal num = Decimal.Round(Decimal.Parse(this.lblInvoiceAmt.Text), 2); string str1; string str2 = str1 = num.ToString(); label2.Text = str1; string str3 = str2; label1.Text = str3; this.gvPaymentOld.DataBind(); this.divOldData.Visible = this.gvPaymentOld.Rows.Count > 0; if (this.gvPaymentOld.Rows.Count > 0) { Decimal d = new Decimal(0); for (int index = 0; index < this.gvPaymentOld.Rows.Count; ++index) { string text = this.gvPaymentOld.Rows[index].Cells[3].Text; d += Decimal.Parse(text); } this.lblTotalPaid.Text = Decimal.Round(d, 2).ToString(); } this.lblBalance.Text = (Decimal.Parse(this.lblInvoiceAmt.Text) - Decimal.Parse(this.lblTotalPaid.Text)).ToString(); this.lblBalance.Text = Decimal.Round(Decimal.Parse(this.lblBalance.Text), 2).ToString(); this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(int.Parse(this.objInvoiceMasterDT.Rows[0]["ClientID"].ToString())); string newValue = this.objCompanyClientMasterDT.Rows[0]["OrganizationName"].ToString(); this.lblPaymentInfo.Text = "Invoice #" + this.GetInvoiceNumber(sId).Replace("Invoice", "") + " for " + newValue; this.chkEmail.Text = this.chkEmail.Text.Replace("company", newValue); }
protected void gvPackage_OnRowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType != DataControlRowType.DataRow) { return; } this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(e.Row.Cells[2].Text)); if (this.objCurrencyMasterDT.Rows.Count <= 0) { return; } e.Row.Cells[2].Text = string.Concat(new object[4] { this.objCurrencyMasterDT.Rows[0]["CurrencyName"], (object)" (", this.objCurrencyMasterDT.Rows[0]["CurrencySymbol"], (object)")" }); }
private void SetRecord(string iD) { this.objCloudPackageMasterDT = this.objCloudPackageMasterBll.GetDataByCloudPackageID(int.Parse(iD)); if (this.objCloudPackageMasterDT.Rows.Count <= 0) { return; } this.hfPackage.Value = this.objCloudPackageMasterDT.Rows[0]["CloudPackageID"].ToString(); this.txtName.Text = this.objCloudPackageMasterDT.Rows[0]["CloudPackageName"].ToString(); this.txtPricePerMonth.Text = this.objCloudPackageMasterDT.Rows[0]["CloudPackagePriceMonthly"].ToString(); this.txtPricePerYear.Text = this.objCloudPackageMasterDT.Rows[0]["CloudPackagePriceYearly"].ToString(); this.txtDescription.Text = this.objCloudPackageMasterDT.Rows[0]["CloudPackageDescription"].ToString(); this.chkStatus.Checked = this.objCloudPackageMasterDT.Rows[0]["CloudPackageStatus"].ToString() == "True"; this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(this.objCloudPackageMasterDT.Rows[0]["CloudPackageCurrency"].ToString())); if (this.objCurrencyMasterDT.Rows.Count > 0) { this.ddlMonthCurrency.Items.Add(this.objCurrencyMasterDT.Rows[0]["CurrencyID"].ToString()); this.ddlMonthCurrency.SelectedValue = this.objCurrencyMasterDT.Rows[0]["CurrencyID"].ToString(); } this.objCloudPackageDetailsDT = this.objCloudPackageDetailsBll.GetDataByCloudPackageID(int.Parse(this.hfPackage.Value)); for (int index = 0; index < this.objCloudPackageDetailsDT.Rows.Count; ++index) { RadioButtonList radioButtonList = (RadioButtonList)this.gvAddModule.Rows[index].FindControl("rblInput"); string str = this.objCloudPackageDetailsDT.Rows[index]["CloudPackageDetailValue"].ToString(); if (str == "True" || str == "False") { radioButtonList.SelectedValue = "2"; this.rblInput_SelectedIndexChanged((object)radioButtonList, (EventArgs)null); CheckBox checkBox = (CheckBox)this.gvAddModule.Rows[index].FindControl("chkValue"); checkBox.Visible = true; checkBox.Checked = bool.Parse(str); } else { radioButtonList.SelectedValue = "1"; this.rblInput_SelectedIndexChanged((object)radioButtonList, (EventArgs)null); TextBox textBox = (TextBox)this.gvAddModule.Rows[index].FindControl("txtValue"); textBox.Visible = true; textBox.Text = str; } } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { if (!this.Page.IsValid) { return; } this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyName(this.txtName.Text.Trim()); if (this.objCurrencyMasterDT.Rows.Count > 0) { this.DisplayAlert("Currency is already entered...!"); CurrencyMaster.checkInDB = this.objCurrencyMasterDT.Rows.Count > 0; } this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCountryID(int.Parse(this.ddlCountry.SelectedItem.Value)); if (this.objCurrencyMasterDT.Rows.Count > 0) { this.DisplayAlert("Country currency is already entered...!"); CurrencyMaster.checkInDB = this.objCurrencyMasterDT.Rows.Count > 0; } if (CurrencyMaster.checkInDB) { return; } int num = this.objCurrencyMasterBll.AddCurrency(int.Parse(this.ddlCountry.SelectedItem.Value), this.txtCode.Text.Trim(), this.txtName.Text.Trim(), this.txtSymbol.Text.Trim(), this.txtDesc.Text.Trim(), this.chkStatus.Checked); if (num != 0) { this.DisplayAlert("Details Added Successfully."); this.Response.Redirect("~/BillTransact/CurrencyMaster.aspx?cmd=view&ID=" + (object)num); } else { this.DisplayAlert("Fail to Add New Details."); } } catch (Exception ex) { this.DisplayAlert(ex.Message); throw; } }
private void SetRecord(string iD) { this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(iD)); if (this.objCurrencyMasterDT.Rows.Count <= 0) { return; } this.hfCurrency.Value = this.objCurrencyMasterDT.Rows[0]["CurrencyID"].ToString(); this.txtCode.Text = this.objCurrencyMasterDT.Rows[0]["CurrencyCode"].ToString(); this.txtName.Text = this.objCurrencyMasterDT.Rows[0]["CurrencyName"].ToString(); this.txtSymbol.Text = this.objCurrencyMasterDT.Rows[0]["CurrencySymbol"].ToString(); this.txtDesc.Text = this.objCurrencyMasterDT.Rows[0]["CurrencyDesc"].ToString(); this.chkStatus.Checked = bool.Parse(this.objCurrencyMasterDT.Rows[0]["CurrencyStatus"].ToString()); this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(this.objCurrencyMasterDT.Rows[0]["CountryID"].ToString())); if (this.objCountryMasterDT.Rows.Count <= 0) { return; } this.ddlCountry.Items.Add(this.objCountryMasterDT.Rows[0]["CountryID"].ToString()); this.ddlCountry.SelectedValue = this.objCountryMasterDT.Rows[0]["CountryID"].ToString(); }
protected void btnUpdate_Click(object sender, EventArgs e) { try { if (!this.Page.IsValid) { return; } this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyNameUpdate(int.Parse(this.hfCurrency.Value), this.txtName.Text.Trim()); if (this.objCurrencyMasterDT.Rows.Count > 0) { this.DisplayAlert("Currency is already entered...!"); CurrencyMaster.checkInDB = this.objCurrencyMasterDT.Rows.Count > 0; } this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCountryIDUpdate(int.Parse(this.hfCurrency.Value), int.Parse(this.ddlCountry.SelectedItem.Value)); if (this.objCurrencyMasterDT.Rows.Count > 0) { this.DisplayAlert("Country currency is already entered...!"); CurrencyMaster.checkInDB = this.objCurrencyMasterDT.Rows.Count > 0; } if (CurrencyMaster.checkInDB) { return; } if (this.objCurrencyMasterBll.UpdateCurrency(int.Parse(this.hfCurrency.Value), int.Parse(this.ddlCountry.SelectedItem.Value), this.txtCode.Text.Trim(), this.txtName.Text.Trim(), this.txtSymbol.Text.Trim(), this.txtDesc.Text.Trim(), this.chkStatus.Checked)) { this.DisplayAlert("Details Updated Successfully."); this.Response.Redirect("~/BillTransact/CurrencyMaster.aspx?cmd=view&ID=" + this.Request.QueryString["ID"]); } else { this.DisplayAlert("Fail to Update Details."); } } catch (Exception ex) { this.DisplayAlert(ex.Message); throw; } }
private void GetInvoiceTotal() { if (this.gvInvoice.Rows.Count > 0) { Decimal d = new Decimal(0); for (int index = 0; index < this.gvInvoice.Rows.Count; ++index) { string text = this.gvInvoice.Rows[index].Cells[3].Text; if (!string.IsNullOrEmpty(text)) { d += Decimal.Parse(text); } } this.lblTotal.Text = Decimal.Round(d, 2).ToString(); } else { this.lblTotal.Text = "0.00"; } this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(int.Parse(this.hfClientID.Value)); string s = this.objCompanyClientMasterDT.Rows[0]["CurrencyID"].ToString(); if (!string.IsNullOrEmpty(s)) { this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(s)); if (this.objCurrencyMasterDT.Rows.Count <= 0) { return; } this.lblCurCode.Text = this.objCurrencyMasterDT.Rows[0]["CurrencyCode"].ToString(); } else { this.lblCurCode.Text = "NGN"; } }
protected void rpPackage_OnItemCommand(object source, RepeaterCommandEventArgs e) { if (!(e.CommandName == "openPopup")) { return; } ModalPopupExtender modalPopupExtender = (ModalPopupExtender)e.Item.FindControl("mpPackage"); Button button = (Button)e.Item.FindControl("btnClick"); this.lblError.Text = ""; this.hfPackageID.Value = button.CommandArgument; this.lblPackageName1.Text = this.lblPackageName.Text = button.ToolTip; if (!string.IsNullOrEmpty(this.hfPackageID.Value)) { this.objCloudPackageMasterDT = this.objCloudPackageMasterBll.GetDataByCloudPackageID(int.Parse(this.hfPackageID.Value)); if (this.objCloudPackageMasterDT.Rows.Count > 0) { this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(this.objCloudPackageMasterDT.Rows[0]["CloudPackageCurrency"].ToString())); this.lblPriceMonth1.Text = this.lblPriceMonth.Text = (string)this.objCurrencyMasterDT.Rows[0]["CurrencySymbol"] + (object)" " + (string)this.objCloudPackageMasterDT.Rows[0]["CloudPackagePriceMonthly"]; this.lblPriceYear1.Text = this.lblPriceYear.Text = (string)this.objCurrencyMasterDT.Rows[0]["CurrencySymbol"] + (object)" " + (string)this.objCloudPackageMasterDT.Rows[0]["CloudPackagePriceYearly"]; } } modalPopupExtender.Show(); }
private bool ViewRecord(string i) { this.objPackageMasterDT = this.objPackageMasterBll.GetDataByPackageID(int.Parse(i)); if (this.objPackageMasterDT.Rows.Count <= 0) { return(false); } this.hfPackageID.Value = this.objPackageMasterDT.Rows[0]["PackageID"].ToString(); this.lblAdminUsersMin.Text = this.objPackageMasterDT.Rows[0]["NoOfAdminUsersMin"].ToString(); this.lblAdminUsersMax.Text = this.objPackageMasterDT.Rows[0]["NoOfAdminUsersMax"].ToString(); this.lblStaffUsersMin.Text = this.objPackageMasterDT.Rows[0]["NoOfStaffUsersMin"].ToString(); this.lblStaffUsersMax.Text = this.objPackageMasterDT.Rows[0]["NoOfStaffUsersMax"].ToString(); string s1 = this.objPackageMasterDT.Rows[0]["PricePerMonth"].ToString(); if (!string.IsNullOrEmpty(s1)) { this.lblPricePerMonth.Text = Decimal.Round(Decimal.Parse(s1), 2).ToString((IFormatProvider)CultureInfo.InvariantCulture); } string s2 = this.objPackageMasterDT.Rows[0]["PricePerYear"].ToString(); if (!string.IsNullOrEmpty(s2)) { this.lblPricePerYear.Text = Decimal.Round(Decimal.Parse(s2), 2).ToString((IFormatProvider)CultureInfo.InvariantCulture); } this.lblDescription.Text = this.objPackageMasterDT.Rows[0]["Description"].ToString(); this.lblNoTrialDays.Text = this.objPackageMasterDT.Rows[0]["NoOfTrialDays"].ToString(); this.lblTrial.Text = this.objPackageMasterDT.Rows[0]["FreeTrialPackage"].ToString() == "True" ? "True" : "False"; this.NoOfTrialDaysView.Visible = bool.Parse(this.lblTrial.Text); this.lblMonthCurrency.Text = this.objPackageMasterDT.Rows[0]["MonthlyPriceCurrencyID"].ToString(); this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(this.lblMonthCurrency.Text)); this.lblMonthCurrency.Text = this.objCurrencyMasterDT.Rows[0]["CurrencySymbol"].ToString(); this.lblYearlyCurrency.Text = this.objPackageMasterDT.Rows[0]["YearlyPriceCurrencyID"].ToString(); this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(this.lblYearlyCurrency.Text)); this.lblYearlyCurrency.Text = this.objCurrencyMasterDT.Rows[0]["CurrencySymbol"].ToString(); return(true); }
public virtual int Update(CloudAccountDA.CurrencyMasterDataTable dataTable) { return(this.Adapter.Update(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(); }
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(); } }
private void SetRecord(string iD) { this.objCompanyMasterDT = this.objCompanyMasterBll.GetDataByCompanyID(int.Parse(iD)); if (this.objCompanyMasterDT.Rows.Count <= 0) { return; } this.hfCompanyID.Value = this.objCompanyMasterDT.Rows[0]["CompanyID"].ToString(); this.txtCompanyName.Text = this.objCompanyMasterDT.Rows[0]["CompanyName"].ToString(); this.txtCompanyUserName.Text = this.objCompanyMasterDT.Rows[0]["CompanyUserName"].ToString(); this.txtPhoneNumber.Text = this.objCompanyMasterDT.Rows[0]["CompanyPhone"].ToString(); this.txtFaxNumber.Text = this.objCompanyMasterDT.Rows[0]["CompanyFax"].ToString(); this.txtEmail.Text = this.objCompanyMasterDT.Rows[0]["CompanyEmail"].ToString(); this.txtAddress1.Text = this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet1"].ToString(); this.txtAddress2.Text = this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet2"].ToString(); this.txtZipCode.Text = this.objCompanyMasterDT.Rows[0]["CompanyZipCode"].ToString(); this.txtNotes.Text = this.objCompanyMasterDT.Rows[0]["CompanyNotes"].ToString(); 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) { this.ddlCountry.Items.Add(this.objCountryMasterDT.Rows[0]["CountryID"].ToString()); this.ddlCountry.SelectedValue = this.objCountryMasterDT.Rows[0]["CountryID"].ToString(); } } 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) { this.ddlState.Items.Add(this.objStateMasterDT.Rows[0]["StateID"].ToString()); this.ddlState.SelectedValue = this.objStateMasterDT.Rows[0]["StateID"].ToString(); } } 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) { this.ddlCity.Items.Add(this.objCityMasterDT.Rows[0]["CityID"].ToString()); this.ddlCity.SelectedValue = this.objCityMasterDT.Rows[0]["CityID"].ToString(); } } if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["BussinessID"].ToString())) { this.objBussinessMasterDT = this.objBussinessMasterBll.GetDataByBussinessID(int.Parse(this.objCompanyMasterDT.Rows[0]["BussinessID"].ToString())); if (this.objBussinessMasterDT.Rows.Count > 0) { this.ddlBussiness.Items.Add(this.objBussinessMasterDT.Rows[0]["BussinessID"].ToString()); this.ddlBussiness.SelectedValue = this.objBussinessMasterDT.Rows[0]["BussinessID"].ToString(); } } if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["IndustryID"].ToString())) { this.objIndustryMasterDT = this.objIndustryMasterBll.GetDataByIndustryID(int.Parse(this.objCompanyMasterDT.Rows[0]["IndustryID"].ToString())); if (this.objIndustryMasterDT.Rows.Count > 0) { this.ddlIndustry.Items.Add(this.objIndustryMasterDT.Rows[0]["IndustryID"].ToString()); this.ddlIndustry.SelectedValue = this.objIndustryMasterDT.Rows[0]["IndustryID"].ToString(); } } if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CurrencyID"].ToString())) { this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(this.objCompanyMasterDT.Rows[0]["CurrencyID"].ToString())); if (this.objCurrencyMasterDT.Rows.Count > 0) { this.ddlCurrency.Items.Add(this.objCurrencyMasterDT.Rows[0]["CurrencyID"].ToString()); this.ddlCurrency.SelectedValue = this.objCurrencyMasterDT.Rows[0]["CurrencyID"].ToString(); } } this.txtCompanyUserName.Enabled = false; this.txtEmail.Enabled = false; }