private static GroupXFilesBE FillDataRecord(IDataRecord dr)
        {
            GroupXFilesBE  objGroupXFilesBE = new GroupXFilesBE();
            if (!dr.IsDBNull(dr.GetOrdinal("GroupXFileId")))
            {
                objGroupXFilesBE.GroupXFileId = dr.GetInt32(dr.GetOrdinal("GroupXFileId"));
            }

            if (!dr.IsDBNull(dr.GetOrdinal("GroupId")))
            {
                objGroupXFilesBE.GroupId = dr.GetInt32(dr.GetOrdinal("GroupId"));
            }

            if (!dr.IsDBNull(dr.GetOrdinal("FileId")))
            {
                objGroupXFilesBE.FileId = dr.GetInt32(dr.GetOrdinal("FileId"));
            }

            if (!dr.IsDBNull(dr.GetOrdinal("Category")))
            {
                objGroupXFilesBE.Category = dr.GetString(dr.GetOrdinal("Category"));
            }

            return objGroupXFilesBE;
        }
        public static int save(GroupXFilesBE objGroupXFilesBE)
        {
            List<GenralizeParametre> objListGroupXFileParam=new List<GenralizeParametre>();
            objListGroupXFileParam.Add(new GenralizeParametre("GroupXFileId", objGroupXFilesBE.GroupXFileId, DbType.Int32));
            objListGroupXFileParam.Add(new GenralizeParametre("GroupId", objGroupXFilesBE.GroupId, DbType.Int32));
            objListGroupXFileParam.Add(new GenralizeParametre("FileId", objGroupXFilesBE.FileId, DbType.Int32));
            objListGroupXFileParam.Add(new GenralizeParametre("Category", objGroupXFilesBE.Category, DbType.String));
            objGroupXFilesBE.GroupXFileId=GenralizeStoredProcedure.GetInt (spGroupXFilesSave,objListGroupXFileParam);

            return objGroupXFilesBE.GroupXFileId;
        }