public static void InsertProduct(ref Products P)
        {
            SqlCeCommand com = DBCon.CeCon.CreateCommand();

            com.CommandText = "INSERT INTO PRODUCTS (PRODUCT_CODE, PRODUCT_NAME, PRODUCT_IMAGE) VALUES (@PRODUCT_CODE, @PRODUCT_NAME, @PRODUCT_IMAGE);";
            com.Parameters.AddWithValue("PRODUCT_CODE", P.PRODUCT_CODE == null ? (object)DBNull.Value : P.PRODUCT_CODE);
            com.Parameters.AddWithValue("PRODUCT_NAME", P.PRODUCT_NAME == null ? (object)DBNull.Value : P.PRODUCT_NAME);
            com.Parameters.AddWithValue("PRODUCT_IMAGE", P.PRODUCT_IMAGE == null ? (object)DBNull.Value : P.PRODUCT_IMAGE.ToArrayOfBytes());
            com.ExecuteNonQuery();
            com.Dispose();
            P = ProductsOP.GetProduct(P.PRODUCT_CODE);
        }