protected void RadGridBackOrders_ItemDataBound(object sender, GridItemEventArgs e)
        {
            if (e.Item is GridDataItem)
            {
                var item = e.Item as GridDataItem;

                if (item.ItemIndex > -1 && item.DataItem is ReturnBackOrdersViewBO)
                {
                    ReturnBackOrdersViewBO objReturnBackOrdersView = (ReturnBackOrdersViewBO)item.DataItem;

                    TextBox txtCoordinatorEmail = (TextBox)item.FindControl("txtCoordinatorEmail");
                    txtCoordinatorEmail.Text = objReturnBackOrdersView.CoordinatorEmailAddress.Trim();

                    TextBox txtDistributorEmail = (TextBox)item.FindControl("txtDistributorEmail");
                    txtDistributorEmail.Text = objReturnBackOrdersView.DistributorEmailAddress.Trim();

                    Literal litEmailSent = (Literal)item.FindControl("litEmailSent");
                    litEmailSent.Text = ((int)objReturnBackOrdersView.Count > 0) ? "Yes ( " + objReturnBackOrdersView.Count + " )" : "No";

                    var daysTillfriday = (int)DayOfWeek.Friday - (int)DateTime.Today.DayOfWeek;
                    var friday         = DateTime.Today.AddDays(daysTillfriday);

                    int wpid = (new WeeklyProductionCapacityBO()).SearchObjects().Where(o => o.WeekendDate == friday).Select(o => o.ID).SingleOrDefault();

                    DistributorSendMailCountBO objSendMail = new DistributorSendMailCountBO();
                    objSendMail.Distributor = (int)objReturnBackOrdersView.DistributorID;
                    objSendMail.WeeklyProductionCapacity = wpid;

                    int sendmail = objSendMail.SearchObjects().Select(o => o.ID).SingleOrDefault();

                    HiddenField hdnWeekLyID = (HiddenField)item.FindControl("hdnWeekLyID");
                    hdnWeekLyID.Value = wpid.ToString();

                    HiddenField hdnSendMail = (HiddenField)item.FindControl("hdnSendMail");
                    hdnSendMail.Value = sendmail.ToString();

                    LinkButton btnSendMail = (LinkButton)item.FindControl("btnSendMail");
                    btnSendMail.Attributes.Add("wdate", friday.ToString());
                    btnSendMail.Attributes.Add("did", objReturnBackOrdersView.DistributorID.ToString());

                    LinkButton btnSave = (LinkButton)item.FindControl("btnSave");
                    btnSave.Attributes.Add("cid", objReturnBackOrdersView.CoordinatorID.ToString());
                    btnSave.Attributes.Add("did", objReturnBackOrdersView.DistributorID.ToString());

                    LinkButton btnDownloadBackOrder = (LinkButton)item.FindControl("btnDownloadBackOrder");
                    btnDownloadBackOrder.Attributes.Add("wdate", friday.ToString());
                    btnDownloadBackOrder.Attributes.Add("did", objReturnBackOrdersView.DistributorID.ToString());


                    //HyperLink linkEdit = (HyperLink)item.FindControl("linkEdit");
                    //linkEdit.Attributes.Add("qid", objReturnBackOrdersView.ID.ToString());

                    //HyperLink linkDelete = (HyperLink)item.FindControl("linkDelete");
                    //linkDelete.Attributes.Add("qid", objReturnBackOrdersView.ID.ToString());
                    //linkDelete.Visible = (objReturnBackOrdersView.PatternsWhereThisIsAgeGroup.Count == 0);
                }
            }
        }
        //protected void btnSaveChanges_Click(object sender, EventArgs e)
        //{
        //    if (this.IsNotRefresh)
        //    {
        //        int agegroupId = int.Parse(this.hdnSelectedAgeGroupID.Value.Trim());

        //        if (Page.IsValid)
        //        {
        //            this.ProcessForm(agegroupId, false);

        //            Response.Redirect("/ViewAgeGroups.aspx");
        //        }

        //        ViewState["IsPageValied"] = (Page.IsValid);
        //    }
        //}

        //protected void btnDelete_Click(object sender, EventArgs e)
        //{
        //    int agegroupId = int.Parse(this.hdnSelectedAgeGroupID.Value.Trim());

        //    if (!Page.IsValid)
        //    {
        //        this.ProcessForm(agegroupId, true);

        //        this.PopulateDataGrid();
        //    }

        //    ViewState["IsPageValied"] = (Page.IsValid);
        //    ViewState["IsPageValied"] = true;
        //    this.validationSummary.Visible = !(Page.IsValid);

        //}

        //protected void dataGridAgeGroup_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
        //{
        //    // Set page index
        //    this.dataGridAgeGroup.CurrentPageIndex = e.NewPageIndex;

        //    this.PopulateDataGrid();
        //}

        //protected void dataGridAgeGroup_SortCommand(object source, DataGridSortCommandEventArgs e)
        //{
        //    string sortDirection = String.Empty;
        //    if (!SortExpression.ToUpper().StartsWith(e.SortExpression) && !SortExpression.ToUpper().Trim().EndsWith("ASC"))
        //    {
        //        sortDirection = " asc";
        //    }
        //    else
        //    {
        //        sortDirection = (SortExpression.ToUpper().EndsWith("DESC")) ? " asc" : " desc";
        //    }
        //    this.SortExpression = e.SortExpression + sortDirection;

        //    this.PopulateDataGrid();

        //    foreach (DataGridColumn col in this.dataGridAgeGroup.Columns)
        //    {
        //        if (col.Visible && col.SortExpression == e.SortExpression)
        //        {
        //            col.HeaderStyle.CssClass = "selected " + ((sortDirection.ToUpper() != " DESC") ? "sortDown" : "sortUp");
        //        }
        //        else
        //        {
        //            col.HeaderStyle.CssClass = "";
        //        }
        //    }
        //}

        protected void btnSendMail_Click(object sender, EventArgs e)
        {
            try
            {
                TextBox txtCoordinatorEmail = (TextBox)((LinkButton)(sender)).FindControl("txtCoordinatorEmail");

                TextBox txtDistributorEmail = (TextBox)((LinkButton)(sender)).FindControl("txtDistributorEmail");

                HiddenField hdnWeekLyID = (HiddenField)((LinkButton)(sender)).FindControl("hdnWeekLyID");

                HiddenField hdnSendMail = (HiddenField)((LinkButton)(sender)).FindControl("hdnSendMail");

                int distributor = int.Parse(((System.Web.UI.WebControls.WebControl)(sender)).Attributes["did"].ToString());

                DateTime WeekendDate = DateTime.Parse(((System.Web.UI.WebControls.WebControl)(sender)).Attributes["wdate"].ToString());

                if (!string.IsNullOrEmpty(txtCoordinatorEmail.Text) && !string.IsNullOrEmpty(txtDistributorEmail.Text) && distributor > 0 && WeekendDate != null)
                {
                    string pdfFilePath = Common.GenerateOdsPdf.GenerateBackOrder(WeekendDate, distributor);

                    string[] pdfPath = new string[] { pdfFilePath };

                    IndicoEmail.SendMail(this.LoggedCompany.Name, this.LoggedUser.EmailAddress, string.Empty, txtCoordinatorEmail.Text, txtDistributorEmail.Text, "Back Order Report", string.Empty, pdfPath, false, string.Empty);
                }

                int count = 0;

                using (TransactionScope ts = new TransactionScope())
                {
                    DistributorSendMailCountBO objSendMail = new DistributorSendMailCountBO(this.ObjContext);

                    if (int.Parse(hdnSendMail.Value.ToString()) > 0)
                    {
                        objSendMail.ID = int.Parse(hdnSendMail.Value.ToString());
                        objSendMail.GetObject();

                        count = (int)objSendMail.Count;
                    }

                    objSendMail.Distributor = distributor;
                    objSendMail.WeeklyProductionCapacity = int.Parse(hdnWeekLyID.Value.ToString());
                    count++;
                    objSendMail.Count = count;

                    this.ObjContext.SaveChanges();
                    ts.Complete();
                }
            }
            catch (Exception ex)
            {
                IndicoLogging.log.Error("Error occured while sending email to the coordinator and distributor feom ViewBackOrders.aspx page", ex);
            }

            this.PopulateDataGrid();
        }