private void UpdateRecord()
        {
            dbo_DimPromotionClass oclsdbo_DimPromotion = new dbo_DimPromotionClass();
            dbo_DimPromotionClass clsdbo_DimPromotion  = new dbo_DimPromotionClass();

            oclsdbo_DimPromotion.PromotionKey = System.Convert.ToInt32(Session["PromotionKey"]);
            oclsdbo_DimPromotion = dbo_DimPromotionDataClass.Select_Record(oclsdbo_DimPromotion);

            if (VerifyData() == true)
            {
                SetData(clsdbo_DimPromotion);
                bool bSucess = false;
                bSucess = dbo_DimPromotionDataClass.Update(oclsdbo_DimPromotion, clsdbo_DimPromotion);
                if (bSucess == true)
                {
                    pnlForm.Visible   = false;
                    pnlSave.Visible   = false;
                    pnlGrid.Visible   = true;
                    lblMode.InnerText = "";
                    Session.Remove("dvdbo_DimPromotion");
                    LoadGriddbo_DimPromotion();
                }
                else
                {
                    ec.ShowMessage(" Update failed. ", " Dbo. Dim Promotion ");
                }
            }
        }
        private void Edit()
        {
            try {
                dbo_DimPromotionClass clsdbo_DimPromotion = new dbo_DimPromotionClass();
                Label lblPromotionKey = (Label)grddbo_DimPromotion.Rows[grddbo_DimPromotion.EditIndex].FindControl("lblPromotionKey");
                clsdbo_DimPromotion.PromotionKey = System.Convert.ToInt32(lblPromotionKey.Text);
                clsdbo_DimPromotion = dbo_DimPromotionDataClass.Select_Record(clsdbo_DimPromotion);


                LoadGriddbo_DimPromotion();
            } catch {
            }
        }
        private void DeleteRecord()
        {
            dbo_DimPromotionClass clsdbo_DimPromotion = new dbo_DimPromotionClass();
            Label lblPromotionKey = (Label)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblPromotionKey");

            clsdbo_DimPromotion.PromotionKey = System.Convert.ToInt32(lblPromotionKey.Text);
            clsdbo_DimPromotion = dbo_DimPromotionDataClass.Select_Record(clsdbo_DimPromotion);
            bool bSucess = false;

            bSucess = dbo_DimPromotionDataClass.Delete(clsdbo_DimPromotion);
            if (bSucess == true)
            {
                Session.Remove("dvdbo_DimPromotion");
                LoadGriddbo_DimPromotion();
            }
            else
            {
                ec.ShowMessage(" Delete failed. ", " Dbo. Dim Promotion ");
            }
        }
        private void InsertRecord()
        {
            dbo_DimPromotionClass clsdbo_DimPromotion = new dbo_DimPromotionClass();

            if (VerifyData() == true)
            {
                SetData(clsdbo_DimPromotion);
                bool bSucess = false;
                bSucess = dbo_DimPromotionDataClass.Add(clsdbo_DimPromotion);
                if (bSucess == true)
                {
                    pnlForm.Visible   = false;
                    pnlSave.Visible   = false;
                    pnlGrid.Visible   = true;
                    lblMode.InnerText = "";
                    Session.Remove("dvdbo_DimPromotion");
                    LoadGriddbo_DimPromotion();
                }
                else
                {
                    ec.ShowMessage(" Insert failed. ", " Dbo. Dim Promotion ");
                }
            }
        }
        private void UpdateRecord()
        {
            try {
                TextBox txtPromotionKey             = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtPromotionKey");
                TextBox txtPromotionAlternateKey    = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtPromotionAlternateKey");
                TextBox txtEnglishPromotionName     = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtEnglishPromotionName");
                TextBox txtSpanishPromotionName     = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSpanishPromotionName");
                TextBox txtFrenchPromotionName      = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtFrenchPromotionName");
                TextBox txtDiscountPct              = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtDiscountPct");
                TextBox txtEnglishPromotionType     = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtEnglishPromotionType");
                TextBox txtSpanishPromotionType     = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSpanishPromotionType");
                TextBox txtFrenchPromotionType      = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtFrenchPromotionType");
                TextBox txtEnglishPromotionCategory = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtEnglishPromotionCategory");
                TextBox txtSpanishPromotionCategory = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSpanishPromotionCategory");
                TextBox txtFrenchPromotionCategory  = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtFrenchPromotionCategory");
                TextBox txtStartDate = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtStartDate");
                TextBox txtEndDate   = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtEndDate");
                TextBox txtMinQty    = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtMinQty");
                TextBox txtMaxQty    = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtMaxQty");

                dbo_DimPromotionClass oclsdbo_DimPromotion = new dbo_DimPromotionClass();
                dbo_DimPromotionClass clsdbo_DimPromotion  = new dbo_DimPromotionClass();
                oclsdbo_DimPromotion.PromotionKey = System.Convert.ToInt32(txtPromotionKey.Text);
                oclsdbo_DimPromotion = dbo_DimPromotionDataClass.Select_Record(oclsdbo_DimPromotion);

                if (VerifyData() == true)
                {
                    if (string.IsNullOrEmpty(txtPromotionAlternateKey.Text))
                    {
                        clsdbo_DimPromotion.PromotionAlternateKey = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.PromotionAlternateKey = System.Convert.ToInt32(txtPromotionAlternateKey.Text);
                    }
                    if (string.IsNullOrEmpty(txtEnglishPromotionName.Text))
                    {
                        clsdbo_DimPromotion.EnglishPromotionName = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.EnglishPromotionName = txtEnglishPromotionName.Text;
                    }
                    if (string.IsNullOrEmpty(txtSpanishPromotionName.Text))
                    {
                        clsdbo_DimPromotion.SpanishPromotionName = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.SpanishPromotionName = txtSpanishPromotionName.Text;
                    }
                    if (string.IsNullOrEmpty(txtFrenchPromotionName.Text))
                    {
                        clsdbo_DimPromotion.FrenchPromotionName = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.FrenchPromotionName = txtFrenchPromotionName.Text;
                    }
                    if (string.IsNullOrEmpty(txtDiscountPct.Text))
                    {
                        clsdbo_DimPromotion.DiscountPct = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.DiscountPct = System.Convert.ToDecimal(txtDiscountPct.Text);
                    }
                    if (string.IsNullOrEmpty(txtEnglishPromotionType.Text))
                    {
                        clsdbo_DimPromotion.EnglishPromotionType = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.EnglishPromotionType = txtEnglishPromotionType.Text;
                    }
                    if (string.IsNullOrEmpty(txtSpanishPromotionType.Text))
                    {
                        clsdbo_DimPromotion.SpanishPromotionType = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.SpanishPromotionType = txtSpanishPromotionType.Text;
                    }
                    if (string.IsNullOrEmpty(txtFrenchPromotionType.Text))
                    {
                        clsdbo_DimPromotion.FrenchPromotionType = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.FrenchPromotionType = txtFrenchPromotionType.Text;
                    }
                    if (string.IsNullOrEmpty(txtEnglishPromotionCategory.Text))
                    {
                        clsdbo_DimPromotion.EnglishPromotionCategory = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.EnglishPromotionCategory = txtEnglishPromotionCategory.Text;
                    }
                    if (string.IsNullOrEmpty(txtSpanishPromotionCategory.Text))
                    {
                        clsdbo_DimPromotion.SpanishPromotionCategory = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.SpanishPromotionCategory = txtSpanishPromotionCategory.Text;
                    }
                    if (string.IsNullOrEmpty(txtFrenchPromotionCategory.Text))
                    {
                        clsdbo_DimPromotion.FrenchPromotionCategory = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.FrenchPromotionCategory = txtFrenchPromotionCategory.Text;
                    }
                    clsdbo_DimPromotion.StartDate = System.Convert.ToDateTime(txtStartDate.Text);
                    if (string.IsNullOrEmpty(txtEndDate.Text))
                    {
                        clsdbo_DimPromotion.EndDate = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.EndDate = System.Convert.ToDateTime(txtEndDate.Text);
                    }
                    if (string.IsNullOrEmpty(txtMinQty.Text))
                    {
                        clsdbo_DimPromotion.MinQty = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.MinQty = System.Convert.ToInt32(txtMinQty.Text);
                    }
                    if (string.IsNullOrEmpty(txtMaxQty.Text))
                    {
                        clsdbo_DimPromotion.MaxQty = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.MaxQty = System.Convert.ToInt32(txtMaxQty.Text);
                    }
                    bool bSucess = false;
                    bSucess = dbo_DimPromotionDataClass.Update(oclsdbo_DimPromotion, clsdbo_DimPromotion);
                    if (bSucess == true)
                    {
                        Session.Remove("dvdbo_DimPromotion");
                        grddbo_DimPromotion.EditIndex = -1;
                        LoadGriddbo_DimPromotion();
                    }
                    else
                    {
                        ec.ShowMessage(" Update failed. ", " Dbo. Dim Promotion ");
                    }
                }
            } catch {
            }
        }
        private void InsertRecord()
        {
            try {
                TextBox txtNewPromotionAlternateKey    = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewPromotionAlternateKey");
                TextBox txtNewEnglishPromotionName     = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewEnglishPromotionName");
                TextBox txtNewSpanishPromotionName     = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewSpanishPromotionName");
                TextBox txtNewFrenchPromotionName      = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewFrenchPromotionName");
                TextBox txtNewDiscountPct              = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewDiscountPct");
                TextBox txtNewEnglishPromotionType     = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewEnglishPromotionType");
                TextBox txtNewSpanishPromotionType     = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewSpanishPromotionType");
                TextBox txtNewFrenchPromotionType      = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewFrenchPromotionType");
                TextBox txtNewEnglishPromotionCategory = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewEnglishPromotionCategory");
                TextBox txtNewSpanishPromotionCategory = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewSpanishPromotionCategory");
                TextBox txtNewFrenchPromotionCategory  = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewFrenchPromotionCategory");
                TextBox txtNewStartDate = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewStartDate");
                TextBox txtNewEndDate   = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewEndDate");
                TextBox txtNewMinQty    = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewMinQty");
                TextBox txtNewMaxQty    = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewMaxQty");

                dbo_DimPromotionClass clsdbo_DimPromotion = new dbo_DimPromotionClass();
                if (VerifyDataNew() == true)
                {
                    if (string.IsNullOrEmpty(txtNewPromotionAlternateKey.Text))
                    {
                        clsdbo_DimPromotion.PromotionAlternateKey = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.PromotionAlternateKey = System.Convert.ToInt32(txtNewPromotionAlternateKey.Text);
                    }
                    if (string.IsNullOrEmpty(txtNewEnglishPromotionName.Text))
                    {
                        clsdbo_DimPromotion.EnglishPromotionName = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.EnglishPromotionName = txtNewEnglishPromotionName.Text;
                    }
                    if (string.IsNullOrEmpty(txtNewSpanishPromotionName.Text))
                    {
                        clsdbo_DimPromotion.SpanishPromotionName = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.SpanishPromotionName = txtNewSpanishPromotionName.Text;
                    }
                    if (string.IsNullOrEmpty(txtNewFrenchPromotionName.Text))
                    {
                        clsdbo_DimPromotion.FrenchPromotionName = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.FrenchPromotionName = txtNewFrenchPromotionName.Text;
                    }
                    if (string.IsNullOrEmpty(txtNewDiscountPct.Text))
                    {
                        clsdbo_DimPromotion.DiscountPct = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.DiscountPct = System.Convert.ToDecimal(txtNewDiscountPct.Text);
                    }
                    if (string.IsNullOrEmpty(txtNewEnglishPromotionType.Text))
                    {
                        clsdbo_DimPromotion.EnglishPromotionType = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.EnglishPromotionType = txtNewEnglishPromotionType.Text;
                    }
                    if (string.IsNullOrEmpty(txtNewSpanishPromotionType.Text))
                    {
                        clsdbo_DimPromotion.SpanishPromotionType = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.SpanishPromotionType = txtNewSpanishPromotionType.Text;
                    }
                    if (string.IsNullOrEmpty(txtNewFrenchPromotionType.Text))
                    {
                        clsdbo_DimPromotion.FrenchPromotionType = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.FrenchPromotionType = txtNewFrenchPromotionType.Text;
                    }
                    if (string.IsNullOrEmpty(txtNewEnglishPromotionCategory.Text))
                    {
                        clsdbo_DimPromotion.EnglishPromotionCategory = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.EnglishPromotionCategory = txtNewEnglishPromotionCategory.Text;
                    }
                    if (string.IsNullOrEmpty(txtNewSpanishPromotionCategory.Text))
                    {
                        clsdbo_DimPromotion.SpanishPromotionCategory = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.SpanishPromotionCategory = txtNewSpanishPromotionCategory.Text;
                    }
                    if (string.IsNullOrEmpty(txtNewFrenchPromotionCategory.Text))
                    {
                        clsdbo_DimPromotion.FrenchPromotionCategory = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.FrenchPromotionCategory = txtNewFrenchPromotionCategory.Text;
                    }
                    clsdbo_DimPromotion.StartDate = System.Convert.ToDateTime(txtNewStartDate.Text);
                    if (string.IsNullOrEmpty(txtNewEndDate.Text))
                    {
                        clsdbo_DimPromotion.EndDate = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.EndDate = System.Convert.ToDateTime(txtNewEndDate.Text);
                    }
                    if (string.IsNullOrEmpty(txtNewMinQty.Text))
                    {
                        clsdbo_DimPromotion.MinQty = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.MinQty = System.Convert.ToInt32(txtNewMinQty.Text);
                    }
                    if (string.IsNullOrEmpty(txtNewMaxQty.Text))
                    {
                        clsdbo_DimPromotion.MaxQty = null;
                    }
                    else
                    {
                        clsdbo_DimPromotion.MaxQty = System.Convert.ToInt32(txtNewMaxQty.Text);
                    }
                    bool bSucess = false;
                    bSucess = dbo_DimPromotionDataClass.Add(clsdbo_DimPromotion);
                    if (bSucess == true)
                    {
                        Session.Remove("dvdbo_DimPromotion");
                        LoadGriddbo_DimPromotion();
                    }
                    else
                    {
                        ec.ShowMessage(" Insert failed. ", " Dbo. Dim Promotion ");
                    }
                }
            } catch {
            }
        }
 private void SetData(dbo_DimPromotionClass clsdbo_DimPromotion)
 {
     if (string.IsNullOrEmpty(txtPromotionAlternateKey.Text))
     {
         clsdbo_DimPromotion.PromotionAlternateKey = null;
     }
     else
     {
         clsdbo_DimPromotion.PromotionAlternateKey = System.Convert.ToInt32(txtPromotionAlternateKey.Text);
     }
     if (string.IsNullOrEmpty(txtEnglishPromotionName.Text))
     {
         clsdbo_DimPromotion.EnglishPromotionName = null;
     }
     else
     {
         clsdbo_DimPromotion.EnglishPromotionName = txtEnglishPromotionName.Text;
     }
     if (string.IsNullOrEmpty(txtSpanishPromotionName.Text))
     {
         clsdbo_DimPromotion.SpanishPromotionName = null;
     }
     else
     {
         clsdbo_DimPromotion.SpanishPromotionName = txtSpanishPromotionName.Text;
     }
     if (string.IsNullOrEmpty(txtFrenchPromotionName.Text))
     {
         clsdbo_DimPromotion.FrenchPromotionName = null;
     }
     else
     {
         clsdbo_DimPromotion.FrenchPromotionName = txtFrenchPromotionName.Text;
     }
     if (string.IsNullOrEmpty(txtDiscountPct.Text))
     {
         clsdbo_DimPromotion.DiscountPct = null;
     }
     else
     {
         clsdbo_DimPromotion.DiscountPct = System.Convert.ToDecimal(txtDiscountPct.Text);
     }
     if (string.IsNullOrEmpty(txtEnglishPromotionType.Text))
     {
         clsdbo_DimPromotion.EnglishPromotionType = null;
     }
     else
     {
         clsdbo_DimPromotion.EnglishPromotionType = txtEnglishPromotionType.Text;
     }
     if (string.IsNullOrEmpty(txtSpanishPromotionType.Text))
     {
         clsdbo_DimPromotion.SpanishPromotionType = null;
     }
     else
     {
         clsdbo_DimPromotion.SpanishPromotionType = txtSpanishPromotionType.Text;
     }
     if (string.IsNullOrEmpty(txtFrenchPromotionType.Text))
     {
         clsdbo_DimPromotion.FrenchPromotionType = null;
     }
     else
     {
         clsdbo_DimPromotion.FrenchPromotionType = txtFrenchPromotionType.Text;
     }
     if (string.IsNullOrEmpty(txtEnglishPromotionCategory.Text))
     {
         clsdbo_DimPromotion.EnglishPromotionCategory = null;
     }
     else
     {
         clsdbo_DimPromotion.EnglishPromotionCategory = txtEnglishPromotionCategory.Text;
     }
     if (string.IsNullOrEmpty(txtSpanishPromotionCategory.Text))
     {
         clsdbo_DimPromotion.SpanishPromotionCategory = null;
     }
     else
     {
         clsdbo_DimPromotion.SpanishPromotionCategory = txtSpanishPromotionCategory.Text;
     }
     if (string.IsNullOrEmpty(txtFrenchPromotionCategory.Text))
     {
         clsdbo_DimPromotion.FrenchPromotionCategory = null;
     }
     else
     {
         clsdbo_DimPromotion.FrenchPromotionCategory = txtFrenchPromotionCategory.Text;
     }
     clsdbo_DimPromotion.StartDate = System.Convert.ToDateTime(txtStartDate.Text);
     if (string.IsNullOrEmpty(txtEndDate.Text))
     {
         clsdbo_DimPromotion.EndDate = null;
     }
     else
     {
         clsdbo_DimPromotion.EndDate = System.Convert.ToDateTime(txtEndDate.Text);
     }
     if (string.IsNullOrEmpty(txtMinQty.Text))
     {
         clsdbo_DimPromotion.MinQty = null;
     }
     else
     {
         clsdbo_DimPromotion.MinQty = System.Convert.ToInt32(txtMinQty.Text);
     }
     if (string.IsNullOrEmpty(txtMaxQty.Text))
     {
         clsdbo_DimPromotion.MaxQty = null;
     }
     else
     {
         clsdbo_DimPromotion.MaxQty = System.Convert.ToInt32(txtMaxQty.Text);
     }
 }
        private void GetData()
        {
            ClearRecord();

            dbo_DimPromotionClass clsdbo_DimPromotion = new dbo_DimPromotionClass();

            clsdbo_DimPromotion.PromotionKey = System.Convert.ToInt32(Session["PromotionKey"]);
            clsdbo_DimPromotion = dbo_DimPromotionDataClass.Select_Record(clsdbo_DimPromotion);

            if ((clsdbo_DimPromotion != null))
            {
                try {
                    txtPromotionKey.Text = System.Convert.ToString(clsdbo_DimPromotion.PromotionKey);
                    if (clsdbo_DimPromotion.PromotionAlternateKey == null)
                    {
                        txtPromotionAlternateKey.Text = default(string);
                    }
                    else
                    {
                        txtPromotionAlternateKey.Text = System.Convert.ToString(clsdbo_DimPromotion.PromotionAlternateKey);
                    }
                    if (clsdbo_DimPromotion.EnglishPromotionName == null)
                    {
                        txtEnglishPromotionName.Text = default(string);
                    }
                    else
                    {
                        txtEnglishPromotionName.Text = System.Convert.ToString(clsdbo_DimPromotion.EnglishPromotionName);
                    }
                    if (clsdbo_DimPromotion.SpanishPromotionName == null)
                    {
                        txtSpanishPromotionName.Text = default(string);
                    }
                    else
                    {
                        txtSpanishPromotionName.Text = System.Convert.ToString(clsdbo_DimPromotion.SpanishPromotionName);
                    }
                    if (clsdbo_DimPromotion.FrenchPromotionName == null)
                    {
                        txtFrenchPromotionName.Text = default(string);
                    }
                    else
                    {
                        txtFrenchPromotionName.Text = System.Convert.ToString(clsdbo_DimPromotion.FrenchPromotionName);
                    }
                    if (clsdbo_DimPromotion.DiscountPct == null)
                    {
                        txtDiscountPct.Text = default(string);
                    }
                    else
                    {
                        txtDiscountPct.Text = System.Convert.ToString(clsdbo_DimPromotion.DiscountPct);
                    }
                    if (clsdbo_DimPromotion.EnglishPromotionType == null)
                    {
                        txtEnglishPromotionType.Text = default(string);
                    }
                    else
                    {
                        txtEnglishPromotionType.Text = System.Convert.ToString(clsdbo_DimPromotion.EnglishPromotionType);
                    }
                    if (clsdbo_DimPromotion.SpanishPromotionType == null)
                    {
                        txtSpanishPromotionType.Text = default(string);
                    }
                    else
                    {
                        txtSpanishPromotionType.Text = System.Convert.ToString(clsdbo_DimPromotion.SpanishPromotionType);
                    }
                    if (clsdbo_DimPromotion.FrenchPromotionType == null)
                    {
                        txtFrenchPromotionType.Text = default(string);
                    }
                    else
                    {
                        txtFrenchPromotionType.Text = System.Convert.ToString(clsdbo_DimPromotion.FrenchPromotionType);
                    }
                    if (clsdbo_DimPromotion.EnglishPromotionCategory == null)
                    {
                        txtEnglishPromotionCategory.Text = default(string);
                    }
                    else
                    {
                        txtEnglishPromotionCategory.Text = System.Convert.ToString(clsdbo_DimPromotion.EnglishPromotionCategory);
                    }
                    if (clsdbo_DimPromotion.SpanishPromotionCategory == null)
                    {
                        txtSpanishPromotionCategory.Text = default(string);
                    }
                    else
                    {
                        txtSpanishPromotionCategory.Text = System.Convert.ToString(clsdbo_DimPromotion.SpanishPromotionCategory);
                    }
                    if (clsdbo_DimPromotion.FrenchPromotionCategory == null)
                    {
                        txtFrenchPromotionCategory.Text = default(string);
                    }
                    else
                    {
                        txtFrenchPromotionCategory.Text = System.Convert.ToString(clsdbo_DimPromotion.FrenchPromotionCategory);
                    }
                    txtStartDate.Text = System.Convert.ToDateTime(clsdbo_DimPromotion.StartDate).ToShortDateString();
                    if (clsdbo_DimPromotion.EndDate == null)
                    {
                        txtEndDate.Text = DateTime.Now.ToString();
                    }
                    else
                    {
                        txtEndDate.Text = System.Convert.ToDateTime(clsdbo_DimPromotion.EndDate).ToShortDateString();
                    }
                    if (clsdbo_DimPromotion.MinQty == null)
                    {
                        txtMinQty.Text = default(string);
                    }
                    else
                    {
                        txtMinQty.Text = System.Convert.ToString(clsdbo_DimPromotion.MinQty);
                    }
                    if (clsdbo_DimPromotion.MaxQty == null)
                    {
                        txtMaxQty.Text = default(string);
                    }
                    else
                    {
                        txtMaxQty.Text = System.Convert.ToString(clsdbo_DimPromotion.MaxQty);
                    }
                }
                catch (Exception ex)
                {
                    ec.ShowMessage(ex.Message, " Dbo. Dim Promotion ");
                }
            }
        }