public void BindProductNameGrid(ProductName_Model objModel, int page, int pageSize)
        {
            StringBuilder query   = new StringBuilder();
            var           colName = common.GetColumns(CommonFunction.module.ProductName.ToString());

            query = common.GetSqlTableQuery(CommonFunction.module.ProductName.ToString());
            if (objModel != null)
            {
                objModel.StaticPageSize = pageSize;
            }

            ProductNameManager context = new ProductNameManager(new DataContext());

            context.setModel(query, objModel, colName, "Productname", page, pageSize);
        }