protected void btnSendmail_Click(object sender, EventArgs e)
        {
            try
            {
                BALVendorOrderDue lstMp = new BALVendorOrderDue();
                lstMp.CorporateName = drpcor.SelectedValue;
                lstMp.FacilityName  = drpfacility.SelectedValue;
                //lstMp.VendorName = drpvendor.SelectedValue;
                txtDateFrom.Text = DateTime.Now.ToString("MM/dd/yyyy");
                lstMp.DateFrom   = Convert.ToDateTime(txtDateFrom.Text);
                txtDateTo.Text   = (DateTime.Today.AddDays(+6)).ToString("MM/dd/yyyy");
                lstMp.DateTo     = Convert.ToDateTime(txtDateTo.Text);
                lstMp.LoggedInBy = defaultPage.UserId;
                List <GetVendorOrderdueRemainderReport> lstVendorOrderDue = lclsService.GetVendorOrderdueRemainderReport(lstMp).ToList();

                if (lstVendorOrderDue.Count > 0)
                {
                    if (lstVendorOrderDue[0].VenOrderDueID != 0)
                    {
                        objemail.vendorEmailcontent = lstVendorOrderDue[0].BodyContent1 + lstVendorOrderDue[0].BodyContent2 + "<div><br />Regards <br /> " + lstVendorOrderDue[0].BodyContent3 + "</div>";
                    }
                    else
                    {
                        objemail.vendorEmailcontent = lstVendorOrderDue[0].BodyContent1 + lstVendorOrderDue[0].BodyContent2 + lstVendorOrderDue[0].BodyContent3;
                    }
                    objemail.vendoremailsubject = lstVendorOrderDue[0].SubjectContent;
                    if (lstVendorOrderDue[0].FromEmailID == null || lstVendorOrderDue[0].ToEmailID == null)
                    {
                        ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", Constant.WarningVendorOrderDueRemainderMessage.Replace("<<VendorOrderDueRemainder>>", Constant.VendorOrderDueRemainderMail + drpfacility.SelectedItem.Text + ") facility"), true);
                    }
                    else
                    {
                        objemail.CorporateEmail     = lstVendorOrderDue[0].FromEmailID;
                        objemail.vendorContactEmail = lstVendorOrderDue[0].ToEmailID;
                        objemail.SendEmailTransferOut(objemail.CorporateEmail, objemail.vendorContactEmail, objemail.vendorEmailcontent, objemail.vendoremailsubject);
                        if (lstVendorOrderDue[0].VenOrderDueID == 0)
                        {
                            ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", Constant.VendorOrderDueRemainderAdminMailSuccessMessage.Replace("<<VendorOrderDueRemainder>>", drpfacility.SelectedItem.Text), true);
                        }
                        else
                        {
                            ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", Constant.VendorOrderDueRemainderTechMailSuccessMessage.Replace("<<VendorOrderDueRemainder>>", drpfacility.SelectedItem.Text), true);
                        }
                    }
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", Constant.WarningVendorOrderDueRemainderMessage.Replace("<<VendorOrderDueRemainder>>", Constant.VendorOrderDueRemainderMail + drpfacility.SelectedItem.Text + ") facility"), true);
                }
            }
            catch (Exception ex)
            {
                ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", Constant.VendorOrderDueRemainderErrorMessage.Replace("<<VendorOrderDueRemainder>>", ex.Message.ToString()), true);
            }
        }
        protected void btnpreview_Click(object sender, EventArgs e)
        {
            try
            {
                BALVendorOrderDue lstMp = new BALVendorOrderDue();
                //if (drpcor.SelectedValue == "All")
                //{
                //    lstMp.CorporateName = "ALL";
                //}
                //else
                //{
                //    foreach (ListItem lst in drpcor.Items)
                //    {
                //        if (lst.Selected && drpcor.SelectedValue != "All")
                //        {
                //            SB.Append(lst.Value + ',');
                //        }
                //    }
                //    if (SB.Length > 0)
                //        FinalString = SB.ToString().Substring(0, (SB.Length - 1));

                //    lstMp.CorporateName = FinalString;
                //}
                //FinalString = "";
                //SB.Clear();
                //if (drpfacility.SelectedValue == "All")
                //{
                //    lstMp.FacilityName = "ALL";
                //}
                //else
                //{
                //    foreach (ListItem lst in drpfacility.Items)
                //    {
                //        if (lst.Selected && drpfacility.SelectedValue != "All")
                //        {
                //            SB.Append(lst.Value + ',');
                //        }
                //    }
                //    if (SB.Length > 0)
                //        FinalString = SB.ToString().Substring(0, (SB.Length - 1));
                //    lstMp.FacilityName = FinalString;

                //}
                //FinalString = "";
                //SB.Clear();
                //if (drpvendor.SelectedValue == "All")
                //{
                //    lstMp.VendorName = "ALL";
                //}
                //else
                //{
                //    foreach (ListItem lst in drpvendor.Items)
                //    {
                //        if (lst.Selected && drpvendor.SelectedValue != "All")
                //        {
                //            SB.Append(lst.Value + ',');
                //        }
                //    }
                //    if (SB.Length > 0)
                //        FinalString = SB.ToString().Substring(0, (SB.Length - 1));
                //    lstMp.VendorName = FinalString;
                //}
                //FinalString = "";
                //SB.Clear();

                //lstMp.CorporateID = Convert.ToInt64(drpcor.SelectedValue);
                //lstMp.FacilityID = Convert.ToInt64(drpfacility.SelectedValue);
                //lstMp.VendorID = Convert.ToInt64(drpvendor.SelectedValue);

                lstMp.CorporateName = drpcor.SelectedValue;
                lstMp.FacilityName  = drpfacility.SelectedValue;
                //lstMp.VendorName = drpvendor.SelectedValue;
                txtDateFrom.Text = DateTime.Now.ToString("MM/dd/yyyy");
                lstMp.DateFrom   = Convert.ToDateTime(txtDateFrom.Text);
                txtDateTo.Text   = (DateTime.Today.AddDays(+6)).ToString("MM/dd/yyyy");
                lstMp.DateTo     = Convert.ToDateTime(txtDateTo.Text);
                lstMp.LoggedInBy = defaultPage.UserId;
                List <GetVendorOrderdueRemainderReport> lstVendorOrderDue = lclsService.GetVendorOrderdueRemainderReport(lstMp).ToList();
                if (lstVendorOrderDue.Count > 0)
                {
                    if (lstVendorOrderDue[0].VenOrderDueID != 0)
                    {
                        mpereview.Show();
                        DivBodyContent.InnerHtml  = lstVendorOrderDue[0].BodyContent1;
                        DivBodyContent2.InnerHtml = lstVendorOrderDue[0].BodyContent2;
                        DivRegards.Style.Add("display", "block");
                        DivBodyContent3.InnerHtml = lstVendorOrderDue[0].BodyContent3;
                    }
                    else
                    {
                        mpereview.Show();
                        DivBodyContent.InnerHtml  = lstVendorOrderDue[0].BodyContent1;
                        DivBodyContent2.InnerHtml = lstVendorOrderDue[0].BodyContent2;
                        DivRegards.Style.Add("display", "none");
                        DivBodyContent3.InnerHtml = lstVendorOrderDue[0].BodyContent3;
                    }
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", Constant.WarningVendorOrderDueRemainderMessage.Replace("<<VendorOrderDueRemainder>>", Constant.VendorOrderDueRemainderPreviewMail + drpfacility.SelectedItem.Text + ") facility"), true);
                }
            }
            catch (Exception ex)
            {
                ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", Constant.VendorOrderDueRemainderErrorMessage.Replace("<<VendorOrderDueRemainder>>", ex.Message.ToString()), true);
            }
        }
        //protected void txtoderDuedate_TextChanged(object sender, EventArgs e)
        //{
        //    TextBox tb = (TextBox)sender;
        //    GridViewRow gvr = (GridViewRow)tb.NamingContainer;
        //    hdnvendororderID.Value += gvr.RowIndex + ",";
        //}


        //protected void drpfacility_SelectedIndexChanged(object sender, EventArgs e)
        //{
        //    BindVendor();
        //}

        /// <summary>
        /// Search the Vendor Order Due
        /// </summary>
        #region Bind Search Values
        public void SearchGrid()
        {
            try
            {
                BALVendorOrderDue lstMp = new BALVendorOrderDue();
                //if (drpcor.SelectedValue == "All")
                //{
                //    lstMp.CorporateName = "ALL";
                //}
                //else
                //{
                //    foreach (ListItem lst in drpcor.Items)
                //    {
                //        if (lst.Selected && drpcor.SelectedValue != "All")
                //        {
                //            SB.Append(lst.Value + ',');
                //        }
                //    }
                //    if (SB.Length > 0)
                //        FinalString = SB.ToString().Substring(0, (SB.Length - 1));

                //    lstMp.CorporateName = FinalString;
                //}
                //FinalString = "";
                //SB.Clear();
                //if (drpfacility.SelectedValue == "All")
                //{
                //    lstMp.FacilityName = "ALL";
                //}
                //else
                //{
                //    foreach (ListItem lst in drpfacility.Items)
                //    {
                //        if (lst.Selected && drpfacility.SelectedValue != "All")
                //        {
                //            SB.Append(lst.Value + ',');
                //        }
                //    }
                //    if (SB.Length > 0)
                //        FinalString = SB.ToString().Substring(0, (SB.Length - 1));
                //    lstMp.FacilityName = FinalString;

                //}
                //FinalString = "";
                //SB.Clear();
                //if (drpvendor.SelectedValue == "All")
                //{
                //    lstMp.VendorName = "ALL";
                //}
                //else
                //{
                //    foreach (ListItem lst in drpvendor.Items)
                //    {
                //        if (lst.Selected && drpvendor.SelectedValue != "All")
                //        {
                //            SB.Append(lst.Value + ',');
                //        }
                //    }
                //    if (SB.Length > 0)
                //        FinalString = SB.ToString().Substring(0, (SB.Length - 1));
                //    lstMp.VendorName = FinalString;
                //}
                //FinalString = "";
                //SB.Clear();

                //lstMp.CorporateID = Convert.ToInt64(drpcor.SelectedValue);
                //lstMp.FacilityID = Convert.ToInt64(drpfacility.SelectedValue);
                //lstMp.VendorID = Convert.ToInt64(drpvendor.SelectedValue);

                lstMp.CorporateName = drpcor.SelectedValue;
                lstMp.FacilityName  = drpfacility.SelectedValue;
                //lstMp.VendorName = drpvendor.SelectedValue;
                txtDateFrom.Text = DateTime.Now.ToString("MM/dd/yyyy");
                lstMp.DateFrom   = Convert.ToDateTime(txtDateFrom.Text);
                txtDateTo.Text   = (DateTime.Today.AddDays(+6)).ToString("MM/dd/yyyy");
                lstMp.DateTo     = Convert.ToDateTime(txtDateTo.Text);
                lstMp.LoggedInBy = defaultPage.UserId;
                List <GetVendorOrderdueRemainderReport> lstVendorOrderDue = lclsService.GetVendorOrderdueRemainderReport(lstMp).ToList();
                if (lstVendorOrderDue.Count > 0)
                {
                    if (lstVendorOrderDue[0].VenOrderDueID != 0)
                    {
                        grdvendororderueremainder.DataSource = lstVendorOrderDue;
                    }
                    else
                    {
                        grdvendororderueremainder.DataSource = null;
                        ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", Constant.WarningVendorOrderDueRemainderMessage.Replace("<<VendorOrderDueRemainder>>", Constant.VendorOrderDueRemainderPreviewMail + drpfacility.SelectedItem.Text + ") facility"), true);
                    }
                }
                else
                {
                    grdvendororderueremainder.DataSource = null;
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", Constant.WarningVendorOrderDueRemainderMessage.Replace("<<VendorOrderDueRemainder>>", Constant.VendorOrderDueRemaindnovendordue), true);
                }
                grdvendororderueremainder.DataBind();
            }

            catch (Exception ex)
            {
                ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", Constant.VendorOrderDueRemainderErrorMessage.Replace("<<VendorOrderDueRemainder>>", ex.Message.ToString()), true);
            }
        }