void funSetGrid()
        {
            try
            {
                CtlGrid.Cols      = 4;
                CtlGrid.CanEdit   = true;
                CtlGrid.CanDelete = true;

                CtlGrid.Columns[0].Header = "ID";
                CtlGrid.Columns[1].Header = "Format Name";
                CtlGrid.Columns[2].Header = "Format Type";
                CtlGrid.Columns[3].Header = "Description";
                //CtlGrid.Columns[4].Header = "CreatedDate";
                //CtlGrid.Columns[5].Header = "CreatedBy";
                //CtlGrid.Columns[6].Header = "ModifiedDate";
                //CtlGrid.Columns[7].Header = "ModifeiedBy";

                CtlGrid.Columns[0].BindTo("ID");
                CtlGrid.Columns[1].BindTo("LeadFormatName");
                CtlGrid.Columns[2].BindTo("FormatType");
                CtlGrid.Columns[3].BindTo("Description");
                //CtlGrid.Columns[4].BindTo("CreatedDate");
                //CtlGrid.Columns[5].BindTo("CreatedBy");
                //CtlGrid.Columns[6].BindTo("ModifiedDate");
                //CtlGrid.Columns[7].BindTo("ModifiedBy");

                objLeadCollection = ClsLeadFormatBusinessCollection.GetAll();
                CtlGrid.Bind(objLeadCollection);
                //objLeadCollection = null;
            }
            catch (Exception ex)
            {
                VMuktiHelper.ExceptionHandler(ex, "funSetGrid()", "ctlLeadFormatDesigner.xaml.cs");
            }
        }
        void funSetChildGrid(Int64 FormatID)
        {
            try
            {
                parentRow = FormatID;
                CtlGridChild.CanEdit = true;
                CtlGridChild.CanDelete = true;
                if (cmbFormatType.SelectionBoxItem.ToString().ToLower() == "text")
                {
                    CtlGridChild.Width = 560;
                    CtlGridChild.Cols = 6;
                    CtlGridChild.Columns[0].Header = "ID";
                    CtlGridChild.Columns[1].Header = "FieldName";
                    CtlGridChild.Columns[2].Header = "DefaultValue";
                    CtlGridChild.Columns[3].Header = "Start Position";
                    CtlGridChild.Columns[4].Header = "Length";
                    CtlGridChild.Columns[5].Header = "Delimiters";
                    CtlGridChild.Columns[4].BindTo("Length");
                    CtlGridChild.Columns[5].BindTo("Delimiters");
                }
                else
                {
                    CtlGridChild.Width = 380;
                    CtlGridChild.Cols = 4;
                    CtlGridChild.Columns[0].Header = "ID";
                    CtlGridChild.Columns[1].Header = "FieldName";
                    CtlGridChild.Columns[2].Header = "DefaultValue";
                    CtlGridChild.Columns[3].Header = "MapColumn";
                }
                CtlGridChild.Cols = 4;
                
                CtlGridChild.Columns[0].BindTo("LeadFieldsID");
                CtlGridChild.Columns[1].BindTo("FieldName");
                CtlGridChild.Columns[2].BindTo("DefaultValue");
                CtlGridChild.Columns[3].BindTo("StartPosition");

                objLeadFieldsCollection = ClsLeadFormatBusinessCollection.GetAllLeadFields(FormatID);
                CtlGridChild.Bind(objLeadFieldsCollection);

                //Remove binded columns

                //int i;
                //int j;

                //for (i = 0; i < objLeadFieldsCollection.Count; i++)
                //{
                //    for (j = 0;j<cmbColumn.Items.Count; j++)
                //    {
                //        if (cmbColumn.Items[j].ToString() == objLeadFieldsCollection[i].StartPosition.ToString())
                //        {
                //            //Check the binded column
                //        }
                //    }
                //    cmbColumn.Items.RemoveAt(objLeadFieldsCollection[i].StartPosition-1);
                //    MessageBox.Show((objLeadFieldsCollection[i].StartPosition - 1).ToString());
                //}
            }
            catch (Exception ex)
            {
                VMuktiHelper.ExceptionHandler(ex, "funSetChildGrid()", "ctlLeadFormatDesigner.xaml.cs");
            }
        }
        void funSetGrid()
        {
            try
            {
                CtlGrid.Cols = 4;
                CtlGrid.CanEdit = true;
                CtlGrid.CanDelete = true;

                CtlGrid.Columns[0].Header = "ID";
                CtlGrid.Columns[1].Header = "Format Name";
                CtlGrid.Columns[2].Header = "Format Type";
                CtlGrid.Columns[3].Header = "Description";
                //CtlGrid.Columns[4].Header = "CreatedDate";
                //CtlGrid.Columns[5].Header = "CreatedBy";
                //CtlGrid.Columns[6].Header = "ModifiedDate";
                //CtlGrid.Columns[7].Header = "ModifeiedBy";

                CtlGrid.Columns[0].BindTo("ID");
                CtlGrid.Columns[1].BindTo("LeadFormatName");
                CtlGrid.Columns[2].BindTo("FormatType");
                CtlGrid.Columns[3].BindTo("Description");
                //CtlGrid.Columns[4].BindTo("CreatedDate");
                //CtlGrid.Columns[5].BindTo("CreatedBy");
                //CtlGrid.Columns[6].BindTo("ModifiedDate");
                //CtlGrid.Columns[7].BindTo("ModifiedBy");

                objLeadCollection = ClsLeadFormatBusinessCollection.GetAll();
                CtlGrid.Bind(objLeadCollection);
                //objLeadCollection = null;
                
            }
            catch (Exception ex)
            {
                VMuktiHelper.ExceptionHandler(ex, "funSetGrid()", "ctlLeadFormatDesigner.xaml.cs");
            }
        }
        void funSetChildGrid(Int64 FormatID)
        {
            try
            {
                parentRow              = FormatID;
                CtlGridChild.CanEdit   = true;
                CtlGridChild.CanDelete = true;
                if (cmbFormatType.SelectionBoxItem.ToString().ToLower() == "text")
                {
                    CtlGridChild.Width             = 560;
                    CtlGridChild.Cols              = 6;
                    CtlGridChild.Columns[0].Header = "ID";
                    CtlGridChild.Columns[1].Header = "FieldName";
                    CtlGridChild.Columns[2].Header = "DefaultValue";
                    CtlGridChild.Columns[3].Header = "Start Position";
                    CtlGridChild.Columns[4].Header = "Length";
                    CtlGridChild.Columns[5].Header = "Delimiters";
                    CtlGridChild.Columns[4].BindTo("Length");
                    CtlGridChild.Columns[5].BindTo("Delimiters");
                }
                else
                {
                    CtlGridChild.Width             = 380;
                    CtlGridChild.Cols              = 4;
                    CtlGridChild.Columns[0].Header = "ID";
                    CtlGridChild.Columns[1].Header = "FieldName";
                    CtlGridChild.Columns[2].Header = "DefaultValue";
                    CtlGridChild.Columns[3].Header = "MapColumn";
                }
                CtlGridChild.Cols = 4;

                CtlGridChild.Columns[0].BindTo("LeadFieldsID");
                CtlGridChild.Columns[1].BindTo("FieldName");
                CtlGridChild.Columns[2].BindTo("DefaultValue");
                CtlGridChild.Columns[3].BindTo("StartPosition");

                objLeadFieldsCollection = ClsLeadFormatBusinessCollection.GetAllLeadFields(FormatID);
                CtlGridChild.Bind(objLeadFieldsCollection);

                //Remove binded columns

                //int i;
                //int j;

                //for (i = 0; i < objLeadFieldsCollection.Count; i++)
                //{
                //    for (j = 0;j<cmbColumn.Items.Count; j++)
                //    {
                //        if (cmbColumn.Items[j].ToString() == objLeadFieldsCollection[i].StartPosition.ToString())
                //        {
                //            //Check the binded column
                //        }
                //    }
                //    cmbColumn.Items.RemoveAt(objLeadFieldsCollection[i].StartPosition-1);
                //    MessageBox.Show((objLeadFieldsCollection[i].StartPosition - 1).ToString());
                //}
            }
            catch (Exception ex)
            {
                VMuktiHelper.ExceptionHandler(ex, "funSetChildGrid()", "ctlLeadFormatDesigner.xaml.cs");
            }
        }