public override bool CreateCustomBigType(CustomBigType customBigType)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("Insert Into CustomBigType(");
            strSql.Append("CustomBigTypeId,CustomBigTypeName");
            strSql.Append(") Values (");
            strSql.Append("@CustomBigTypeId,@CustomBigTypeName");
            strSql.Append(")");

            SqlParameter[] parameters = {
                new SqlParameter("@CustomBigTypeId", SqlDbType.UniqueIdentifier),
                new SqlParameter("@CustomBigTypeName", SqlDbType.NVarChar)
            };
            parameters[0].Value = customBigType.CustomBigTypeId;
            parameters[1].Value = customBigType.CustomBigTypeName;

            int rows;

            try
            {
                rows = DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
            }
            catch (SqlException ex)
            {
                throw ex;
            }

            return (rows > 0);
        }
        public static CustomBigType CreateInstance(bool isInitDefaultValue)
        {
            CustomBigType model = new CustomBigType();

            if (isInitDefaultValue)
            {
                model.CustomBigTypeId = Guid.NewGuid();
            }
            return model;
        }
        public override bool UpdateCustomBigType(CustomBigType customBigType)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("Update CustomBigType Set ");
            strSql.Append(@"CustomBigTypeName = @CustomBigTypeName");
            strSql.Append(" Where CustomBigTypeId = @CustomBigTypeId");

            SqlParameter[] paramArray = {
                new SqlParameter("@CustomBigTypeId", SqlDbType.UniqueIdentifier),
                new SqlParameter("@CustomBigTypeName", SqlDbType.NVarChar)
            };
            paramArray[0].Value = customBigType.CustomBigTypeId;
            paramArray[1].Value = customBigType.CustomBigTypeName;

            List<SqlParameter> parameters = new List<SqlParameter>();
            parameters.AddRange(paramArray);

            int rows;

            try
            {
                rows = DbHelperSQL.ExecuteSql(strSql.ToString(),parameters.ToArray());
            }
            catch (SqlException ex)
            {
                throw ex;
            }

            return (rows > 0);
        }
 public abstract bool UpdateCustomBigType(CustomBigType customBigType);
 public abstract bool CreateCustomBigType(CustomBigType customBigType);
        public CustomBigType PopulateCustomBigTypeFromIDataReader(IDataReader dr)
        {
            CustomBigType model = null;

            if (dr != null)
            {
                model = new CustomBigType();

                if (dr["CustomBigTypeId"] is System.DBNull)
                    model.CustomBigTypeId = null;
                else
                    model.CustomBigTypeId = (Guid)dr["CustomBigTypeId"];

                model.CustomBigTypeName = dr["CustomBigTypeName"].ToString();
            }
            return model;
        }
 public static bool Update(CustomBigType customBigType)
 {
     CommonDataProvider dp = CommonDataProvider.Instance();
     return dp.UpdateCustomBigType(customBigType);
 }