Exemple #1
0
        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();
            }
        }
Exemple #2
0
 protected async void btnSave_Click(object sender, EventArgs e)
 {
     if (this.Page.IsValid)
     {
         string s = this.txtPaymentDate.Text;
         //string s = DateTime.ParseExact(this.txtPaymentDate.Text, new string[6]
         //{
         //  "MM/dd/yy",
         //  "MM/dd/yyyy",
         //  "dd/MM/yy",
         //  "dd/MM/yyyy",
         //  "yy-MM-dd",
         //  "yyyy-MM-dd"
         //}, (IFormatProvider) CultureInfo.InvariantCulture, DateTimeStyles.None).ToString("MM/dd/yyyy");
         Decimal num11 = 0;
         if (this.txtPayment.Text.Trim().Length > 0)
         {
             num11 = Decimal.Parse(this.txtPayment.Text.Trim());
         }
         if (num11 == Decimal.Parse(this.lblBalance.Text))
         {
             num11 = Decimal.Parse(this.lblBalance.Text);
         }
         else if (num11 > Decimal.Parse(this.lblBalance.Text))
         {
             Decimal num2 = num11 - Decimal.Parse(this.lblBalance.Text);
             num11 = Decimal.Parse(this.lblBalance.Text);
             this.objCreditMasterDT = this.objCreditMasterBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value));
             string sCreditNumber = this.objCreditMasterDT.Rows.Count <= 0 ? ConfigurationManager.AppSettings["InvoiceNoStart"] : PaymentMaster.NextNum(this.objCreditMasterDT.Rows[0]["CreditNumber"].ToString());
             this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByInvoiceID(int.Parse(this.hfInvoiceID.Value));
             this.objCreditMasterBll.AddCredit(int.Parse(this.hfCompanyID.Value), new int?(int.Parse(this.objInvoiceMasterDT.Rows[0]["ClientID"].ToString())), new int?(int.Parse(this.objInvoiceMasterDT.Rows[0]["CurrencyID"].ToString())), sCreditNumber, new DateTime?(DateTime.Parse(s)), "Overpayment from invoice #" + this.objInvoiceMasterDT.Rows[0]["InvoiceNumber"], "", "created", new Decimal?(num2), new Decimal?(num2));
         }
         int      a  = int.Parse(this.hfCompanyID.Value);
         int      b  = int.Parse(this.hfInvoiceID.Value);
         Decimal? c  = new Decimal?(num11);
         string   d  = this.ddlMethod.SelectedItem.Value;
         DateTime?ed = new DateTime?(DateTime.Parse(s));
         string   f  = this.txtPaymentNote.Text.Trim();
         //int paymentID = this.objPaymentMasterBll.AddPayment(int.Parse(this.hfCompanyID.Value), int.Parse(this.hfInvoiceID.Value), new Decimal?(num11), this.ddlMethod.SelectedItem.Value, new DateTime?(DateTime.Parse(s)), this.txtPaymentNote.Text.Trim());
         int paymentID = this.objPaymentMasterBll.AddPayment(int.Parse(this.hfCompanyID.Value), int.Parse(this.hfInvoiceID.Value), Convert.ToDecimal(txtPayment.Text), this.ddlMethod.SelectedItem.Value, Convert.ToDateTime(s), this.txtPaymentNote.Text.Trim());
         if (num11 > new Decimal(0))
         {
             Decimal num2 = Decimal.Round(Decimal.Parse(this.lblTotalPaid.Text) + num11, 2);
             //this.objInvoiceMasterBll.UpdatePaidToDate(new Decimal?(num2), int.Parse(this.hfInvoiceID.Value));
             this.objInvoiceMasterBll.UpdateInvoiceStatus(num2 == Decimal.Parse(this.lblInvoiceAmt.Text) ? "paid" : "partial", int.Parse(this.hfInvoiceID.Value));
         }
         if (paymentID != 0)
         {
             this.Session["savePay"] = (object)1;
             if (true || chkEmail.Checked)
             {
                 this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByInvoiceID(int.Parse(this.hfInvoiceID.Value));
                 if (this.objInvoiceMasterDT.Rows.Count > 0)
                 {
                     this.lblInvoiceAmt.Text = this.objInvoiceMasterDT.Rows[0]["InvoiceTotal"].ToString();
                     this.lblInvoiceAmt.Text = Decimal.Round(Decimal.Parse(this.lblInvoiceAmt.Text), 2).ToString();
                     await this.SendMailNew(paymentID);
                 }
             }
             this.DisplayAlert("Payment Added Successfully");
             this.Response.Redirect("PaymentMaster.aspx");
         }
         else
         {
             this.DisplayAlert("Problem in Insertion Try After Sometime..!");
         }
     }
     else
     {
         this.DisplayAlert("Please Fill Proper Data..!");
     }
 }