protected void BusinessUnit_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            if (Page.IsValid)
            {
                BusinessUnitReportingChild li = new BusinessUnitReportingChild();
                GridViewRow row          = BusinessUnitGridView.Rows[e.RowIndex];
                string      display      = "";
                bool        isFormFilled = true;
                try
                {
                    li.BusinessUnitID = Convert.ToInt32(BusinessUnitGridView.DataKeys[e.RowIndex].Values[0]);

                    if (((TextBox)row.FindControl("BusinessUnitCode")).Text != string.Empty)
                    {
                        li.BusinessUnitCode = Convert.ToInt32(((TextBox)row.FindControl("BusinessUnitCode")).Text);
                    }
                    else
                    {
                        display = "Business Unit Code cannot be empty";
                        ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true);
                        isFormFilled = false;
                    }

                    if (((TextBox)row.FindControl("BusinessUnitName")).Text != string.Empty)
                    {
                        li.BusinessUnitName = Convert.ToString(((TextBox)row.FindControl("BusinessUnitName")).Text);
                    }
                    else
                    {
                        display = "Business Unit Name cannot be empty";
                        ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true);
                        isFormFilled = false;
                    }

                    if (((DropDownList)row.FindControl("BusinessUnitManagerName")).SelectedValue != "Select One")
                    {
                        li.BusinessUnitManagerName = ((DropDownList)row.FindControl("BusinessUnitManagerName")).SelectedValue;
                    }
                    // else
                    // {
                    //     display = "Select Business Unit Manager Name from dropdown";
                    //     ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true);
                    //     isFormFilled = false;
                    // }

                    if (((DropDownList)row.FindControl("CompanyName")).SelectedValue != "Select One")
                    {
                        li.CompanyName = ((DropDownList)row.FindControl("CompanyName")).SelectedValue;
                    }
                    else
                    {
                        display = "Select Company Name from dropdown";
                        ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true);
                        isFormFilled = false;
                    }

                    if (!String.IsNullOrEmpty(Convert.ToString((Request.Form[row.FindControl("EffectiveDate").UniqueID]))))
                    {
                        li.EffectiveDate = Convert.ToDateTime((Request.Form[row.FindControl("EffectiveDate").UniqueID]));
                    }
                    else
                    {
                        display = "Effective Date cannot be empty";
                        ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true);
                        isFormFilled = false;
                    }
                    if (!String.IsNullOrEmpty(Convert.ToString((Request.Form[row.FindControl("ExpirationDate").UniqueID]))))
                    {
                        li.ExpirationDate = Convert.ToDateTime((Request.Form[row.FindControl("ExpirationDate").UniqueID]));
                    }
                    // else
                    // {
                    //     display = "Expiration Date cannot be empty";
                    //     ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true);
                    //     isFormFilled = false;
                    // }
                    if (li.ExpirationDate != DateTime.MinValue)
                    {
                        if (li.ExpirationDate < li.EffectiveDate)
                        {
                            display = "Expiration Date must be after Effective date";
                            ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true);
                            isFormFilled = false;
                        }
                    }

                    if (isFormFilled)
                    {
                        if (memberships == 1 || memberships == 2)
                        {
                            DataSet result = li.UpdateSKPickingBoard(li, memberships);

                            string res = Convert.ToString(result.Tables[0].Rows[0].ItemArray[0]);
                            if (res.Contains("Effective Date should be after"))
                            {
                                ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + res + "');", true);
                                isFormFilled = false;
                            }
                            else if (res.Contains("Expiration Date should be before"))
                            {
                                ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + res + "');", true);
                                isFormFilled = false;
                            }
                            if (res.Equals("Duplicate BusinessUnitCode"))
                            {
                                display = "BusinessUnit Code already exists in the database";
                                ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true);
                            }
                            else if (res.Equals("Duplicate BusinessUnitName"))
                            {
                                display = "BusinessUnit Name already exists in the database";
                                ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true);
                            }
                            else if (res.Equals("Success"))
                            {
                            }
                        }
                        else
                        {
                            display = "You must be a member of Consolidated Sales Reporting – Admin or Consolidated Sales Reporting – Finance  groups to make changes.";
                            ClientScript.RegisterStartupScript(this.GetType(), "yourMessage", "alert('" + display + "');", true);
                        }
                    }
                    //if (memberships > 0)
                    //{
                    //    li.UpdateSKPickingBoard(li, memberships);
                    //}
                    //else
                    //{
                    //    string display = "You must be a member of SK_Picking _Operations or SK_Picking_Warehouse groups to make changes.";
                    //    ClientScript.RegisterStartupScript(this.GetType(), "yourMessage", "alert('" + display + "');", true);
                    //}
                }
                catch (Exception ex)
                {
                    throw ex;
                }

                BusinessUnitGridView.EditIndex = -1;
                BindGridView();
            }
        }