C# (CSharp) CanYou.Models.Info.LectureCategoryRequirement LectureCategoryRequirementItem Examples

Example #1

File: LectureCategoryRequirementDao.cs Project: jjoylee/CanYou

        public int Insert(LectureCategoryRequirementItem item)
        {
            string        query = "Insert into LectureCategoryRequirement(accountId,lectureCategoryId,cutline) VALUES(@AccountId,@LectureCategoryId,@Cutline)";
            IDbParameters param = CreateDbParameters();

            param.AddWithValue("AccountId", item.AccountId).DbType = DbType.Int32;
            param.AddWithValue("Cutline", item.Cutline).DbType     = DbType.Int32;
            param.AddWithValue("LectureCategoryId", item.LectureCategoryId).DbType = DbType.Int32;
            return(AdoTemplate.ExecuteNonQuery(CommandType.Text, query, param));
        }

Example #2

File: LectureCategoryRequirementDao.cs Project: jjoylee/CanYou

        public int Update(LectureCategoryRequirementItem item)
        {
            string        query = "UPDATE LectureCategoryRequirement SET accountId = @AccountId, cutline = @Cutline, lectureCategoryId = @LectureCategoryId where id = @Id";
            IDbParameters param = CreateDbParameters();

            param.AddWithValue("AccountId", item.AccountId).DbType = DbType.Int32;
            param.AddWithValue("Cutline", item.Cutline).DbType     = DbType.Int32;
            param.AddWithValue("Id", item.Id).DbType = DbType.Int32;
            param.AddWithValue("LectureCategoryId", item.LectureCategoryId).DbType = DbType.Int32;
            return(AdoTemplate.ExecuteNonQuery(CommandType.Text, query, param));
        }