protected void Page_Load(object sender, EventArgs e) { if (this.Master == null) { return; } ((HtmlControl)this.Master.FindControl("invoice")).Attributes.Add("class", "active open"); ((HtmlControl)this.Master.FindControl("unpaidInvoice")).Attributes.Add("class", "active open"); MembershipUser user = Membership.GetUser(); if (user != null) { this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByUsername(user.ToString()); if (this.objCompanyClientMasterDT.Rows.Count > 0) { this.hfClientID.Value = this.objCompanyClientMasterDT.Rows[0]["CompanyClientID"].ToString(); this.hfCompanyID.Value = this.objCompanyClientMasterDT.Rows[0]["CompanyID"].ToString(); } this.objCompanyClientContactDetailDT = this.objCompanyClientContactDetailBll.GetDataByUsername(user.ToString()); if (this.objCompanyClientContactDetailDT.Rows.Count > 0) { this.hfClientContactID.Value = this.objCompanyClientContactDetailDT.Rows[0]["CompanyClientContactID"].ToString(); this.hfClientID.Value = this.objCompanyClientContactDetailDT.Rows[0]["CompanyClientID"].ToString(); this.hfCompanyID.Value = this.objCompanyClientContactDetailDT.Rows[0]["CompanyID"].ToString(); } this.SetMiscValues(this.hfCompanyID.Value); } if (this.IsPostBack) { return; } this.BindGrid(); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { MembershipUser user = Membership.GetUser(); if (user != null) { this.objClientMasterDT = this.objClientMasterBll.GetDataByUsername(user.ToString()); if (this.objClientMasterDT.Rows.Count > 0) { query = this.objClientMasterDT.Rows[0]["CompanyID"].ToString(); } else { this.objCompanyClientContactDetailDT = this.objCompanyClientContactDetailBll.GetDataByUsername(user.ToString()); if (this.objCompanyClientContactDetailDT.Rows.Count > 0) { query = this.objCompanyClientContactDetailDT.Rows[0]["CompanyID"].ToString(); } } SetCompanyLogo(query); } if (Request.UrlReferrer != null) { query = HttpUtility.ParseQueryString(Request.UrlReferrer.Query)["Status"]; if (query.ToLower() == "success") { query = HttpUtility.ParseQueryString(Request.UrlReferrer.Query)["OrderNo"]; Dbutility dbutility = new Dbutility(); query = dbutility.ExecuteQuery("Update InvoiceMaster Set InvoiceStatus='paid' Where OrderNo='" + query + "'"); } } } }
protected void Page_Load(object sender, EventArgs e) { if (this.Master == null) { return; } ((HtmlControl)this.Master.FindControl("Estimate")).Attributes.Add("class", "active open"); ((HtmlControl)this.Master.FindControl("newEstimate")).Attributes.Add("class", "active open"); MembershipUser user = Membership.GetUser(); if (user != null) { this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByUsername(user.ToString()); if (this.objCompanyClientMasterDT.Rows.Count > 0) { this.hfClientID.Value = this.objCompanyClientMasterDT.Rows[0]["CompanyClientID"].ToString(); this.hfCompanyID.Value = this.objCompanyClientMasterDT.Rows[0]["CompanyID"].ToString(); } this.objCompanyClientContactDetailDT = this.objCompanyClientContactDetailBll.GetDataByUsername(user.ToString()); if (this.objCompanyClientContactDetailDT.Rows.Count > 0) { this.hfClientContactID.Value = this.objCompanyClientContactDetailDT.Rows[0]["CompanyClientContactID"].ToString(); this.hfClientID.Value = this.objCompanyClientContactDetailDT.Rows[0]["CompanyClientID"].ToString(); this.hfCompanyID.Value = this.objCompanyClientContactDetailDT.Rows[0]["CompanyID"].ToString(); } this.SetMiscValues(this.hfCompanyID.Value); } if (this.IsPostBack) { return; } if (this.Request.QueryString["cmd"] != null) { switch (this.Request.QueryString["cmd"]) { case "view": if (this.Request.QueryString["ID"] == null) { break; } string id = this.Request.QueryString["ID"]; this.pnlView.Visible = true; this.pnlViewAll.Visible = false; this.ViewRecord(id); break; default: this.pnlViewAll.Visible = true; this.pnlView.Visible = false; this.BindGrid(); break; } } else { this.pnlViewAll.Visible = true; this.pnlView.Visible = false; this.BindGrid(); } }
protected void Page_Load(object sender, EventArgs e) { MembershipUser user = Membership.GetUser(); if (user != null) { this.objClientMasterDT = this.objClientMasterBll.GetDataByUsername(user.ToString()); if (this.objClientMasterDT.Rows.Count > 0) { this.hfClientID.Value = this.objClientMasterDT.Rows[0]["CompanyClientID"].ToString(); this.hfCompanyID.Value = this.objClientMasterDT.Rows[0]["CompanyID"].ToString(); this.SetMenu(); this.Estimate.Visible = true; } this.objCompanyClientContactDetailDT = this.objCompanyClientContactDetailBll.GetDataByUsername(user.ToString()); if (this.objCompanyClientContactDetailDT.Rows.Count > 0) { this.hfClientContactID.Value = this.objCompanyClientContactDetailDT.Rows[0]["CompanyClientContactID"].ToString(); this.hfClientID.Value = this.objCompanyClientContactDetailDT.Rows[0]["CompanyClientID"].ToString(); this.hfCompanyID.Value = this.objCompanyClientContactDetailDT.Rows[0]["CompanyID"].ToString(); this.SetMenu(); this.Estimate.Visible = false; } } if (this.IsPostBack) { return; } this.SetCompanyLogo(); }
protected void Page_Load(object sender, EventArgs e) { if (this.Master == null) { return; } ((HtmlControl)this.Master.FindControl("home")).Attributes.Add("class", "active open"); ((HtmlControl)this.Master.FindControl("mainHome")).Attributes.Add("class", "active open"); MembershipUser user = Membership.GetUser(); if (user == null) { return; } this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByUsername(user.ToString()); if (this.objCompanyClientMasterDT.Rows.Count > 0) { this.hfClientID.Value = this.objCompanyClientMasterDT.Rows[0]["CompanyClientID"].ToString(); this.hfCompanyID.Value = this.objCompanyClientMasterDT.Rows[0]["CompanyID"].ToString(); this.lblClientInfo.Text = "Company Client"; } this.objCompanyClientContactDetailDT = this.objCompanyClientContactDetailBll.GetDataByUsername(user.ToString()); if (this.objCompanyClientContactDetailDT.Rows.Count > 0) { this.hfClientContactID.Value = this.objCompanyClientContactDetailDT.Rows[0]["CompanyClientContactID"].ToString(); this.hfClientID.Value = this.objCompanyClientContactDetailDT.Rows[0]["CompanyClientID"].ToString(); this.hfCompanyID.Value = this.objCompanyClientContactDetailDT.Rows[0]["CompanyID"].ToString(); this.lblClientInfo.Text = "Company Client Contact"; } this.SetWelcomeMessage(this.hfCompanyID.Value); }
private bool CheckEmail(string email) { this.objCompanyClientContactDetailDT = this.objCompanyClientContactDetailBll.GetDataByCompanyEmail(int.Parse(this.hfCompanyID.Value), email.Trim()); this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyEmail(int.Parse(this.hfCompanyID.Value), email.Trim()); this.objStaffMasterDT = this.objStaffMasterBll.GetDataByCompanyEmail(int.Parse(this.hfCompanyID.Value), email.Trim()); this.objContractorMasterDT = this.objContractorMasterBll.GetDataByCompanyEmail(int.Parse(this.hfCompanyID.Value), email.Trim()); this.objCompanyMasterDT = this.objCompanyMasterBll.GetDataByCompanyEmail(email.Trim()); if (this.objCompanyMasterDT.Rows.Count > 0) { return(this.hfCompanyID.Value == this.objCompanyMasterDT.Rows[0]["CompanyID"].ToString() ? true : true); } return(this.objCompanyClientMasterDT.Rows.Count > 0 || this.objCompanyClientContactDetailDT.Rows.Count > 0 || (this.objStaffMasterDT.Rows.Count > 0 || this.objContractorMasterDT.Rows.Count > 0)); }
protected void gvCredit_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(int.Parse(e.Row.Cells[2].Text)); e.Row.Cells[2].Text = this.objCompanyClientMasterDT.Rows[0]["OrganizationName"].ToString(); } BoundField boundField = ((GridView)sender).Columns[3] as BoundField; if (boundField == null) { return; } boundField.DataFormatString = "{0:" + this.dateFormat + "}"; }
protected string GetClientName(string cId) { if (!string.IsNullOrEmpty(cId)) { if (cId == "0") { return("- internal -"); } this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(int.Parse(cId)); if (this.objCompanyClientMasterDT.Rows.Count > 0) { return((string)this.objCompanyClientMasterDT.Rows[0]["OrganizationName"] + (object)" (" + (string)this.objCompanyClientMasterDT.Rows[0]["LastName"] + "," + (string)this.objCompanyClientMasterDT.Rows[0]["FirstName"] + ")"); } } return(""); }
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 string SetName(string id, string role) { switch (role) { case "Company": this.objCompanyMasterDT = this.objCompanyMasterBll.GetDataByCompanyID(int.Parse(id)); return(this.objCompanyMasterDT.Rows[0]["CompanyContactPerson"].ToString()); case "CompanyClientContact": this.objCompanyClientContactDetailDT = this.objCompanyClientContactDetailBll.GetDataByCompanyClientContactID(int.Parse(id)); return((string)this.objCompanyClientContactDetailDT.Rows[0]["FirstName"] + (object)" " + (string)this.objCompanyClientContactDetailDT.Rows[0]["LastName"]); case "CompanyClient": this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(int.Parse(id)); return((string)this.objCompanyClientMasterDT.Rows[0]["FirstName"] + (object)" " + (string)this.objCompanyClientMasterDT.Rows[0]["LastName"]); default: return(string.Empty); } }
protected void txtEmail_OnTextChanged(object sender, EventArgs e) { this.objCompanyClientContactDetailDT = this.objCompanyClientContactDetailBll.GetDataByCompanyEmail(int.Parse(this.hfCompanyID.Value), this.txtEmail.Text.Trim()); this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyEmail(int.Parse(this.hfCompanyID.Value), this.txtEmail.Text.Trim()); this.objStaffMasterDT = this.objStaffMasterBll.GetDataByCompanyEmail(int.Parse(this.hfCompanyID.Value), this.txtEmail.Text.Trim()); this.objContractorMasterDT = this.objContractorMasterBll.GetDataByCompanyEmail(int.Parse(this.hfCompanyID.Value), this.txtEmail.Text.Trim()); this.objCompanyMasterDT = this.objCompanyMasterBll.GetDataByCompanyEmail(this.txtEmail.Text.Trim()); if (this.objCompanyMasterDT.Rows.Count > 0) { this.DisplayAlert("Email Already Register With System."); ScriptManager.RegisterClientScriptBlock(sender as Control, this.GetType(), "alert", "alert('Email Already Register With System.')", true); this.txtEmail.Text = ""; this.txtEmail.Focus(); } else if (this.objCompanyClientMasterDT.Rows.Count > 0 || this.objCompanyClientContactDetailDT.Rows.Count > 0) { this.DisplayAlert("Email Already Register With System To Some Client."); ScriptManager.RegisterClientScriptBlock(sender as Control, this.GetType(), "alert", "alert('Email Already Register With System To Some Client.')", true); this.txtEmail.Text = ""; this.txtEmail.Focus(); } else if (this.objStaffMasterDT.Rows.Count > 0) { this.DisplayAlert("Email Already Register With System To Some Staff."); ScriptManager.RegisterClientScriptBlock(sender as Control, this.GetType(), "alert", "alert('Email Already Register With System To Some Staff.')", true); this.txtEmail.Text = ""; this.txtEmail.Focus(); } else if (this.objContractorMasterDT.Rows.Count > 0) { this.DisplayAlert("Email Already Register With System To Some Contractor."); ScriptManager.RegisterClientScriptBlock(sender as Control, this.GetType(), "alert", "alert('Email Already Register With System To Some Contractor.')", true); this.txtEmail.Text = ""; this.txtEmail.Focus(); } else { this.txtFirstName.Focus(); } }
protected void Page_Load(object sender, EventArgs e) { objDbutility = new Dbutility(); if (this.Master == null) { return; } ((HtmlControl)this.Master.FindControl("clientProfile")).Attributes.Add("style", "background-color: lightgray;"); MembershipUser user = Membership.GetUser(); if (user != null) { this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByUsername(user.ToString()); if (this.objCompanyClientMasterDT.Rows.Count > 0) { this.hfClientID.Value = this.objCompanyClientMasterDT.Rows[0]["CompanyClientID"].ToString(); this.hfCompanyID.Value = this.objCompanyClientMasterDT.Rows[0]["CompanyID"].ToString(); this.pnlAddClient.Visible = true; this.ViewClientDetails(this.hfClientID.Value); } this.objCompanyClientContactDetailDT = this.objCompanyClientContactDetailBll.GetDataByUsername(user.ToString()); if (this.objCompanyClientContactDetailDT.Rows.Count > 0) { this.hfClientContactID.Value = this.objCompanyClientContactDetailDT.Rows[0]["CompanyClientContactID"].ToString(); this.hfClientID.Value = this.objCompanyClientContactDetailDT.Rows[0]["CompanyClientID"].ToString(); this.hfCompanyID.Value = this.objCompanyClientContactDetailDT.Rows[0]["CompanyID"].ToString(); this.pnlAddClient.Visible = false; this.ViewClientContactDetails(this.hfClientContactID.Value); } } if (this.IsPostBack) { return; } this.divUpdate.Visible = this.Session["updateProfile"] != null; this.Session["updateProfile"] = (object)null; this.Session.Abandon(); }
protected void gv_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType != DataControlRowType.DataRow) { return; } this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(int.Parse(e.Row.Cells[0].Text)); e.Row.Cells[0].Text = this.objCompanyClientMasterDT.Rows[0]["OrganizationName"].ToString(); string[] strArray = e.Row.Cells[2].Text.Split(' '); e.Row.Cells[2].Text = strArray[0]; string text1 = e.Row.Cells[3].Text; e.Row.Cells[3].Text = Decimal.Round(Decimal.Parse(text1), 2).ToString(); string text2 = e.Row.Cells[4].Text; e.Row.Cells[4].Text = Decimal.Round(Decimal.Parse(text2), 2).ToString(); string text3 = e.Row.Cells[5].Text; e.Row.Cells[5].Text = Decimal.Round(Decimal.Parse(text3), 2).ToString(); string text4 = e.Row.Cells[6].Text; e.Row.Cells[6].Text = Decimal.Round(Decimal.Parse(text4), 2).ToString(); }
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"; } }
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 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 SendMail(string email, string invoiceNum, int invoiceId, int clientId, int companyID) { this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByInvoiceID(invoiceId); string str1 = this.objInvoiceMasterDT.Rows[0]["InvoiceNumber"].ToString(); string s1 = this.objInvoiceMasterDT.Rows[0]["InvoiceTotal"].ToString(); string s2 = this.objInvoiceMasterDT.Rows[0]["PaidToDate"].ToString(); Decimal num = Decimal.Parse(s1) - Decimal.Parse(s2); this.objCompanyMasterDT = this.objCompanyMasterBll.GetDataByCompanyID(companyID); string displayName = this.objCompanyMasterDT.Rows[0]["CompanyName"].ToString().ToUpper(); string addresses = this.objCompanyMasterDT.Rows[0]["CompanyEmail"].ToString(); string str2 = string.Empty; string str3 = string.Empty; string str4 = string.Empty; string str5 = string.Empty; this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(clientId); if (this.objCompanyClientMasterDT.Rows.Count > 0) { string username = this.objCompanyClientMasterDT.Rows[0]["UserName"].ToString(); str3 = this.objCompanyClientMasterDT.Rows[0]["OrganizationName"].ToString(); str4 = this.objCompanyClientMasterDT.Rows[0]["FirstName"].ToString(); str5 = this.objCompanyClientMasterDT.Rows[0]["LastName"].ToString(); email = this.objCompanyClientMasterDT.Rows[0]["Email"].ToString(); MembershipUser user = Membership.GetUser(username); if (user != null) { string key1 = MemberArea.GenerateCode(); string str6 = HttpUtility.UrlEncode(this.Encrypt(user.UserName, key1)); string password = user.GetPassword(); string key2 = MemberArea.GenerateCode(); string str7 = HttpUtility.UrlEncode(this.Encrypt(password, key2)); str2 = string.Format("https://www.billtransact.com/CheckClient.aspx?page=invoice&anyId={0}&name={1}&tech={2}&keyname={3}&keytech={4}", (object)invoiceId, (object)str6, (object)str7, (object)key1, (object)key2); } } string str8 = string.Empty; string str9 = string.Empty; string address = "*****@*****.**"; this.objSMTPSettingsDT = this.objSMTPSettingsBll.GetDataByCompanyID(companyID); if (this.objSMTPSettingsDT.Rows.Count > 0) { str9 = this.objSMTPSettingsDT.Rows[0]["EmailSignature"].ToString(); address = this.objSMTPSettingsDT.Rows[0]["SMTPFrom"].ToString(); } this.objNewInvoiceEmailTemplateDT = this.objNewInvoiceEmailTemplateBll.GetDataByCompanyID(companyID); if (this.objNewInvoiceEmailTemplateDT.Rows.Count > 0) { str8 = this.objNewInvoiceEmailTemplateDT.Rows[0]["EmailBody"].ToString(); } Hashtable Variables = new Hashtable() { { (object)"emailTemplate", (object)str8 }, { (object)"companyName", (object)displayName }, { (object)"companyEmail", (object)("<a href=\"mailto:" + addresses + "\">" + addresses + "</a>") }, { (object)"invoiceNumber", (object)str1 }, { (object)"amountOwned", (object)num }, { (object)"clientOrgName", (object)str3 }, { (object)"firstName", (object)str4 }, { (object)"lastName", (object)str5 }, { (object)"invoiceAmt", (object)s1 }, { (object)"someLink", (object)str2 }, { (object)"directLink", (object)"block" }, { (object)"branding", (object)"block" }, { (object)"emailSign", (object)str9 } }; Parser parser1 = new Parser(this.Server.MapPath("~/MailTemplate/SendInvoiceNew.html"), Variables); string path1 = this.Server.MapPath("~\\TempHTMLFiles\\"); File.WriteAllText(Path.Combine(path1, "Invoice.html"), parser1.Parse()); Parser parser2 = new Parser(path1 + "Invoice.html", Variables); try { MailMessage message = new MailMessage() { From = new MailAddress(address, displayName) }; message.To.Add(new MailAddress(email)); message.ReplyToList.Add(addresses); message.Subject = "New invoice " + invoiceNum + " from " + displayName + ", sent using Bill Transact"; message.BodyEncoding = Encoding.UTF8; message.Body = parser2.Parse(); message.IsBodyHtml = true; SmtpClientForCompany.smtpClient(companyID.ToString()).Send(message); } catch (Exception ex) { } }
private void CallAllRecurringInvoice() { this.objRecurringMasterDT = this.objRecurringMasterBll.GetAllActiveTodayRecurring(); if (this.objRecurringMasterDT.Rows.Count <= 0) { return; } for (int index = 0; index < this.objRecurringMasterDT.Rows.Count; ++index) { int iRecurringID = int.Parse(this.objRecurringMasterDT.Rows[index]["RecurringID"].ToString()); int num1 = int.Parse(this.objRecurringMasterDT.Rows[index]["CompanyID"].ToString()); int num2 = int.Parse(this.objRecurringMasterDT.Rows[index]["ClientID"].ToString()); int iFrequencyID = int.Parse(this.objRecurringMasterDT.Rows[index]["HowOften"].ToString()); DateTime dtNextDate = DateTime.Parse(this.objRecurringMasterDT.Rows[index]["NextDate"].ToString()); string str1 = this.objRecurringMasterDT.Rows[index]["RemainingInvoice"].ToString(); bool bRecurringActive = true; string s; try { s = int.Parse(str1.Trim()).ToString(); } catch (Exception ex) { s = "-1"; } this.objFrequencyMasterDT = this.objFrequencyMasterBll.GetDataByFrequencyID(iFrequencyID); if (this.objFrequencyMasterDT.Rows.Count > 0) { int num3 = int.Parse(this.objFrequencyMasterDT.Rows[0]["NoOfDays"].ToString()); dtNextDate = dtNextDate.AddDays((double)num3); } string sRemainingInvoice; switch (s) { case "-1": sRemainingInvoice = "infinite"; break; default: sRemainingInvoice = (int.Parse(s) - 1).ToString(); if (sRemainingInvoice == "0") { bRecurringActive = false; break; } break; } this.objRecurringMasterBll.UpdateForSentInvoice(iRecurringID, sRemainingInvoice, dtNextDate, bRecurringActive); this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByCompanyID(num1); string str2 = this.objInvoiceMasterDT.Rows.Count <= 0 ? ConfigurationManager.AppSettings["InvoiceNoStart"] : InvoiceMaster.NextNum(this.objInvoiceMasterDT.Rows[this.objInvoiceMasterDT.Rows.Count - 1]["InvoiceNumber"].ToString()); int num4 = this.objInvoiceMasterBll.AddInvoice(str2, iRecurringID); this.objRecurringItemDetailDT = this.objRecurringItemDetailBll.GetDataByRecurringID(iRecurringID); if (this.objRecurringItemDetailDT.Rows.Count > 0) { this.objInvoiceItemDetailBll.AddInvoiceItem(num4, iRecurringID); } this.objRecurringTaskDetailDT = this.objRecurringTaskDetailBll.GetDataByRecurringID(iRecurringID); if (this.objRecurringTaskDetailDT.Rows.Count > 0) { this.objInvoiceTaskDetailBll.AddInvoiceTask(num4, iRecurringID); } this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(num2); if (this.objCompanyClientMasterDT.Rows.Count > 0) { this.SendMail(this.objCompanyClientMasterDT.Rows[0]["Email"].ToString(), str2, num4, num2, num1); } } }
private void ViewClientDetails(string clientID) { this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(int.Parse(clientID)); if (this.objCompanyClientMasterDT.Rows.Count <= 0) { return; } this.hfClientID.Value = this.objCompanyClientMasterDT.Rows[0]["CompanyClientID"].ToString(); this.hfCompanyID.Value = this.objCompanyClientMasterDT.Rows[0]["CompanyID"].ToString(); this.txtEmail.Text = this.objCompanyClientMasterDT.Rows[0]["Email"].ToString(); this.txtFirstName.Text = this.objCompanyClientMasterDT.Rows[0]["FirstName"].ToString(); this.txtLastName.Text = this.objCompanyClientMasterDT.Rows[0]["LastName"].ToString(); this.txtHomePhone.Text = this.objCompanyClientMasterDT.Rows[0]["HomePhone"].ToString(); this.txtMobile.Text = this.objCompanyClientMasterDT.Rows[0]["Mobile"].ToString(); this.lblUsernameAdd.Text = this.txtUsername.Text = this.objCompanyClientMasterDT.Rows[0]["UserName"].ToString(); this.txtAddress1.Text = this.objCompanyClientMasterDT.Rows[0]["Address1"].ToString(); this.txtAddress2.Text = this.objCompanyClientMasterDT.Rows[0]["Address2"].ToString(); this.txtZipCode.Text = this.objCompanyClientMasterDT.Rows[0]["ZipCode"].ToString(); this.txtAddress1Secondary.Text = this.objCompanyClientMasterDT.Rows[0]["SecondaryAddress1"].ToString(); this.txtAddress2Secondary.Text = this.objCompanyClientMasterDT.Rows[0]["SecondaryAddress2"].ToString(); this.txtZipCodeSecondary.Text = this.objCompanyClientMasterDT.Rows[0]["SecondaryZipCode"].ToString(); this.txtBussinessPhone.Text = this.objCompanyClientMasterDT.Rows[0]["BussinessPhone"].ToString(); this.txtFax.Text = this.objCompanyClientMasterDT.Rows[0]["Fax"].ToString(); MembershipUser user = Membership.GetUser(this.txtUsername.Text); if (user != null) { this.lblPasswordAdd.Text = user.GetPassword(); } string s1 = this.objCompanyClientMasterDT.Rows[0]["CountryID"].ToString(); string s2 = this.objCompanyClientMasterDT.Rows[0]["StateID"].ToString(); string s3 = this.objCompanyClientMasterDT.Rows[0]["CityID"].ToString(); string s4 = this.objCompanyClientMasterDT.Rows[0]["SecondaryCountryID"].ToString(); string s5 = this.objCompanyClientMasterDT.Rows[0]["SecondaryStateID"].ToString(); string s6 = this.objCompanyClientMasterDT.Rows[0]["SecondaryCityID"].ToString(); if (!string.IsNullOrEmpty(s1)) { this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(s1)); 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(s2)) { this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(s2)); 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(s3)) { this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(s3)); 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(s4)) { this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(s4)); if (this.objCountryMasterDT.Rows.Count > 0) { this.ddlCountrySecondary.Items.Add(this.objCountryMasterDT.Rows[0]["CountryID"].ToString()); this.ddlCountrySecondary.SelectedValue = this.objCountryMasterDT.Rows[0]["CountryID"].ToString(); } } if (!string.IsNullOrEmpty(s5)) { this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(s5)); if (this.objStateMasterDT.Rows.Count > 0) { this.ddlStateSecondary.Items.Add(this.objStateMasterDT.Rows[0]["StateID"].ToString()); this.ddlStateSecondary.SelectedValue = this.objStateMasterDT.Rows[0]["StateID"].ToString(); } } if (!string.IsNullOrEmpty(s6)) { this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(s6)); if (this.objCityMasterDT.Rows.Count > 0) { this.ddlCitySecondary.Items.Add(this.objCityMasterDT.Rows[0]["CityID"].ToString()); this.ddlCitySecondary.SelectedValue = this.objCityMasterDT.Rows[0]["CityID"].ToString(); } } this.txtUsername.Enabled = false; this.txtEmail.Enabled = false; }
private async Task SendMailNew(int paymentID) { this.objCompanyMasterDT = this.objCompanyMasterBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value)); string displayName = this.objCompanyMasterDT.Rows[0]["CompanyName"].ToString().ToUpper(); string addresses = this.objCompanyMasterDT.Rows[0]["CompanyEmail"].ToString(); this.objPaymentMasterDT = this.objPaymentMasterBll.GetDataByPaymentID(paymentID); string s1 = this.objPaymentMasterDT.Rows[0]["InvoiceID"].ToString(); this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByInvoiceID(int.Parse(s1)); string str1 = this.objInvoiceMasterDT.Rows[0]["InvoiceNumber"].ToString(); string s2 = this.objInvoiceMasterDT.Rows[0]["InvoiceTotal"].ToString(); //string s3 = this.objInvoiceMasterDT.Rows[0]["PaidToDate"].ToString(); //Decimal num = Decimal.Parse(s2) - Decimal.Parse(s3); Decimal num = Decimal.Parse(s2); string s4 = this.objInvoiceMasterDT.Rows[0]["ClientID"].ToString(); string str2 = string.Empty; string address1 = string.Empty; string str3 = string.Empty; string str4 = string.Empty; string str5 = string.Empty; this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(int.Parse(s4)); if (this.objCompanyClientMasterDT.Rows.Count > 0) { string username = this.objCompanyClientMasterDT.Rows[0]["UserName"].ToString(); str3 = this.objCompanyClientMasterDT.Rows[0]["OrganizationName"].ToString(); str4 = this.objCompanyClientMasterDT.Rows[0]["FirstName"].ToString(); str5 = this.objCompanyClientMasterDT.Rows[0]["LastName"].ToString(); address1 = this.objCompanyClientMasterDT.Rows[0]["Email"].ToString(); MembershipUser user = Membership.GetUser(username); if (user != null) { string key1 = PaymentMaster.GenerateCode(); string str6 = HttpUtility.UrlEncode(this.Encrypt(user.UserName, key1)); string password = user.GetPassword(); string key2 = PaymentMaster.GenerateCode(); string str7 = HttpUtility.UrlEncode(this.Encrypt(password, key2)); str2 = string.Format("{5}/CheckClient.aspx?page=invoice&anyId={0}&name={1}&tech={2}&keyname={3}&keytech={4}", (object)s1, (object)str6, (object)str7, (object)key1, (object)key2, Common.CommonHandler.WebsiteBaseURL); } } string str8 = string.Empty; string str9 = string.Empty; string address2 = "*****@*****.**"; this.objSMTPSettingsDT = this.objSMTPSettingsBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value)); if (this.objSMTPSettingsDT.Rows.Count > 0) { str9 = this.objSMTPSettingsDT.Rows[0]["EmailSignature"].ToString(); address2 = this.objSMTPSettingsDT.Rows[0]["SMTPFrom"].ToString(); } this.objNewPaymentEmailTemplateDT = this.objNewPaymentEmailTemplateBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value), "other"); if (this.objNewPaymentEmailTemplateDT.Rows.Count > 0) { str8 = this.objNewPaymentEmailTemplateDT.Rows[0]["EmailBody"].ToString(); } Hashtable Variables = new Hashtable() { { (object)"company", (object)displayName }, { (object)"companyName", (object)displayName }, { (object)"invoiceNum", (object)str1 }, { (object)"invoiceNumber", (object)str1 }, { (object)"someLink", (object)str2 }, { (object)"emailTemplate", (object)str8 }, { (object)"companyEmail", (object)("<a href=\"mailto:" + addresses + "\">" + addresses + "</a>") }, { (object)"amountOwned", (object)num }, { (object)"clientOrgName", (object)str3 }, { (object)"firstName", (object)str4 }, { (object)"lastName", (object)str5 }, { (object)"invoiceAmt", (object)s2 }, { (object)"directLink", (object)this.directLink }, { (object)"branding", (object)this.branding }, { (object)"emailSign", (object)str9 }, { (object)"loginLink", (object)"<a target=\"_blank\" href=\"http://www.billtransact.com/MemberArea.aspx\">https://www.billtransact.com/MemberArea.aspx</a>" } }; Parser parser1 = new Parser(this.Server.MapPath("~/MailTemplate/PaymentInformationNew.html"), Variables); string path1 = this.Server.MapPath("~\\TempHTMLFiles\\"); File.WriteAllText(Path.Combine(path1, "Payment.html"), parser1.Parse()); Parser parser2 = new Parser(path1 + "Payment.html", Variables); try { //MailMessage message = new MailMessage() //{ // From = new MailAddress(address2, displayName) //}; //message.To.Add(new MailAddress(address1)); //message.ReplyToList.Add(addresses); //message.Subject = displayName + " has received your payment for invoice " + str1 + " in Bill Transact"; //message.BodyEncoding = Encoding.UTF8; //message.Body = parser2.Parse(); //message.IsBodyHtml = true; //Common.CommonHandler.SendSMTPEmail(hfCompanyID.Value, address1, displayName + " has received your payment for invoice " + str1 + " in Bill Transact", parser2.Parse(), true); await Common.CommonHandler.SendMail(hfCompanyID.Value, address1, displayName + " has received your payment for invoice " + str1 + " in Bill Transact", parser2.Parse(), true); //SmtpClientForCompany.smtpClient(this.hfCompanyID.Value).Send(message); } catch (Exception ex) { this.DisplayAlert("Error in sending mail." + (object)ex); } }